Table shrdb.LAWSN.ENPDELIVERYLOG 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
TIMESTMP date 7 now
USERID number 22
ENPUSERMAP.USERID FK_DELIVERYLOG C
TRACKING varchar2 25
EVENT_ID number 22
DEVICE_ID number 22  √  null
DOCUMENT_ID number 22  √  null
DOCUMENT_TYPE number 22  √  null
MESSAGE varchar2 200  √  null
DETAILS varchar2 4000  √  null

Table contained 28,298 rows at Thu Dec 13 15:47 CST 2012

Indexes:
Column(s) Type Sort Constraint Name
USERID + TRACKING + EVENT_ID + TIMESTMP Primary key Asc/Asc/Asc/Asc PK_DELIVERYLOG

Close relationships  within of separation: