Table slot9.WORLD.TSTA.INC_CASE_INCIDENTS
This table stores the association between cases and INCIDENTS
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_CASE_ID number 0
INCIDENT_CASES.INC_CASE_ID ICI_IC_FK C
The unique identifier for an Incident Case
INCIDENT_ID number 0
INCIDENT_SUPPLEMENTS.INC_INCIDENT_ID ICI_INCSUP_FK C
Incident ID number assigned
SUPP_SEQ number 0
INCIDENT_SUPPLEMENTS.SUPP_SEQ ICI_INCSUP_FK C
Supplement Sequence Number 1 = Original Report
ICI_COMMENT varchar2 4000  √  null Explanation of association
CREATOR_ID varchar2 100  √  null ID of creator
CREATOR_DATE date 7  √  null Date record was created
UPDATOR_ID varchar2 100  √  null ID of updator
UPDATOR_DATE date 7  √  null Date record was updated
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"INC_CASE_ID" IS NOT NULL ICI_INC_CASE_ID_NN
"INCIDENT_ID" IS NOT NULL ICI_INCIDENT_ID_NN
"SUPP_SEQ" IS NOT NULL ICI_SUPP_SEQ_NN

Indexes:
Column(s) Type Sort Constraint Name
INC_CASE_ID + INCIDENT_ID + SUPP_SEQ Primary key Asc/Asc/Asc ICI_PK
INC_CASE_ID Performance Asc ICI_IC_FK_I
INCIDENT_ID + SUPP_SEQ Performance Asc/Asc ICI_INCSUP_FK_I

Close relationships  within of separation: