Table psmops_ps1_mdrm137.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 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 of separation: