Table lawprod.MSCM.VENDOR_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
GROUP_ID varchar2 4
VENDOR.GROUP_ID SYS_C00914239 R
VENDOR_CLASS.GROUP_ID SYS_C00914627 R
VENDOR_GROUP_COMPANY.GROUP_ID SYS_C00914243 R
GROUP_NAME varchar2 30
INTERNAL_STATUS char 1
EXTERNAL_STATUS char 1

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
GROUP_ID Primary key Asc SYS_C00914219
GROUP_ID + GROUP_NAME Must be unique Asc/Asc SYS_C00914220

Close relationships  within of separation: