Table lawprod.MSCM.DELIVERY_EVENT 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
DELIVERY_EVENT_ID number 20
DELIVERY_EVENT_LINE.DELIVERY_EVENT_ID SYS_C00914548 R
CREATED date 7
SIGNATURE_ID number 22  √  null
SIGNATURE.SIGNATURE_ID SYS_C00914541 R
RECIPIENT_ID number 22  √  null
RECIPIENT.RECIPIENT_ID SYS_C00914540 R
LOCATION_ID number 22
LOCATION.LOCATION_ID Implied Constraint R
MANIFEST_ID number 22  √  null
MANIFEST.MANIFEST_ID SYS_C00914542 R
ACTION varchar2 10
USER_NAME varchar2 20
PACKAGE_COUNT number 4  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
DELIVERY_EVENT_ID Primary key Asc SYS_C00914539

Close relationships  within of separation: