Table slot9.WORLD.TSTA.CRIMINAL_COMPLAINT_CHARGES
This table stores charge associations to criminal complaint records.
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.COMPLAINT_CHARGE_ID COMPTOK_CCCRG_FK R
COURT_CASE_DELETE.ID Implied Constraint R
PK - Unique identifier for each criminal complaint charge record.
CRIMINAL_COMPLAINT_ID number 0
CRIMINAL_COMPLAINTS.ID CCCRG_CRMCMP_FK R
FK to criminal_complaints table. Identify the criminal complaint record for association.
CHARGE_CODE varchar2 30
CHARGE_CODES.CODE CCCRG_CHA_FK R
FK to charge_codes table. Identify the charge for association.
CHARGE_DATE date 7  √  null Associated charge date.
COMMENTS varchar2 255  √  null Comment for associated 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
CHARGE_TIME date 7  √  null Time portion of associated charge date.
CITATION_NUMBER varchar2 100  √  null Citation Number.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CHARGE_CODE" IS NOT NULL CCCRG_CHRG_CD_NN
"CRIMINAL_COMPLAINT_ID" IS NOT NULL CCCRG_COMP_ID_NN
"ID" IS NOT NULL CCCRG_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc CCCRG_PK
CHARGE_CODE Performance Asc CCCRG_CHA_FK_I
CHARGE_DATE Performance Asc CCCRG_CHARGE_DATE_I
CITATION_NUMBER Performance Asc CCCRG_CITATION_NUM_I
CRIMINAL_COMPLAINT_ID Performance Asc CCCRG_CRMCMP_FK_I

Close relationships  within of separation: