Table slot9.WORLD.TSTA.EVIDENCE_DELETE
This table store the a piece of evidence information when the evidence is deleted 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
EVIDENCE_ID number 0
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE Implied Constraint R
DELETE_COMMENT varchar2 4000
LOG_ID number 38
ACCESS_LOGS.LOG_ID Implied Constraint R
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
"AGENCY_CODE" IS NOT NULL EVID_DEL_AGNCY_NN
"DELETE_COMMENT" IS NOT NULL EVID_DEL_CMNT_NN
"EVIDENCE_ID" IS NOT NULL EVID_DEL_EVID_ID_NN
"LOG_ID" IS NOT NULL EVID_DEL_LOG_ID_NN
"PRO_PROPERTY_ID" IS NOT NULL EVID_DEL_PROP_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
EVIDENCE_ID + LOG_ID Primary key Asc/Asc EVID_DEL_PK

Close relationships: