Table psmops_ps1_mdrm137.derivedobjects 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
derivedobject_id bigint 20  √ 
aqueue.derivedobject_id aqueue_ibfk_1
derivedobject_attrib.derivedobject_id derivedobject_attrib_ibfk_1
eon_queue.derivedobject_id eon_queue_ibfk_1
history.derivedobject_id history_ibfk_1
history_identifications.childobject_id history_identifications_ibfk_1
auto_increment
orbit_id bigint 20  √  null
orbits.orbit_id derivedobjects_ibfk_1
object_name varbinary 32  √  null
taxonomic_type char 2  √  null
rotation_period double 22  √  null
amplitude double 22  √  null
rotation_epoch double 22  √  null
g double 22  √  null
albedo double 22  √  null
pole_lat double 22  √  null
pole_long double 22  √  null
classification char 1  √  null
ssm_id bigint 20  √  null
ssm.ssm_id derivedobjects_ibfk_2
status char 1  √  null
stable_pass char 1  √  null
mops_classification char 3  √  null
created timestamp 19 CURRENT_TIMESTAMP
updated timestamp 19 0000-00-00 00:00:00

Table contained 7,489 rows at Thu Apr 21 06:56 HST 2011

Indexes:
Column(s) Type Sort Constraint Name
derivedobject_id Primary key Asc PRIMARY
mops_classification Performance Asc mops_classification
object_name Performance Asc object_name
orbit_id Performance Asc orbit_id
ssm_id Performance Asc ssm_id
status Performance Asc status
updated Performance Asc updated

Close relationships  within of separation: