Table lawprod.MSCM.PICKLIST_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
PICKLIST_LINE_ID number 20
PICKLIST_LINE_DETAIL.PICKLIST_LINE_ID SYS_C00914891 R
PICKLIST_ID number 20
PICKLIST_HEADER.PICKLIST_ID SYS_C00914886 R
LOC_ITEM_ID number 20
LOCATION_ITEM.LOCATION_ITEM_ID SYS_C00914887 R
OPEN_QTY number 15,4
OPEN_QTY_UOM varchar2 4
PULLED_QTY number 15,4  √  null
PULLED_QTY_UOM varchar2 4  √  null
UPLOAD_STATUS char 1  √  null
UPLOAD_MESSAGE varchar2 150  √  null
LINE_NO number 6  √  null
SKIP_SCANNED char 1  √  null
LINE_TYPE char 1  √  null
SHORT_PICK char 1  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
PICKLIST_LINE_ID Primary key Asc SYS_C00914884
PICKLIST_ID Performance Asc PL_LINE_PL_ID_IDX
PICKLIST_ID + LINE_NO Must be unique Asc/Asc SYS_C00914885

Close relationships  within of separation: