Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table psmops_ps1_mdrm137.detections | 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 |  | √ |  |
det_rawattr_v2.det_id | det_rawattr_v2_ibfk_1
export_dets.det_id | export_dets_ibfk_2
residuals.det_id | residuals_ibfk_1
tracklet_attrib.det_id | tracklet_attrib_ibfk_2
|  | auto_increment
field_id | bigint | 20 | √ |  | null |  |
fields.field_id | detections_ibfk_2
ra_deg | double | 22 |  |  |  |  |  |
dec_deg | double | 22 |  |  |  |  |  |
epoch_mjd | double | 22 |  |  |  |  |  |
mag | float | 12 |  |  |  |  |  |
ref_mag | float | 12 | √ |  | null |  |  |
filter_id | char | 2 |  |  |  |  |
filter_info.filter_id | detections_ibfk_1
s2n | float | 12 | √ |  | null |  |  |
ra_sigma_deg | float | 12 | √ |  | null |  |  |
dec_sigma_deg | float | 12 | √ |  | null |  |  |
mag_sigma | float | 12 | √ |  | null |  |  |
orient_deg | float | 12 | √ |  | null |  |  |
length_deg | float | 12 | √ |  | null |  |  |
object_name | varbinary | 32 | √ |  | null |  |  |
obscode | char | 3 | √ |  | null |  |  |
is_synthetic | char | 1 | √ |  | null |  |  |
det_num | bigint | 20 | √ |  | null |  |  |
status | char | 1 | √ |  | null |  |  |
xyidx | int | 11 | √ |  | null |  |  |
proc_id | bigint | 20 | √ |  | null |  |  |
Table contained 1,190,529 rows at Thu Apr 21 06:56 HST 2011

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
det_id | Primary key | Asc | PRIMARY
epoch_mjd | Performance | Asc | epoch_mjd
field_id | Performance | Asc | field_id
field_id + xyidx | Performance | Asc/Asc | field_id_2
filter_id | Performance | Asc | filter_id
object_name | Performance | Asc | object_name

Close relationships within one two degrees of separation: