Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table psmops_ps1_mdrm137.fields | 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
--- | --- | --- | --- | --- | --- | --- | --- | ---
field_id | bigint | 20 |  | √ |  |
detections.field_id | detections_ibfk_2
history.field_id | history_ibfk_3
tracklets.field_id | tracklets_ibfk_1
|  | auto_increment
epoch_mjd | double | 22 |  |  |  |  |  |
uncorrected_epoch_mjd | double | 22 |  |  |  |  |  |
ra_deg | double | 22 |  |  |  |  |  |
dec_deg | double | 22 |  |  |  |  |  |
survey_mode | varchar | 120 | √ |  | null |  |  |
time_start | double | 22 | √ |  | null |  |  |
time_stop | double | 22 | √ |  | null |  |  |
filter_id | char | 2 | √ |  | null |  |
filter_info.filter_id | fields_ibfk_1
limiting_mag | double | 22 | √ |  | null |  |  |
ra_sigma | double | 22 | √ |  | null |  |  |
dec_sigma | double | 22 | √ |  | null |  |  |
obscode | char | 3 | √ |  | null |  |  |
de1 | double | 22 | √ |  | null |  |  |
de2 | double | 22 | √ |  | null |  |  |
de3 | double | 22 | √ |  | null |  |  |
de4 | double | 22 | √ |  | null |  |  |
de5 | double | 22 | √ |  | null |  |  |
de6 | double | 22 | √ |  | null |  |  |
de7 | double | 22 | √ |  | null |  |  |
de8 | double | 22 | √ |  | null |  |  |
de9 | double | 22 | √ |  | null |  |  |
de10 | double | 22 | √ |  | null |  |  |
ocnum | int | 11 | √ |  | null |  |  |
nn | int | 11 | √ |  | null |  |  |
fpa_id | varchar | 20 | √ |  | null |  |  |
exp_id | varchar | 20 | √ |  | null |  |  |
diff_id | varchar | 20 | √ |  | null |  |  |
pa_deg | double | 22 | √ |  | null |  |  |
fov_deg | double | 22 | √ |  | null |  |  |
xyidx_size | int | 11 | √ |  | null |  |  |
se_deg | double | 22 | √ |  | null |  |  |
eb_deg | double | 22 | √ |  | null |  |  |
gb_deg | double | 22 | √ |  | null |  |  |
status | char | 1 | √ |  | N |  |  |
parent_id | bigint | 20 | √ |  | null |  |  |
Table contained 490 rows at Thu Apr 21 06:56 HST 2011

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
field_id | Primary key | Asc | PRIMARY
epoch_mjd | Performance | Asc | epoch_mjd
filter_id | Performance | Asc | filter_id

Close relationships within one two degrees of separation: