Table slot9.WORLD.TSTA.EJS_NOTES
This table stores large narratives created throughout the application such as an Incident Narrative. The Note Id is related to the area of the application being used

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
NOTE_ID number 0
ARREST_CHARGE_NARRATIVES.NOTE_ID ARRCHGNR_EJSN_FK C
ARREST_NARRATIVES.NOTE_ID ARRN_EJSN_FK R
ARREST_NARRATIVES.ORIGINAL_NOTE_ID ARRN_EJSN_ORIG_FK R
ARRESTS.NOTE_ID ARR_EJSN_FK R
CASE_ACTIVITY_NARRATIVES.NOTE_ID CASEACTNARR_EJSN_FK C
CASE_LOG.NOTE_ID CASELG_EJSN_FK R
CHARGE_LANGUAGE_TEMPLATES.NOTE_ID CHRGLANG_EJSCD_NOTEID_FK C
EJS_DB_CONFIG_NOTES.NOTE_ID Implied Constraint R
EJS_MODULE_TEXT.NOTE_ID EJS_MOD_TXT_NOTE_FK R
EJS_NOTES_ANNOTATED.ANNOTATED_NOTE_ID ENA_EJSN_ANNO_FK R
EJS_NOTES_ANNOTATED.SOURCE_NOTE_ID ENA_EJSN_SRC_FK C
EJS_NOTES_FLASHBACK.NOTE_ID Implied Constraint R
EJS_NOTES_VW.NOTE_ID Implied Constraint R
EJS_XML_DOC_NARRATIVES.NOTE_ID EXDN_EJSN_FK C
FIELD_INT_SEARCH_GANG_VW.NOTE_ID Implied Constraint R
FIELD_INT_SEARCH_LOCATION_VW.NOTE_ID Implied Constraint R
FIELD_INT_SEARCH_MIN_VW.NOTE_ID Implied Constraint R
FIELD_INT_SEARCH_OFFICER_VW.NOTE_ID Implied Constraint R
FIELD_INT_SEARCH_ORG_VW.NOTE_ID Implied Constraint R
FIELD_INT_SEARCH_PERSON_VW.NOTE_ID Implied Constraint R
FIELD_INT_SEARCH_VEHICLE_VW.NOTE_ID Implied Constraint R
FIELD_INTERVIEWS.NOTE_ID FLDINT_EJSN_FK R
INC_CASE_ACTIVITIES.NOTE_ID INCCASACT_EJSN_FK R
INC_SUPP_NARR_APPR_UPDATES.NOTE_ID Implied Constraint R
INC_SUPP_NARRATIVES.NOTE_ID INC_SUPP_NAR_NOTES_FK C
INC_SUPP_NARRATIVES.ORIGINAL_NOTE_ID INC_SUPP_NARR_EJSN_FK C
INCIDENT_SUPP_NARRATIVE_VW.NOTE_ID Implied Constraint R
INCIDENT_SUPPLEMENT_NOTES_VW.NOTE_ID Implied Constraint R
JS_FIELD_CONTACT_VW.NOTE_ID Implied Constraint R
NARRATIVE_TEMPLATES.NOTE_ID NARTEM_EJSN_FK R
WARRANT_CHARGE_NARRATIVES.NOTE_ID WARCHGNAR_EJSN_FK C
WEAPONS_TRAININGS.NOTE_ID WT_EJSN_FK R
NARRATIVE clob 4000  √  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
"NOTE_ID" IS NOT NULL EJSN_NOTE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
NOTE_ID Primary key Asc EJSN_PK
NARRATIVE Performance Asc EJSN_NARRATIVE_I

Close relationships  within of separation: