Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table psmops_ps1_mdrm137.ssm | 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
--- | --- | --- | --- | --- | --- | --- | --- | ---
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 one two degrees of separation: