Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table psmops_ps1_mdrm137.derivedobjects | Generated by SchemaSpy

Related columns Constraint names Comments Legend |
Legend: |
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 one two degrees of separation: