Table slot9.WORLD.TSTA.WARRANT_CHARGE_NARRATIVES
This table stores charging language narratives for charges on warrants.
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
WARRANT_NARRATIVE_ID number 0 Unique sequence value for warrant charge narrative
WARRANT_CHARGE_ID number 0
WARRANT_CHARGES.WARRANT_CHARGE_ID WARCHGNAR_WCHG_FK C
Foreign Key to WARRANT_CHARGES WARRANT_CHARGE_ID
NOTE_ID number 0
EJS_NOTES.NOTE_ID WARCHGNAR_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 WARCHGNAR_CRTLOC_FK R
COURT_AGENCY_CODE varchar2 30  √  null
COURT_LOCATION_CODES.AGENCY_CODE WARCHGNAR_CRTLOC_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"WARRANT_NARRATIVE_ID" IS NOT NULL WARCHGNAR_NARRATIVE_ID_NN
"NOTE_ID" IS NOT NULL WARCHGNAR_NOTE_ID_NN
"WARRANT_CHARGE_ID" IS NOT NULL WARCHGNAR_WARR_CHRG_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
WARRANT_NARRATIVE_ID Primary key Asc WARCHGNAR_PK
COURT_ID + COURT_AGENCY_CODE Performance Asc/Asc WARCHGNAR_CRTLOC_FK_I
NOTE_ID Performance Asc WARCHGNAR_EJSN_FK_I
WARRANT_CHARGE_ID Performance Asc WARCHGNAR_WCHG_FK_I

Close relationships  within of separation: