Table slot9.WORLD.TSTA.INCIDENT_ADDRESSES
This table stores the association to a MASTER ADDRESS added to an INCIDENT in the application or uploaded from the CAD-RMS Interface
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
INCIDENT_ID number 0
INCIDENTS.INCIDENT_ID INC_ADDR_INC_FK C
Incident ID number assigned
ADDRESS_ID number 0
ADDRESSES.ADDRESS_ID INC_ADDR_ADDR_FK R
Address ID number
INC_ADDR_COMMENT varchar2 255  √  null
BEAT varchar2 30  √  null
SUB_BEAT varchar2 30  √  null
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null Date Record Created
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null Date Record Last Updated
REC_ID number 0  √  null
CITY varchar2 40  √  null
EJS_CODES.CODE INC_ADDR_EJS_CODE_FK R
CITY_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE_TYPE INC_ADDR_EJS_CODE_FK R
LOC_AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE INC_INC_ADDR_FK R
COUNTY_CODE varchar2 30  √  null
EJS_CODES.CODE INC_EJS_CODE_CNTYCD_FK R
COUNTY_CODE_TYPE varchar2 30  √  'COUNTY_CODES'
EJS_CODES.CODE_TYPE INC_EJS_CODE_CNTYCD_FK R
TOWNSHIP_CODE varchar2 30  √  null
EJS_CODES.CODE INC_EJS_CODE_TWNSHPCD_FK R
TOWNSHIP_CODE_TYPE varchar2 30  √  'TOWNSHIP_CODES'
EJS_CODES.CODE_TYPE INC_EJS_CODE_TWNSHPCD_FK R
LOC_CATEGORY_CODE varchar2 30  √  null
EJS_CODES.CODE INC_ADDR_EJS_CODE_LOCCAT_FK R
Location reporting category for this incident, FK to EJS_CODES
LOC_CATEGORY_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE INC_ADDR_EJS_CODE_LOCCAT_FK R
Code type for location reporting category (code_type in EJS_CODES).
CPN_ID number 0  √  null
COMMON_PLACE_NAMES.CPN_ID INC_ADDR_CPN_FK R
ID of common place name associated with this incident location (FK to COMMON_PLACE_NAMES)
LOADED_BY varchar2 30  √  null
LAST_LOAD_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ADDRESS_ID" IS NOT NULL INC_ADDR_ADDRESS_ID_NN
"INCIDENT_ID" IS NOT NULL INC_ADDR_INCIDENT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
INCIDENT_ID + ADDRESS_ID Primary key Asc/Asc INC_ADDR_PK
ADDRESS_ID Performance Asc INC_ADDR_ADDR_FK_I
CPN_ID Performance Asc INC_ADDR_CPN_FK_I
CITY_TYPE_CODE + CITY Performance Asc/Asc INC_ADDR_EJS_CODE_FK_I
LOC_CATEGORY_CODE_TYPE + LOC_CATEGORY_CODE Performance Asc/Asc INC_ADDR_EJS_CODE_LOCCAT_FK_I
INCIDENT_ID Performance Asc INC_ADDR_INC_FK_I
COUNTY_CODE_TYPE + COUNTY_CODE Performance Asc/Asc INC_EJS_CODE_CNTYCD_FK_I
TOWNSHIP_CODE_TYPE + TOWNSHIP_CODE Performance Asc/Asc INC_EJS_CODE_TWNSHPCD_FK_I
LOC_AGENCY_CODE Performance Asc INC_INC_ADDR_FK_I

Close relationships  within of separation: