Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table psmops_ps1_mdrm137.history | Generated by SchemaSpy

Implied relationships 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
--- | --- | --- | --- | --- | --- | --- | --- | ---
event_id | bigint | 20 |  | √ |  |
aqueue.event_id | aqueue_ibfk_2
eon_queue.event_id | eon_queue_ibfk_2
history.last_event_id | history_ibfk_5
history_attributions.event_id | history_attributions_ibfk_2
history_derivations.event_id | history_derivations_ibfk_2
history_identifications.event_id | history_identifications_ibfk_2
history_precoveries.event_id | history_precoveries_ibfk_2
history_removals.event_id | history_removals_ibfk_2
moid_queue.event_id | moid_queue_ibfk_2
|  | auto_increment
event_type | char | 1 |  |  |  |  |  |
event_time | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
derivedobject_id | bigint | 20 | √ |  | null |  |
derivedobjects.derivedobject_id | history_ibfk_1
orbit_id | bigint | 20 | √ |  | null |  |
orbits.orbit_id | history_ibfk_2
orbit_code | char | 1 | √ |  | null |  |  |
d3 | float | 12 | √ |  | null |  |  |
d4 | float | 12 | √ |  | null |  |  |
field_id | bigint | 20 | √ |  | null |  |
fields.field_id | history_ibfk_3
classification | char | 1 | √ |  | null |  |  |
ssm_id | bigint | 20 | √ |  | null |  |
ssm.ssm_id | history_ibfk_4
is_lsd | char | 1 |  |  |  |  |  |
last_event_id | bigint | 20 | √ |  | null |  |
history.event_id | history_ibfk_5
Table contained 16,630 rows at Thu Apr 21 06:56 HST 2011

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
event_id | Primary key | Asc | PRIMARY
derivedobject_id | Performance | Asc | derivedobject_id
field_id | Performance | Asc | field_id
last_event_id | Performance | Asc | last_event_id
orbit_id | Performance | Asc | orbit_id
ssm_id | Performance | Asc | ssm_id

Close relationships within one two degrees of separation: