Table slot9.WORLD.TSTA.DOMESTIC_VIOLENCE_VICTIMS
This table stores the association to a MASTER PERSON if that MASTER PERSON is added as a victim of domestic violence 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_ID number 0
ARRESTS.ARREST_ID DVV_ARR_FK C
Arrest ID number.
PERSON_ID number 0
PEOPLE.PERSON_ID DVV_PER_FK C
Person ID number
CREATOR_ID varchar2 100  √  null User that created the record.
CREATOR_DATE date 7  √  null date record was created.
UPDATOR_ID varchar2 100  √  null User that last updated record.
UPDATOR_DATE date 7  √  null Date record was last updated.
REC_ID number 0  √  null
VR_METHOD_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE DVV_VR_METHOD_EJS_CD_FK R
Victim Rights Notification Method Type
VR_METHOD_CODE varchar2 30  √  null
EJS_CODES.CODE DVV_VR_METHOD_EJS_CD_FK R
Victim Rights Notification Method Code
VR_DATE_NOTIFIED date 7  √  null Victim Rights Notification Date
VR_COMMENTS varchar2 4000  √  null Victim Rights Notification Comment

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ARREST_ID" IS NOT NULL DVV_ARREST_ID_NN
"PERSON_ID" IS NOT NULL DVV_PERSON_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ARREST_ID + PERSON_ID Primary key Asc/Asc DVV_PK
ARREST_ID Performance Asc DVV_ARR_FK_I
PERSON_ID Performance Asc DVV_PER_FK_I
VR_METHOD_CODE_TYPE + VR_METHOD_CODE Performance Asc/Asc DVV_VR_METHOD_EJS_CD_FK_I

Close relationships  within of separation: