Table lawprod.MSCM.ADDRESS 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
ADDRESS_ID number 22
LOCATION.ADDRESS_ID SYS_C00913476 R
ADDRESS_LINE1 varchar2 30  √  null
ADDRESS_LINE2 varchar2 30  √  null
ADDRESS_LINE3 varchar2 30  √  null
ADDRESS_LINE4 varchar2 30  √  null
CITY_ADDR5 varchar2 18  √  null
STATE_PROV varchar2 2  √  null
POSTAL_CODE varchar2 10  √  null
COUNTRY_CODE varchar2 2  √  null
COUNTRY varchar2 30  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
ADDRESS_ID Primary key Asc SYS_C00913461

Close relationships  within of separation: