Table atlas_T08.tracklets Generated by
SchemaSpy
Legend: SourceForge.net
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 19  √ 
derivedobject_attrib.tracklet_id Implied Constraint R
history_attributions.tracklet_id Implied Constraint R
history_derivations.tracklet_id Implied Constraint R
history_precoveries.tracklet_id Implied Constraint R
residuals.tracklet_id Implied Constraint R
tracklet_attrib.tracklet_id Implied Constraint R
Auto-generated internal MOPS tracklet ID
field_id bigint 19
fields.field_id Implied Constraint R
Terminating field ID
v_ra float 12  √  null Average RA velocity deg/day, cos(dec) applied
v_dec float 12  √  null Average Dec velocity, deg/day)
v_tot float 12  √  null Average total velocity, deg/day
v_ra_sigma float 12  √  null Uncertainty in RA velocity
v_dec_sigma float 12  √  null Uncertainty in Dec velocity
pos_ang_deg float 12  √  null Position angle, degrees
gcr_arcsec float 12  √  null great-circle residual, arcsec
ext_epoch double 22  √  null Extrapolated (central) epoch, MJD
ext_ra double 22  √  null Extrapolated (central) RA, deg
ext_dec double 22  √  null Extrapolated (central) Dec, deg
ext_mag double 22  √  null Extrapolated (central) magnitude
probability float 12  √  null Likelihood tracklet is real (unused currently)
digest float 12  √  null NEO digest
geo_prob float 12  √  null
status char 1  √  null processing status (unfound X, unattributed U, attributed A)
classification char 1  √  null MOPS efficiency classification
ssm_id bigint 19  √  null
ssm.ssm_id Implied Constraint R
Matching SSM ID for clean classifications
known_id bigint 19  √  null
known.known_id Implied Constraint R
Optional externally-assigned known object ID
pchin float 12  √  null

Table contained 7,883,374 rows at Fri Jul 12 15:38 HST 2024

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: