Table lawprod.MSCM.RECEIPT_LINE_DISTRIB 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_C00914561 R
RECEIPT_LINE_NO number 4
RECEIPT_LINE.RECEIPT_LINE_NO SYS_C00914561 R
RECEIPT_LINE_DISTRIB_NO number 4
DELIVERY_LOCATION_ID number 22  √  null
LOCATION.LOCATION_ID SYS_C00914562 R
QTY_DISTRIB number 10  √  null
DELIVERY_TICKET_ID varchar2 40  √  null
DISTRIB_LINE.DELIVERY_TICKET_ID SYS_C00914563 R
DELIVERY_UNIT_NO number 4  √  null
DISTRIB_LINE.DELIVERY_UNIT_NO SYS_C00914563 R
DISTRIB_LINE_NO number 5  √  null
DISTRIB_LINE.DISTRIB_LINE_NO SYS_C00914563 R
DELIVERY_COMPANY_NO number 4  √  null
COMPANY.COMPANY_NO SYS_C00914564 R

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
RECEIPT_ID + RECEIPT_LINE_NO + RECEIPT_LINE_DISTRIB_NO Primary key Asc/Asc/Asc SYS_C00914560
DELIVERY_TICKET_ID + DELIVERY_UNIT_NO + DISTRIB_LINE_NO Performance Asc/Asc/Asc RLD_DTDUDL_IDX

Close relationships  within of separation: