Table atlas_T08.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 19  √ 
eon_queue.derivedobject_id Implied Constraint R
Auto-assigned internal MOPS numeric ID
orbit_id bigint 19  √  null
moid_queue.orbit_id Implied Constraint R
Pointer to current orbit
object_name varbinary 32  √  null MOPS base-64 object name
taxonomic_type char 2  √  null Asteroid taxonomic type
rotation_period double 22  √  null Rotation period, days
amplitude double 22  √  null Amplitude, magnitudes (dimensionless)
rotation_epoch double 22  √  null Rotation time origin, MJD
g double 22  √  null Slope parameter g
albedo double 22  √  null Albedo, dimensionless
pole_lat double 22  √  null Rotation pole latitude, deg
pole_long double 22  √  null Rotation pole longitude, deg
classification char 1  √  null MOPS efficiency classification (C/M/B/N/X)
ssm_id bigint 19  √  null
ssm.ssm_id Implied Constraint R
Source SSM obje t for C classification
status char 1  √  null NULL, or set to M when DO is merged with parent
stable_pass char 1  √  null NULL, or set to Y when stable precovery pass completed
mops_classification char 3  √  null 3-char MOPS asteroid classification
created timestamp 19 CURRENT_TIMESTAMP Timestamp for derived object creation
updated timestamp 19 0000-00-00 00:00:00 Timestamp for derived object modification

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

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: