Table slot9.WORLD.TSTA.ADDRESS_TYPE_CODES
This table defines the valid types of addresses
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_TYPE_CODE varchar2 3
BUSINESS_ADDRESSES.ADDRESS_TYPE_CODE BUS_ADDR_ADDR_CD_FK R
BUSINESS_RMS_SEARCH_VW.ADDRESS_TYPE_CODE Implied Constraint R
EMPLOYEE_ADDRESSES.ADDRESS_TYPE_CODE EMP_ADDR_ADDR_CD_FK R
PERSON_ADDRESSES.ADDRESS_TYPE_CODE PER_ADDR_ADDR_CD_FK R
Type of address
ADDRESS_TYPE_DESC varchar2 40  √  null Description of address type
RANK number 2  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ADDRESS_TYPE_CODE" IS NOT NULL ADDR_CD_ADDRESS_TYPE_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
ADDRESS_TYPE_CODE Primary key Asc ADDR_CD_PK

Close relationships  within of separation: