Table psmops_ps1_mdrm137.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 20  √ 
derivedobjects.ssm_id derivedobjects_ibfk_2
history.ssm_id history_ibfk_4
shapes.ssm_id shapes_ibfk_1
tracklets.ssm_id tracklets_ibfk_2
auto_increment
q double 22
e double 22
i double 22
node double 22
arg_peri double 22
time_peri double 22
epoch double 22
h_v double 22
h_ss double 22  √  null
g double 22  √  null
albedo double 22  √  null
moid_1 double 22  √  null
moid_long_1 double 22  √  null
moid_2 double 22  √  null
moid_long_2 double 22  √  null
object_name varbinary 32
taxonomic_type char 2  √  null
desc_id bigint 20  √  null
ssm_desc.desc_id ssm_ibfk_1

Table contained 1,460,977 rows at Thu Apr 21 06:56 HST 2011

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  within of separation: