Table slot9.WORLD.TSTA.INCIDENT_SECURITY_LEVEL_CODES
This table defines the valid security level codes that can be 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_SEC_LEVEL_CODE number 38
AGENCY_CODES.DEF_LEA_SEC_LEVEL AGNCY_CD_INC_SEC_LVL_FK R
IJIS_USER_PROFILES.INC_SEC_LEVEL_CODE IUP_INC_SEC_LEVEL_FK R
INCIDENT_CASES.SECURITY_LEVEL IC_INC_SEC_LVL_FK R
INCIDENT_SUPPLEMENTS.SECURITY_LEVEL INCSUP_INC_SEC_LVL_FK R
USER_SCREEN_INSTANCES.SECURITY_LEVEL USRSCRN_INST_INC_SEC_LVL_FK R
USER_SCREENS.DEFAULT_SECURITY_LEVEL USRSCRN_INC_SEC_LVL_FK R
INC_SEC_LEVEL_DESC varchar2 255  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"INC_SEC_LEVEL_CODE" IS NOT NULL INC_SEC_LVL_NN

Indexes:
Column(s) Type Sort Constraint Name
INC_SEC_LEVEL_CODE Primary key Asc INC_SEC_LVL_PK

Close relationships  within of separation: