Table lawprod.MSCM.VENDOR_CLASS 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
GROUP_ID varchar2 4
VENDOR_GROUP.GROUP_ID SYS_C00914627 R
VENDOR_CLASS_ID varchar2 3
VENDOR_CLASS_NAME varchar2 30
IS_MSCM_SYNC char 1
STATUS char 1

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
GROUP_ID + VENDOR_CLASS_ID Primary key Asc/Asc SYS_C00914626

Close relationships  within of separation: