Table lawprod.MSCM.PO_TRANSDTL 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_TICKET_ID varchar2 40
DISTRIB_LINE.DELIVERY_TICKET_ID SYS_C001030852 R
DELIVERY_UNIT_NO number 4
DISTRIB_LINE.DELIVERY_UNIT_NO SYS_C001030852 R
DISTRIB_LINE_NO number 5
DISTRIB_LINE.DISTRIB_LINE_NO SYS_C001030852 R
TRANS_SEQ number 6
LOT_SERIAL varchar2 16  √  null
SUBLOT varchar2 6  √  null
BIN varchar2 7  √  null
QUANTITY number 15,4  √  null
SECONDARY_QTY number 15,4  √  null
EXPIRE_DATE date 7  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
DELIVERY_TICKET_ID + DELIVERY_UNIT_NO + DISTRIB_LINE_NO + TRANS_SEQ Must be unique Asc/Asc/Asc/Asc SYS_C001030851

Close relationships  within of separation: