Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table psmops_ps1_mdrm137.tracklets | Generated by SchemaSpy

Implied relationships 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
--- | --- | --- | --- | --- | --- | --- | --- | ---
tracklet_id | bigint | 20 |  | √ |  |
alerted_tracklets.tracklet_id | alerted_tracklets_ibfk_1
derivedobject_attrib.tracklet_id | derivedobject_attrib_ibfk_2
history_attributions.tracklet_id | history_attributions_ibfk_1
history_derivations.tracklet_id | history_derivations_ibfk_1
history_precoveries.tracklet_id | history_precoveries_ibfk_1
history_removals.tracklet_id | history_removals_ibfk_1
residuals.tracklet_id | residuals_ibfk_2
tracklet_attrib.tracklet_id | tracklet_attrib_ibfk_1
|  | auto_increment
field_id | bigint | 20 |  |  |  |  |
fields.field_id | tracklets_ibfk_1
v_ra | double | 22 | √ |  | null |  |  |
v_dec | double | 22 | √ |  | null |  |  |
v_tot | double | 22 | √ |  | null |  |  |
v_ra_sigma | double | 22 | √ |  | null |  |  |
v_dec_sigma | double | 22 | √ |  | null |  |  |
pos_ang_deg | double | 22 | √ |  | null |  |  |
gcr_arcsec | float | 12 | √ |  | null |  |  |
ext_epoch | double | 22 | √ |  | null |  |  |
ext_ra | double | 22 | √ |  | null |  |  |
ext_dec | double | 22 | √ |  | null |  |  |
ext_mag | double | 22 | √ |  | null |  |  |
probability | double | 22 | √ |  | null |  |  |
status | char | 1 | √ |  | null |  |  |
classification | char | 1 | √ |  | null |  |  |
ssm_id | bigint | 20 | √ |  | null |  |
ssm.ssm_id | tracklets_ibfk_2
known_id | bigint | 20 | √ |  | null |  |
known.known_id | tracklets_ibfk_3
Table contained 329,474 rows at Thu Apr 21 06:56 HST 2011

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
tracklet_id | Primary key | Asc | PRIMARY
classification | Performance | Asc | classification
ext_epoch | Performance | Asc | ext_epoch
field_id | Performance | Asc | field_id
known_id | Performance | Asc | known_id
ssm_id | Performance | Asc | ssm_id

Close relationships within one two degrees of separation: