Table slot9.WORLD.TSTA.OFFICER_INCIDENTS
This table stores the association of officers and role the officer plays when added to an INCIDENT in the application
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
INC_INCIDENT_ID number 0
INCIDENT_SUPPLEMENTS.INC_INCIDENT_ID OFFINC_INCSUP_FK C
Incident ID number assigned
OFF1_OFFICER_ID number 0
OFFICERS.OFFICER_ID OFFINC_OFF1_FK R
Officer ID number
ORC_ROLE_CODE varchar2 1
OFFICER_ROLE_CODES.ROLE_CODE OFFINC_ORC_FK R
Officer Incident Role Code
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
SUPP_SEQ number 5
INCIDENT_SUPPLEMENTS.SUPP_SEQ OFFINC_INCSUP_FK C
REC_ID number 0  √  null
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
"INC_INCIDENT_ID" IS NOT NULL OFFINC_INC_INCIDENT_ID_NN
"OFF1_OFFICER_ID" IS NOT NULL OFFINC_OFF1_OFFICER_ID_NN
"ORC_ROLE_CODE" IS NOT NULL OFFINC_ORC_ROLE_CODE_NN
"SUPP_SEQ" IS NOT NULL OFFINC_SUPP_SEQ_NN

Indexes:
Column(s) Type Sort Constraint Name
INC_INCIDENT_ID + OFF1_OFFICER_ID + ORC_ROLE_CODE + SUPP_SEQ Primary key Asc/Asc/Asc/Asc OFFINC_PK
INC_INCIDENT_ID + SUPP_SEQ Performance Asc/Asc OFFINC_INCSUP_FK_I
OFF1_OFFICER_ID Performance Asc OFFINC_OFF1_FK_I
ORC_ROLE_CODE Performance Asc OFFINC_ORC_FK_I

Close relationships  within of separation: