Table lawprod.MSCM.PICKLIST_HEADER 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_ID number 20
PICKLIST_LINE.PICKLIST_ID SYS_C00914886 R
PICKLIST_LOG.PICKLIST_ID SYS_C00914511 R
FROM_LOC_ID number 22
LOCATION.LOCATION_ID SYS_C00914490 R
REQ_LOC_ID number 22
LOCATION.LOCATION_ID SYS_C00914491 R
DOC_NO varchar2 10
SHIP_NO number 10
VENDOR varchar2 9  √  null
REQ_DATE date 7  √  null
REQUESTER varchar2 10  √  null
SHIP_DATE date 7  √  null
LAST_PICK_DATE date 7  √  null
LAST_ASSIGN_DATE date 7  √  null
UPLOAD_MSG varchar2 150  √  null
TOTAL_LINES number 22  √  null
TOTAL_PICKED_LINES number 22  √  null
LINES_SHORT number 22  √  null
INT_STATUS char 2  √  null
EXT_STATUS char 1  √  null
DOCUMENT_PRINTER_ID number 8  √  null
LABEL_PRINTER_ID number 8  √  null
DELIVER_TO varchar2 30  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
PICKLIST_ID Primary key Asc SYS_C00914488
FROM_LOC_ID + SHIP_NO Must be unique Asc/Asc SYS_C00914489

Close relationships  within of separation: