Table lawprod.MSCM.RECEIPT_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
RECEIPT_ID number 20
RECEIPT_LINE.RECEIPT_ID SYS_C00913786 R
RECEIPT_LOG_VW.RECEIPT_ID Implied Constraint R
TRACKING_NO varchar2 40  √  null
COMMENTS varchar2 200  √  null
ACCEPT_RECEIPT char 1
RECEIPT_TYPE number 2
STATUS number 2  √  null
RECV_LOCATION_ID number 22
LOCATION.LOCATION_ID SYS_C00913776 R
USER_ID number 22
USERS.USER_ID SYS_C00913779 R
RETURN_TIME date 7
LAST_MODIFIED_DT date 7
NOTE_ID number 20  √  null
NOTE.NOTE_ID SYS_C00913780 R
CARRIER_VENDOR_SYSTEM_ID number 22  √  null
VENDOR.VENDOR_SYSTEM_ID SYS_C00914249 R
VENDOR_SYSTEM_ID number 22  √  null
VENDOR.VENDOR_SYSTEM_ID SYS_C00914250 R
DOCUMENT_PRINTER_ID number 8  √  null
LABEL_PRINTER_ID number 8  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
RECEIPT_ID Primary key Asc SYS_C00913775
RECV_LOCATION_ID Performance Asc RH_RLOCID_IDX
TRACKING_NO Performance Asc RH_TRKNO_IDX

Close relationships  within of separation: