Table slot9.WORLD.TSTA.CHARGE_CODE_TOKENS
This table stores associations between charge codes and tokens. Tokens (ejs codes) are additional fields added to charges on criminal complaints.
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
ID number 0
CRIMINAL_COMP_CHARGE_TOKENS.TOKEN_ID COMPTOK_CHRGTOK_FK R
COURT_CASE_DELETE.ID Implied Constraint R
PK Unique identifier for record
CHARGE_CODE varchar2 30
CHARGE_CODES.CODE CHRGTOK_CHA_FK R
FK to CHARGE_CODES - Unique identifier for charge code
TOKEN_CODE varchar2 30
EJS_CODES.CODE CHRGTOK_EJSCD_TOKEN_FK R
FK to EJS_CODES - Unique identifier for token code
TOKEN_CODE_TYPE varchar2 30 'CC_TOKEN_FIELD_CODES'
EJS_CODES.CODE_TYPE CHRGTOK_EJSCD_TOKEN_FK R
FK to EJS_CODES - Unique identifier for token code type
SORT_ORDER number 0  √  null Order for this token to appear on the charge
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
"CHARGE_CODE" IS NOT NULL CHRGTOK_CHRG_CODE_NN
"ID" IS NOT NULL CHRGTOK_ID_NN
"TOKEN_CODE" IS NOT NULL CHRGTOK_TOKEN_CODE_NN
"TOKEN_CODE_TYPE" IS NOT NULL CHRGTOK_TOKEN_CODETYPE_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc CHRGTOK_PK
CHARGE_CODE Performance Asc CHRGTOK_CHA_FK_I
TOKEN_CODE_TYPE + TOKEN_CODE Performance Asc/Asc CHRGTOK_EJSCD_TOKEN_FK_I

Close relationships  within of separation: