Table atlas_T08.ssm 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
ssm_id bigint 19  √ 
derivedobjects.ssm_id Implied Constraint R
history.ssm_id Implied Constraint R
shapes.ssm_id Implied Constraint R
tracklets.ssm_id Implied Constraint R
q double 22 semi-major axis, AU
e double 22 eccentricity e (dimensionless)
i double 22 inclination, deg
node double 22 longitude of ascending node, deg
arg_peri double 22 argument of perihelion, deg
time_peri double 22 time of perihelion, MJD
epoch double 22 epoch of osculating elements, MJD
h_v double 22 Absolute magnitude
h_ss double 22  √  null ??
g double 22  √  null Slope parameter g, dimensionless
albedo double 22  √  null Albedo, dimensionless
moid_1 double 22  √  null Vestigial, deprecated
moid_long_1 double 22  √  null Vestigial, deprecated
moid_2 double 22  √  null Vestigial, deprecated
moid_long_2 double 22  √  null Vestigial, deprecated
object_name varbinary 32 MOPS synthetic object name
taxonomic_type char 2  √  null Asteroid taxonomic type (vestigial, deprecated)
desc_id bigint 19  √  null
ssm_desc.desc_id Implied Constraint R
Pointer to SSM description

Table contained 0 rows at Fri Jul 12 15:38 HST 2024

Indexes:
Column(s) Type Sort Constraint Name
ssm_id Primary key Asc PRIMARY
desc_id Performance Asc desc_id
epoch Performance Asc epoch
object_name Must be unique Asc object_name
object_name Performance Asc object_name_2

Close relationships: