Table lawprod.MSCM.PICKLIST 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 22
PICKLIST_NO varchar2 6
PICK.PICKLIST_NO Implied Constraint R
PICK_ACTIVITY.PICKLIST_NO Implied Constraint R
PICKING_DETAILS.PICKLIST_NO Implied Constraint R
PICKLIST_CARTSET_MAP_VW.PICKLIST_NO Implied Constraint R
STER_LOAD_HISTORY_VW.PICKLIST_NO Implied Constraint R
USER_ID number 22
USERS.USER_ID SYS_C00914117 R
CREAT_DT date 7

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
PICKLIST_NO Primary key Asc SYS_C00914116

Close relationships  within of separation: