Table lawprod.MSCM.LAWSON_ITEM_GROUP 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_GROUP varchar2 5
ITEM_GROUP.ITEM_GROUP Implied Constraint R
LAWSON_COMPANY.ITEM_GROUP Implied Constraint R
LAWSON_ICAUDIT.ITEM_GROUP Implied Constraint R
LAWSON_ITEM.ITEM_GROUP Implied Constraint R
LAWSON_MFGR.ITEM_GROUP Implied Constraint R
LAWSON_PICKLIST_LINE.ITEM_GROUP Implied Constraint R
LOCAL_ITEM_VW.ITEM_GROUP Implied Constraint R
DESCRIPTION varchar2 30  √  null
CREATION_DT date 7
LAST_MODIFIED_DT date 7  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
ITEM_GROUP Primary key Asc SYS_IOT_TOP_270424

Close relationships: