Table slot9.WORLD.TSTA.WARRANT_ARREST_CHARGES
This table stores the association of a warrant to a charge on an ARREST 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
WAR_ARREST_CHARGE_ID number 38
WARRANT_ID number 38
E_WARRANTS.WARRANT_ID WAC_EWAR_FK R
ARREST_CHARGE_CODE varchar2 30
ARREST_CHARGE_CODES.ARREST_CHARGE_CODE WAC_ARRCHRGCD_FK R
DISPLAY_INDEX number 38
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_CATEGORY_CODE varchar2 2  √  null
CHARGE_CATEGORY_CODES.CHARGE_CATEGORY_CODE WAC_CCC_FK R
CHARGE_CLASS_CODE varchar2 2  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ARREST_CHARGE_CODE" IS NOT NULL WAC_ARREST_CHG_CD_NN
"DISPLAY_INDEX" IS NOT NULL WAC_DISPLAY_IND_NN
"WAR_ARREST_CHARGE_ID" IS NOT NULL WAC_WACID_NN
"WARRANT_ID" IS NOT NULL WAC_WARRANT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
WAR_ARREST_CHARGE_ID Primary key Asc WAC_PK
ARREST_CHARGE_CODE Performance Asc WAC_ARRCHRGCD_FK_I
CHARGE_CATEGORY_CODE Performance Asc WAC_CCC_FK_I
WARRANT_ID Performance Asc WAC_EWAR_FK_I

Close relationships  within of separation: