Table lawprod.MSCM.PICKLIST_LINE_DETAIL 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
PICKLIST_LINE_ID number 20
PICKLIST_LINE.PICKLIST_LINE_ID SYS_C00914891 R
RECORD_SEQ number 22
PULLED_QTY number 15,4  √  null
PULLED_UOM varchar2 4  √  null
TRACKING_NO varchar2 40  √  null
PICKED_BY number 22  √  null
USERS.USER_ID SYS_C00914892 R
BIN varchar2 7  √  null
SERIAL varchar2 16  √  null
LOT varchar2 10  √  null
SUB_LOT varchar2 6  √  null
ALLOCATED_QTY number 15,4  √  null
ALLOCATED_UOM varchar2 4  √  null
ALLOCATED_BIN varchar2 7  √  null
ALLOCATED_SERIAL varchar2 16  √  null
ALLOCATED_LOT varchar2 10  √  null
ALLOCATED_SUB_LOT varchar2 6  √  null
UPLOAD_STATUS char 1  √  null
UPLOAD_MESSAGE varchar2 150  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
PICKLIST_LINE_ID + RECORD_SEQ Primary key Asc/Asc SYS_C00914890
PICKLIST_LINE_ID + ALLOCATED_UOM + ALLOCATED_BIN + ALLOCATED_SERIAL + ALLOCATED_LOT + ALLOCATED_SUB_LOT Performance Asc/Asc/Asc/Asc/Asc/Asc PL_LINE_DETAIL_IDX

Close relationships  within of separation: