Table slot9.WORLD.TSTA.ARREST_PEOPLE
This table stores the association to MASTER PEOPLE 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_PERSON_ID number 0
ARREST_PERSON_ROLES.ARREST_PERSON_ID ARRPR_ARRP_FK R
ARREST_PERSON_SEARCH_VW.ARREST_PERSON_ID Implied Constraint R
ARREST_ID number 0
ARRESTS.ARREST_ID ARRP_ARR_FK R
PERSON_ID number 0
MASTER_NAMES.PER_PERSON_ID ARRP_MN_FK R
MN_ID number 0
MASTER_NAMES.MN_ID ARRP_MN_FK R
AGE_CODE varchar2 30  √  null
EJS_CODES.CODE ARRP_EJSCD_AGECD_FK R
AGE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ARRP_EJSCD_AGECD_FK R
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ARREST_ID" IS NOT NULL ARRP_ARREST_ID_NN
"MN_ID" IS NOT NULL ARRP_MN_ID_NN
"ARREST_PERSON_ID" IS NOT NULL ARRP_NAME_ID_NN
"PERSON_ID" IS NOT NULL ARRP_PERSON_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ARREST_PERSON_ID Primary key Asc ARRP_PK
ARREST_ID Performance Asc ARRP_ARR_FK_I
AGE_CODE_TYPE + AGE_CODE Performance Asc/Asc ARRP_EJSCD_AGECD_FK_I
MN_ID + PERSON_ID Performance Asc/Asc ARRP_MN_FK_I

Close relationships  within of separation: