Table slot9.WORLD.TSTA.CHAIN_OF_CUSTODIES
This table stores the chain of custody for a piece of evidence
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
CUSTODY_ID number 0
ITEM_CUSTODIES.CUSTODY_ID Implied Constraint R
Chain of custody ID
EVID_LOC_CODE varchar2 30
EVIDENCE_LOCATION_CODES.EVID_LOC_CODE COC_ELC_FK R
Code for Evidence Location
CUSTODY_DATE date 7 Date of transaction
CUSTODY_OFF_FROM varchar2 100  √  null Transfered From
CUSTODY_OFF_TO varchar2 100  √  null Transfered To
PURPOSE varchar2 40 Purpose of Custody Change
CREATOR_ID varchar2 100  √  null Creator User ID
CREATOR_DATE date 7  √  null Creator Date
UPDATOR_ID varchar2 100  √  null Updator User ID
UPDATOR_DATE date 7  √  null Updator Date
LOCATION varchar2 255  √  null
AGNCY_CD_AGENCY_CODE varchar2 30
EVIDENCE_LOCATION_CODES.AGNCY_CD_AGENCY_CODE COC_ELC_FK R
Agency involved
EVIDENCE_ID number 38
EVIDENCE.EVIDENCE_ID COC_EVI_FK C
DESCRIPTION varchar2 2500  √  null
RECEIVED_DATE date 7  √  null
COC_COMMENT varchar2 255  √  null
DUE_DATE date 7  √  null
EVID_DEST_ID number 0  √  null
EVIDENCE_DESTINATION_CODES.EVID_DEST_ID COC_EDC1_FK R
REC_ID number 0  √  null
AUCTION_AMOUNT number 10,2  √  null Auction Amount
CUSTODY_EMP_FROM varchar2 40  √  null
CUSTODY_EMP_TO varchar2 40  √  null
IMAGE_ID number 38  √  null
IMAGES.IMAGE_ID COC_IMG_ID_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGNCY_CD_AGENCY_CODE" IS NOT NULL COC_AGNCY_CD_AGENCY_CODE_NN
"CUSTODY_DATE" IS NOT NULL COC_CUSTODY_DATE_NN
"CUSTODY_ID" IS NOT NULL COC_CUSTODY_ID_NN
"EVID_LOC_CODE" IS NOT NULL COC_EVID_LOC_CODE_NN
"EVIDENCE_ID" IS NOT NULL COC_EVIDENCE_ID_NN
"PURPOSE" IS NOT NULL COC_PURPOSE_NN

Indexes:
Column(s) Type Sort Constraint Name
EVIDENCE_ID + CUSTODY_ID Primary key Asc/Asc COC_PK
EVID_DEST_ID Performance Asc COC_EDC1_FK_I
AGNCY_CD_AGENCY_CODE + EVID_LOC_CODE Performance Asc/Asc COC_ELC_FK_I
EVIDENCE_ID Performance Asc COC_EVI_FK_I
IMAGE_ID Performance Asc COC_IMG_ID_FK_I

Close relationships  within of separation: