Table lawprod.MSCM.ITEM 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
ITEM_ID number 22
CHARGE_DETAIL.ITEM_ID SYS_C00914787 R
COUNTFORM_ITEMS.ITEM_ID SYS_C00913717 R
EVENT_DETAIL.ITEM_ID Implied Constraint R
ITEM_ON_TRAY_LIST_HELP.ITEM_ID Implied Constraint R
ITEMS_IN_TRAY_LISTS.ITEM_ID Implied Constraint R
LOCAL_ITEM_VW.ITEM_ID Implied Constraint R
LOCATION_ITEM.ITEM_ID SYS_C00913499 R
LOCATION_ITEM.ITEM_REPL_NO SYS_C00913501 R
POU_UOM.ITEM_ID SYS_C00914815 R
REQUEST_QUEUE.ITEM_ID SYS_C00914805 R
REVENUE_CENTER_ITEM.ITEM_ID SYS_C00914687 R
TASK.ITEM_ID SYS_C00913562 R
TL_ITEM.ITEM_ID SYS_C00913935 R
TRANS_ITEM_UOM.ITEM_ID SYS_C00914822 R
ITEM_NO varchar2 32
ITEM_GROUP varchar2 5  √  null
ITEM_GROUP.ITEM_GROUP SYS_C00913430 R
EXT_DATA_IND char 1  √  null
PROCUREMENT_ITEM_ID number 22  √  null
DESCR varchar2 100  √  null
MFR_CAT_NO varchar2 35  √  null
MFR_ID number 22  √  null
MFGR.MFR_ID SYS_C00913431 R
MAJOR_CLASS varchar2 4  √  null
MINOR_CLASS varchar2 4  √  null
USAGE_IDENTIFIER varchar2 1  √  null
IMGLNK varchar2 255  √  null
UOM varchar2 4  √  null
STATUS char 1
EXTERNAL_STATUS char 1  √  null
CREATION_DT date 7
LAST_MODIFIED_DT date 7
SERIAL_TRACKED_IND char 1  √  ('N')
SER_TRACK_FL char 1  √  ('N')
LOT_TRACK_FL char 1  √  ('N')
USAGE_LIMIT number 22 0

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
ITEM_ID Primary key Asc SYS_C00913429
PROCUREMENT_ITEM_ID Performance Asc IDX_PROC_ITEM_NO
ITEM_GROUP + ITEM_NO + EXT_DATA_IND Must be unique Asc/Asc/Asc ITEM_EXT_NO_UK

Close relationships  within of separation: