Table atlas_T08.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 19  √ 
history_attributions.event_id Implied Constraint R
Auto-generated internal event ID
event_type char 1 Type of event (A)ttribution/(P)recovery/(D)erivation/(I)dentification/(R)emoval
event_time timestamp 19 CURRENT_TIMESTAMP Timestamp for event creation
derivedobject_id bigint 19  √  null
eon_queue.derivedobject_id Implied Constraint R
Referring derived object ID
orbit_id bigint 19  √  null
moid_queue.orbit_id Implied Constraint R
Pointer to resulting orbit
orbit_code char 1  √  null Information about computed orbit
d3 float 12  √  null Computed 3-parameter D-criterion
d4 float 12  √  null Computed 4-parameter D-criterion
field_id bigint 19  √  null
fields.field_id Implied Constraint R
Referring field ID generating the event
classification char 1  √  null MOPS efficiency classification for event
ssm_id bigint 19  √  null
ssm.ssm_id Implied Constraint R
Matching SSM ID for clean classifications
is_lsd char 1 Y/N if event involves LSD detection
last_event_id bigint 19  √  null refers to last event that modified this object

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

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: