Table slot9.WORLD.TSTA.EVIDENCE_OFFICERS
This tables stores the association to an officer added to a piece of evidence 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
EVID_OFF_ID number 0
EVID_EVIDENCE_ID number 0
EVIDENCE.EVIDENCE_ID EVIDOFF_EVI_FK R
Evidence ID number
OFF1_OFFICER_ID number 0
OFFICERS.OFFICER_ID EVIDOFF_OFF1_FK R
Officer ID number
PURPOSE varchar2 100  √  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

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"EVID_EVIDENCE_ID" IS NOT NULL EVIDOFF_EVID_EVIDENCE_ID_NN
"EVID_OFF_ID" IS NOT NULL EVIDOFF_EVID_OFF_ID_NN
"OFF1_OFFICER_ID" IS NOT NULL EVIDOFF_OFF1_OFF_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
EVID_OFF_ID Primary key Asc EVIDOFF_PK
EVID_EVIDENCE_ID Performance Asc EVIDOFF_EVI_FK_I
OFF1_OFFICER_ID Performance Asc EVIDOFF_OFF1_FK_I
EVID_EVIDENCE_ID + OFF1_OFFICER_ID + PURPOSE Must be unique Asc/Asc/Asc EVIDOFF_OFF_PUR_UK

Close relationships  within of separation: