Table slot9.WORLD.TSTA.INC_SUPP_NARR_APPR_UPDATES
This table is used to track updated narratives on approved 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
ID number 32
INCIDENT_ID number 0
INCIDENTS.INCIDENT_ID Implied Constraint R
SUPP_SEQ number 0
NOTE_ID number 0
EJS_NOTES.NOTE_ID Implied Constraint R
OLD_NARRATIVE clob 4000  √  null
NEW_NARRATIVE clob 4000  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ID" IS NOT NULL ISNAU_ID_NN
"INCIDENT_ID" IS NOT NULL ISNAU_INC_ID_NN
"NOTE_ID" IS NOT NULL ISNAU_NOT_ID_NN
"SUPP_SEQ" IS NOT NULL ISNAU_SUPP_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc ISNAU_PK

Close relationships: