Table slot9.WORLD.TSTA.ARREST_NARRATIVES
The text of the ARREST narrative itself is stored in EJS_NOTES. This table stores the association between the ARREST and the note_id from 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
ARREST_NARRATIVE_ID number 0
ARREST_CHARGE_NARRATIVES.ARREST_NARRATIVE_ID Implied Constraint R
ARREST_ID number 0
ARRESTS.ARREST_ID ARRN_ARR_FK R
TITLE varchar2 200  √  null
NOTE_ID number 0
EJS_NOTES.NOTE_ID ARRN_EJSN_FK R
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
ORIGINAL_NOTE_ID number 0  √  null
EJS_NOTES.NOTE_ID ARRN_EJSN_ORIG_FK R
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
"ARREST_ID" IS NOT NULL ARRN_ARREST_ID_NN
"ARREST_NARRATIVE_ID" IS NOT NULL ARRN_ARRNARR_ID_NN
"NOTE_ID" IS NOT NULL ARRN_NOTE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ARREST_NARRATIVE_ID Primary key Asc ARRN_PK
ARREST_ID Performance Asc ARRN_ARR_FK_I
NOTE_ID Performance Asc ARRN_EJSN_FK_I
ORIGINAL_NOTE_ID Performance Asc ARRN_EJSN_ORIG_FK_I

Close relationships  within of separation: