Table slot9.WORLD.TSTA.ARREST_CHARGE_NARRATIVES
This table stores charging language narratives for charges on field arrests.
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_NARRATIVES.ARREST_NARRATIVE_ID Implied Constraint R
Unique sequence value for field arrest charge narratives.
ARREST_CHARGE_ID number 0
ARREST_CHARGES.AC_ID ARRCHGNR_AC_FK C
Foreign Key to ARREST_CHARGES AC_ID
NOTE_ID number 0
EJS_NOTES.NOTE_ID ARRCHGNR_EJSN_FK C
Foreign Key to EJS_NOTES NOTE_ID
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
AFFIANT varchar2 200  √  null
COURT_ID number 38  √  null
COURT_LOCATION_CODES.COURT_ID ARRCHGNR_CRTLOC_FK R
COURT_AGENCY_CODE varchar2 30  √  null
COURT_LOCATION_CODES.AGENCY_CODE ARRCHGNR_CRTLOC_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ARREST_CHARGE_ID" IS NOT NULL ARRCHGNR_ARR_CHG_ID_NN
"ARREST_NARRATIVE_ID" IS NOT NULL ARRCHGNR_ARR_NAR_ID_NN
"NOTE_ID" IS NOT NULL ARRCHGNR_NOTE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ARREST_NARRATIVE_ID Primary key Asc ARRCHGNR_PK
ARREST_CHARGE_ID Performance Asc ARRCHGNR_AC_FK_I
COURT_ID + COURT_AGENCY_CODE Performance Asc/Asc ARRCHGNR_CRTLOC_FK_I
NOTE_ID Performance Asc ARRCHGNR_EJSN_FK_I

Close relationships  within of separation: