Table slot9.WORLD.TSTA.ARREST_WARRANTS
This table stores the association with a warrant that is added to 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
ARREST_WARRANT_ID number 38
ARREST_ID number 38
ARRESTS.ARREST_ID ARRWAR_ARR_FK R
WARRANT_ID number 38  √  null
E_WARRANTS.WARRANT_ID ARRWAR_EWAR_FK R
WARRANT_NUMBER varchar2 50  √  null
COUNTY_CODE varchar2 30  √  null
EJS_CODES.CODE ARRWAR_CNTYCD_EJS_CODES_FK R
COUNTY_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ARRWAR_CNTYCD_EJS_CODES_FK R
WARRANT_COMMENT varchar2 4000  √  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
BOND_TYPE varchar2 2  √  null
BOND_TYPE_CODES.BOND_TYPE ARRWAR_BTC_FK R
BOND_AMOUNT number 12,2  √  null
OUT_OF_STATE_FLAG varchar2 1  √  null
STATE_CODE varchar2 30  √  null
EJS_CODES.CODE ARRWAR_EJSCD_STATCD_FK R
STATE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ARRWAR_EJSCD_STATCD_FK R
EXT_VERIFICATION varchar2 4000  √  null
EXT_CHARGE_DESC varchar2 100  √  null
WARRANT_STATUS_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ARRWAR_EJSCD_WAR_STS_CD_FK R
WARRANT_STATUS varchar2 30  √  null
EJS_CODES.CODE ARRWAR_EJSCD_WAR_STS_CD_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ARREST_ID" IS NOT NULL ARRWAR_ARREST_ID_NN
"ARREST_WARRANT_ID" IS NOT NULL ARRWAR_WARRANT_ID_NN
OUT_OF_STATE_FLAG IN ('Y', 'N') CK_ARRWAR_OOS_FLAG

Indexes:
Column(s) Type Sort Constraint Name
ARREST_WARRANT_ID Primary key Asc ARRWAR_PK
ARREST_ID Performance Asc ARRWAR_ARR_FK_I
BOND_TYPE Performance Asc ARRWAR_BTC_FK_I
COUNTY_CODE_TYPE + COUNTY_CODE Performance Asc/Asc ARRWAR_CNTYCD_EJS_CODES_FK_I
STATE_CODE_TYPE + STATE_CODE Performance Asc/Asc ARRWAR_EJSCD_STATCD_FK_I
WARRANT_STATUS_TYPE + WARRANT_STATUS Performance Asc/Asc ARRWAR_EJSCD_WAR_STS_CD_FK_I
WARRANT_ID Performance Asc ARRWAR_EWAR_FK_I

Close relationships  within of separation: