Table pub.mgd.mrk_history A record in this table represents a nomenclature event in the life of a Marker. A nomenclature event is defined by the event itself (rename, merge, split, etc.), the reason for the event, date of the event, reference (J:).
|
Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Table contained 432,051 rows at Thu Dec 21 05:31 EST 2017 |
Indexes:
Column(s) | Type | Sort | Constraint Name |
---|---|---|---|
_marker_key + sequencenum | Primary key, Used to cluster data | Asc/Asc | mrk_history_pkey |
_history_key | Performance | Asc | mrk_history_idx_history_key |
_marker_event_key | Performance | Asc | mrk_history_idx_marker_event_key |
_marker_eventreason_key | Performance | Asc | mrk_history_idx_marker_eventreason_key |
_refs_key | Performance | Asc | mrk_history_idx_refs_key |
![]() ![]() ![]() |