Table psmops_ps1_mdrm137.history 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
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 of separation: