Table slot9.WORLD.TSTA.CRIMINAL_COMP_CHARGE_TOKENS
This table stores token values added to criminal complaint charges
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
COURT_CASE_DELETE.ID Implied Constraint R
PK Unique identifier for record
COMPLAINT_CHARGE_ID number 0
CRIMINAL_COMPLAINT_CHARGES.ID COMPTOK_CCCRG_FK R
FK to CRIMINAL_COMPLAINT CHARGES - Unique identifier for the charge on the complaint
TOKEN_ID number 0
CHARGE_CODE_TOKENS.ID COMPTOK_CHRGTOK_FK R
FK to CHARGE_CODE_TOKENS - Unique identifier for charge token
TOKEN_VALUE varchar2 4000 Stores the value for the charge code token
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
"COMPLAINT_CHARGE_ID" IS NOT NULL COMPTOK_COMP_CHRG_ID_NN
"ID" IS NOT NULL COMPTOK_ID_NN
"TOKEN_ID" IS NOT NULL COMPTOK_TOKEN_ID_NN
"TOKEN_VALUE" IS NOT NULL COMPTOK_TOKEN_VALUE_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc COMPTOK_PK
COMPLAINT_CHARGE_ID Performance Asc COMPTOK_CCCRG_FK_I
COMPLAINT_CHARGE_ID + TOKEN_ID Performance Asc/Asc COMPTOK_CHR_TOK_FK_I
TOKEN_ID Performance Asc COMPTOK_CHRGTOK_FK_I

Close relationships  within of separation: