Table slot9.WORLD.TSTA.CITATION_VIOLATIONS
This table stores the violations added to the citation in the application
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
CITATION_VIOLATION_ID number 38
TDEX_RMS_CITATION_VW.CITATION_VIOLATION_ID Implied Constraint R
CITATION_ID number 38
CITATIONS.CITATION_ID CITVIO_CITATION_FK R
CHARGE_CODE varchar2 30  √  null
CHARGE_CODES.CODE CITVIO_CHA_FK R
CLASS_CODE varchar2 30  √  null
EJS_CODES.CODE CITVIO_EC_CHARGE_CLASS_FK R
CLASS_CODE_TYPE varchar2 30  √  'CITATION_CLASS_CODES'
EJS_CODES.CODE_TYPE CITVIO_EC_CHARGE_CLASS_FK R
NATURE_OF_OFFENSE varchar2 1000  √  null
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
FINE_AMOUNT number 0  √  null
DISPOSITION_CODE varchar2 30  √  null
EJS_CODES.CODE CITVIO_DISPOSITION_FK R
DISPOSITION_CODE_TYPE varchar2 30  √  'DISPOSITION_CODES'
EJS_CODES.CODE_TYPE CITVIO_DISPOSITION_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CITATION_ID" IS NOT NULL CITVIO_CITATION_ID_NN
"CITATION_VIOLATION_ID" IS NOT NULL CITVIO_VIO_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
CITATION_VIOLATION_ID Primary key Asc CITVIO_PK
CHARGE_CODE Performance Asc CITVIO_CHARGE_CODE_FK_I
CITATION_ID Performance Asc CITVIO_CITATION_FK_I
DISPOSITION_CODE_TYPE + DISPOSITION_CODE Performance Asc/Asc CITVIO_DISPOSITION_FK_I
CLASS_CODE_TYPE + CLASS_CODE Performance Asc/Asc CITVIO_EC_CHARGE_CLASS_FK_I

Close relationships  within of separation: