Table slot9.WORLD.TSTA.INC_SUPP_NARRATIVES
This table stores the association to the narratives added to an INCIDENT supplement. The narrative itself is stored in EJS_NOTES
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
INC_NARRATIVE_PEOPLE.INCIDENT_ID INCNARPEOP_INC_SUPP_NARR_FK R
INCIDENT_SUPPLEMENTS.INC_INCIDENT_ID INC_SUPP_NARR_SUPP_FK R
Incident ID - PK
SUPP_SEQ number 0
INC_NARRATIVE_PEOPLE.SUPP_ID INCNARPEOP_INC_SUPP_NARR_FK R
INCIDENT_SUPPLEMENTS.SUPP_SEQ INC_SUPP_NARR_SUPP_FK R
Supplement Number - PK
NARRATIVE_NUMBER number 0
INC_NARRATIVE_PEOPLE.NARRATIVE_NUMBER INCNARPEOP_INC_SUPP_NARR_FK R
Narrative Number (1..n) for each supplement
NOTE_ID number 0
EJS_NOTES.NOTE_ID INC_SUPP_NAR_NOTES_FK C
FK to EJS_NOTES.NOTE_ID
CREATOR_ID varchar2 100  √  null USER ID Creating Record
CREATOR_DATE date 7  √  null Date of Record Creation
UPDATOR_ID varchar2 100  √  null User ID of Last Update
UPDATOR_DATE date 7  √  null Date of Last Update
REC_ID number 0  √  null
NARR_TITLE varchar2 4000  √  null
READ_ONLY_FLAG varchar2 1  √  'N'
LOADED_BY varchar2 30  √  null
LAST_LOAD_DATE date 7  √  null
ORIGINAL_NOTE_ID number 0  √  null
EJS_NOTES.NOTE_ID INC_SUPP_NARR_EJSN_FK C
Stores the note id of original narrative text if the narrative has been expunged

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
READ_ONLY_FLAG IN ('Y', 'N') CK_INC_SUPP_NAR_RD_ONLY_FLG

Indexes:
Column(s) Type Sort Constraint Name
INCIDENT_ID + SUPP_SEQ + NARRATIVE_NUMBER Primary key Asc/Asc/Asc INC_SUPP_NARRATIVES_PK
ORIGINAL_NOTE_ID Performance Asc INC_SUPP_NARR_EJSN_FK_I
NOTE_ID Performance Asc INC_SUPP_NARR_NOTE_FK_I
INCIDENT_ID + SUPP_SEQ Performance Asc/Asc INC_SUPP_NARR_SUPP_FK_I

Close relationships  within of separation: