Table slot9.WORLD.TSTA.EVIDENCE
This table stores the piece of evidence information added 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
PRO_PROPERTY_ID number 0
PROPERTIES.PROPERTY_ID EVI_PRO_FK C
Property ID number
OFF1_OFFICER_ID number 0  √  null
OFFICERS.OFFICER_ID EVI_OFF1_FK R
Officer ID number
EVID_LOC_CODE varchar2 30  √  null
EVIDENCE_LOCATION_CODES.EVID_LOC_CODE EVI_ELC_FK R
Code for Evidence Location
TOC_OUTCOME_CODE varchar2 1  √  null
TEST_OUTCOME_CODES.OUTCOME_CODE EVI_TOC_FK R
Code for outcome of test
DISPOSITION_CODE varchar2 30  √  null
EJS_CODES.CODE EVI_DISPOSITION_CO_EJS_CODE_FK R
Disposition Code
STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE EVI_STATUS_CODE_EJS_CODE_FK R
Evidence status code.
DESCRIPTION varchar2 2500  √  null
DISPOSITION_DATE date 7  √  null Date of Evidence Dispositon
CREATOR_ID varchar2 100  √  null Creator User ID
CREATOR_DATE date 7  √  null Creator Date
UPDATOR_DATE date 7  √  null Updator Date
UPDATOR_ID varchar2 100  √  null Updator User ID
AGNCY_CD_AGENCY_CODE varchar2 30  √  null
EVIDENCE_LOCATION_CODES.AGNCY_CD_AGENCY_CODE EVI_ELC_FK R
Agency involved
EVIDENCE_ID number 38
CHAIN_OF_CUSTODIES.EVIDENCE_ID COC_EVI_FK C
EVIDENCE_AUDIT_REP_DETAILS.EVIDENCE_ID EVID_ARD_EVI_FK R
EVIDENCE_COC_MOST_RECENT_VW.EVIDENCE_ID Implied Constraint R
EVIDENCE_CUSTODY_VW.EVIDENCE_ID Implied Constraint R
EVIDENCE_OFFICERS.EVID_EVIDENCE_ID EVIDOFF_EVI_FK R
EVIDENCE_PROCESSINGS.EVIDENCE_ID EP_EVI_FK C
EVIDENCE_STATUS_VW.EVIDENCE_ID Implied Constraint R
INCIDENT_EVIDENCE_VW.EVIDENCE_ID Implied Constraint R
INCIDENT_PROPERTIES.EVIDENCE_ID INCPRO_EVI_FK R
JS_EVIDENCE_VW.EVIDENCE_ID Implied Constraint R
JS_INCIDENT_EVIDENCE_VW.EVIDENCE_ID Implied Constraint R
JS_INCIDENT_OFFNDR_EVIDENCE_VW.EVIDENCE_ID Implied Constraint R
SCHED_DISP_DATE date 7  √  null
DISP_ORDER_DATE date 7  √  null
EJS_EMP_ID number 30  √  null
EMPLOYEES.EJS_EMP_ID EVI_EMP1_FK R
EJS sequence to uniquely identify an employee.
DISPOSITION_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EVI_DISPOSITION_CO_EJS_CODE_FK R
STATUS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EVI_STATUS_CODE_EJS_CODE_FK R
REC_ID number 0  √  null
INTERNAL_TRACKING_NUM varchar2 255  √  null
DATE_OF_INFO date 7  √  null
REVIEW_DATE date 7  √  null
SCHED_DISP_COMMENT varchar2 255  √  null
HOLD_CODE varchar2 30  √  null
EJS_CODES.CODE EVI_HOLD_CODE_EJS_CODE_FK R
EJS Code for evidence hold.
HOLD_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EVI_HOLD_CODE_EJS_CODE_FK R
EJS Code Type for evidence hold.
HOLD_END_DATE date 7  √  null End date for evidence hold.
HOLD_COMMENT_ID number 0  √  null EJS Comment ID for evidence hold comment.
RECOVERY_LOCATION varchar2 255  √  null Free text value describs where evidence originally recovered.
PROP_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE EVI_EJSCD_PROPTYPECD_FK R
EJS Code determines if this is evidence or held property.
PROP_TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EVI_EJSCD_PROPTYPECD_FK R
EJS Code Type determines if this is evidence or held property.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"EVIDENCE_ID" IS NOT NULL EVI_EVIDENCE_ID_NN
"PRO_PROPERTY_ID" IS NOT NULL EVI_PRO_PROPERTY_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
EVIDENCE_ID Primary key Asc EVI_PK
DISPOSITION_CODE_TYPE + DISPOSITION_CODE Performance Asc/Asc EVI_DISPOSITION_CO_EJS_CODE_I
DISPOSITION_CODE Performance Asc EVI_EDC_FK_I
PROP_TYPE_CODE_TYPE + PROP_TYPE_CODE Performance Asc/Asc EVI_EJSCD_PROPTYPECD_FK_I
AGNCY_CD_AGENCY_CODE + EVID_LOC_CODE Performance Asc/Asc EVI_ELC_FK_I
EJS_EMP_ID Performance Asc EVI_EMP1_FK_I
STATUS_CODE Performance Asc EVI_ESC_FK_I
HOLD_CODE_TYPE + HOLD_CODE Performance Asc/Asc EVI_HOLD_CODE_EJS_CODE_FK_I
OFF1_OFFICER_ID Performance Asc EVI_OFF1_FK_I
PRO_PROPERTY_ID Performance Asc EVI_PRO_FK_I
STATUS_CODE_TYPE + STATUS_CODE Performance Asc/Asc EVI_STATUS_CODE_EJS_CODE_I
TOC_OUTCOME_CODE Performance Asc EVI_TOC_FK_I

Close relationships  within of separation: