Table slot9.WORLD.TSTA.VICTIM_ARRESTEES
This table stores the relationship between a victim and an offense on an INCIDENT 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
VA_NUMBER number 0 The Arrestee or Victim information.
OFFNSE_INC_INCIDENT_ID number 0
OFFENSES.INC_INCIDENT_ID VA_OFFNSE_FK C
Incident ID number assigned
OFFNSE_OFFENSE_NUMBER number 0
OFFENSES.OFFENSE_NUMBER VA_OFFNSE_FK C
Number assigned to track the offense
RELTN_RELATION_CODE varchar2 30  √  null
EJS_CODES.CODE VA_REL_EJS_CODES_FK R
relationship code {to other person(s) }
CREATOR_DATE date 7  √  null
CREATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
OFFNSE_SUPP_SEQ number 5
OFFENSES.SUPP_SEQ VA_OFFNSE_FK C
INC_PER_ID number 0  √  null
INCIDENT_PEOPLE.INC_PER_ID VA_INCPER_FK C
V_NUMBER number 38
VICTIMS.V_NUMBER VA_VIC_FK C
RELATION_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE VA_REL_EJS_CODES_FK R
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"OFFNSE_INC_INCIDENT_ID" IS NOT NULL VA_OFFNSE_INC_INCIDENT_ID_NN
"OFFNSE_OFFENSE_NUMBER" IS NOT NULL VA_OFFNSE_OFFENSE_NUMBER_NN
"OFFNSE_SUPP_SEQ" IS NOT NULL VA_OFFNSE_SUPP_SEQ_NN
"V_NUMBER" IS NOT NULL VA_V_NUMBER_NN
"VA_NUMBER" IS NOT NULL VA_VA_NUMBER_NN

Indexes:
Column(s) Type Sort Constraint Name
VA_NUMBER Primary key Asc VA_PK
INC_PER_ID Performance Asc VA_INCPER_FK_I
OFFNSE_INC_INCIDENT_ID + OFFNSE_OFFENSE_NUMBER + OFFNSE_SUPP_SEQ Performance Asc/Asc/Asc VA_OFFNSE_FK_I
RELATION_CODE_TYPE + RELTN_RELATION_CODE Performance Asc/Asc VA_REL_EJS_CODES_FK_I
V_NUMBER Performance Asc VA_VIC_FK_I

Close relationships  within of separation: