Table lawprod.MSCM.EVENT_HEADER Generated by
SchemaSpy
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_HEADER_ID number 20
EVENT_DETAIL.EVENT_HEADER_ID SYS_C00913583 R
EVENT_TYPE varchar2 10
USER_ID number 22
USERS.USER_ID Implied Constraint R
HEADER_UPLOAD_IND varchar2 8
EVENT_STATUS_RANK.STATUS_CODE SYS_C00913576 R
HH_SYNC_TIMESTAMP date 7
EVENT_HEADER_GT_01 varchar2 100  √  null
EVENT_HEADER_GT_02 varchar2 100  √  null
EVENT_HEADER_GT_03 varchar2 100  √  null
EVENT_HEADER_GT_04 varchar2 100  √  null
EVENT_HEADER_GT_05 varchar2 100  √  null
EVENT_HEADER_GT_06 varchar2 100  √  null
EVENT_HEADER_GN_01 number 32  √  null
EVENT_HEADER_GN_02 number 32  √  null
EVENT_HEADER_GN_03 number 32  √  null
EVENT_HEADER_GN_04 number 32  √  null
EVENT_HEADER_GD_01 date 7  √  null
EVENT_HEADER_GD_02 date 7  √  null
RETRY_COUNT number 4  √  null
NEED_TO_PRINT number 1  √  -1
CREATION_DT date 7
LAST_MODIFIED_DT date 7
DOCUMENT_PRINTER_ID number 8  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
EVENT_HEADER_ID Primary key Asc SYS_C00913575
HH_SYNC_TIMESTAMP Performance Asc EVT_HDR_DT_IDX
EVENT_HEADER_GN_03 Performance Asc EVT_HDR_GN03_IDX
EVENT_HEADER_GT_01 Performance Asc EVT_HDR_LOCID_IDX
EVENT_TYPE + HEADER_UPLOAD_IND Performance Asc/Asc EVT_HDR_TYPE_IDX
EVENT_TYPE + EVENT_HEADER_ID + RETRY_COUNT Performance Asc/Asc/Asc EVTHDR_TP_CNT_IDX

Close relationships: