Table lawprod.MSCM.VENDOR_CARRIER_MAP 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
CARRIER_TRACKING_FORMAT_ID number 22
CARRIER_TRACKING_FORMAT.CARRIER_TRACKING_FORMAT_ID SYS_C00913754 R
MIN_MAP_VALUE varchar2 20
MAX_MAP_VALUE varchar2 20
VENDOR_SYSTEM_ID number 22
VENDOR.VENDOR_SYSTEM_ID SYS_C00914252 R

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
CARRIER_TRACKING_FORMAT_ID + VENDOR_SYSTEM_ID + MIN_MAP_VALUE + MAX_MAP_VALUE Primary key Asc/Asc/Asc/Asc SYS_C00914253

Close relationships  within of separation: