Table slot9.WORLD.TSTA.COMMON_PLACE_NAMES
This table stores a configurable standard list of common place names (e.g. McDonalds, Fed Ex, DIA)
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
CPN_ID number 0
ADDRESS_COMMON_NAMES.CPN_ID ADDRCN_CPN_FK R
CPN_LOC_CATEGORIES.CPN_ID CPNCAT_CPN_FK C
INCIDENT_ADDRESSES.CPN_ID INC_ADDR_CPN_FK R
Unique ID number for common name, used as primary key.
COMMON_PLACE_NAME varchar2 80 Standard Common Name used to identify an address location.
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE CPN_AGNCY_CD_FK R
Agency responsible for this CPN or agency that can use this CPN. If null, available to all agencies.
ACTIVE varchar2 1  √  'Y' Y/N Flag indicating common name can be used currently.
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"COMMON_PLACE_NAME" IS NOT NULL CPN_COMMON_PLACE_NAME_NN
"CPN_ID" IS NOT NULL CPN_CPN_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
CPN_ID Primary key Asc CPN_PK
AGENCY_CODE Performance Asc CPN_AGNCY_CD_FK_I
COMMON_PLACE_NAME + AGENCY_CODE Must be unique Asc/Asc CPN_UK

Close relationships  within of separation: