Table lawprod.MSCM.RECEIPT_LINE 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_DISTRIB.RECEIPT_ID SYS_C00914561 R
RECEIPT_HEADER.RECEIPT_ID SYS_C00913786 R
RECEIPT_LINE_NO number 4
RECEIPT_LINE_DISTRIB.RECEIPT_LINE_NO SYS_C00914561 R
QTY_RECEIVED number 6
RECEIVED_TIME date 7
PO_NO varchar2 20  √  null
PACKING_SLIP_NO varchar2 40  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
RECEIPT_ID + RECEIPT_LINE_NO Primary key Asc/Asc SYS_C00913785
RECEIVED_TIME Performance Asc RH_RTIME_IDX

Close relationships  within of separation: