Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table psmops_ps1_mdrm137.det_rawattr_v2 | Generated by SchemaSpy

Related columns Constraint names Comments Legend |
Legend: |
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
det_id | bigint | 20 | √ |  | null |  |
detections.det_id | det_rawattr_v2_ibfk_1
psf_chi2 | float | 12 | √ |  | null |  |  |
psf_dof | int | 11 | √ |  | null |  |  |
cr_sig | float | 12 | √ |  | null |  |  |
ext_sig | float | 12 | √ |  | null |  |  |
psf_major | float | 12 | √ |  | null |  |  |
psf_minor | float | 12 | √ |  | null |  |  |
psf_theta | float | 12 | √ |  | null |  |  |
psf_quality | float | 12 | √ |  | null |  |  |
psf_npix | int | 11 | √ |  | null |  |  |
moments_xx | float | 12 | √ |  | null |  |  |
moments_xy | float | 12 | √ |  | null |  |  |
moments_yy | float | 12 | √ |  | null |  |  |
n_pos | int | 11 | √ |  | null |  |  |
f_pos | float | 12 | √ |  | null |  |  |
ratio_bad | float | 12 | √ |  | null |  |  |
ratio_mask | float | 12 | √ |  | null |  |  |
ratio_all | float | 12 | √ |  | null |  |  |
flags | int | 11 | √ |  | null |  |  |
ipp_idet | int | 11 | √ |  | null |  |  |
psf_inst_flux | float | 12 | √ |  | null |  |  |
psf_inst_flux_sig | float | 12 | √ |  | null |  |  |
ap_mag | float | 12 | √ |  | null |  |  |
ap_mag_raw | float | 12 | √ |  | null |  |  |
ap_mag_radius | float | 12 | √ |  | null |  |  |
ap_flux | float | 12 | √ |  | null |  |  |
ap_flux_sig | float | 12 | √ |  | null |  |  |
peak_flux_as_mag | float | 12 | √ |  | null |  |  |
cal_psf_mag | float | 12 | √ |  | null |  |  |
cal_psf_mag_sig | float | 12 | √ |  | null |  |  |
sky | float | 12 | √ |  | null |  |  |
sky_sigma | float | 12 | √ |  | null |  |  |
psf_qf_perfect | float | 12 | √ |  | null |  |  |
moments_r1 | float | 12 | √ |  | null |  |  |
moments_rh | float | 12 | √ |  | null |  |  |
kron_flux | float | 12 | √ |  | null |  |  |
kron_flux_err | float | 12 | √ |  | null |  |  |
kron_flux_inner | float | 12 | √ |  | null |  |  |
kron_flux_outer | float | 12 | √ |  | null |  |  |
diff_r_p | float | 12 | √ |  | null |  |  |
diff_sn_p | float | 12 | √ |  | null |  |  |
diff_r_m | float | 12 | √ |  | null |  |  |
diff_sn_m | float | 12 | √ |  | null |  |  |
flags2 | int | 11 | √ |  | null |  |  |
n_frames | int | 11 | √ |  | null |  |  |
Table contained 0 rows at Thu Apr 21 06:56 HST 2011

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
det_id | Performance | Asc | det_id

Close relationships within one two degrees of separation: