Table lawprod.MSCM.CHARGE_SUPPLY_LOCATION 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
CHARGE_SUP_LOC_SEQ number 22
CHARGE_ID number 22
CHARGE_HEADER.CHARGE_ID SYS_C00914810 R
SUPPLY_LOCATION_ID number 22
LOCATION.LOCATION_ID SYS_C00914811 R

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
CHARGE_SUP_LOC_SEQ Primary key Asc SYS_C00914809
CHARGE_ID + SUPPLY_LOCATION_ID Must be unique Asc/Asc IDX_CHRG_SUPP_LOC

Close relationships  within of separation: