Table slot9.WORLD.TSTA.INCIDENT_DELETE
This tables stores the INCIDENT information when an INCIDENT is deleted from 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
UPDATOR_ID varchar2 100  √  null USER ID of the person updating record.
SUPP_SEQ number 38 A number indicating which supplement it is.
INCIDENT_ID number 38 A number used to identify a deleted incident.
UPDATOR_DATE date 7  √  null Date the record was updated.
CREATOR_DATE date 7  √  null Date the report was deleted.
CREATOR_ID varchar2 100  √  null USER ID of the person deleting the report.
ID_COMMENT varchar2 4000 Indicates the reason the report was deleted.
REPORT_DATE date 7  √  null Indicates the date the report was filed.
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE Implied Constraint R
Identifies the origingating agency of the report.
OFFICER_ID number 38  √  null A number used to identify the originating officer of the report.
INC_REPORT_NUMBER varchar2 20
OLD_STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE ID_OLD_STATUS_CODE_EJS_CODE_FK R
NEW_STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE ID_NEW_STATUS_CODE_EJS_CODE_FK R
LOG_ID number 38
ACCESS_LOGS.LOG_ID Implied Constraint R
NEW_STATUS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ID_NEW_STATUS_CODE_EJS_CODE_FK R
OLD_STATUS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ID_OLD_STATUS_CODE_EJS_CODE_FK R
REC_ID number 0  √  null
LOADED_BY varchar2 30  √  null
EXTERNAL_SYSTEM_CODES.CODE ID_EXSYS_FK R
LAST_LOAD_DATE date 7  √  null
REVIEW_INSTANCE_ID number 32  √  null
INC_REVIEW_ROUTE_INSTANCES.INSTANCE_ID ID_INCRVWRTINST_FK R
If populated, it references the INC_REVIEW_ROUTE_INSTANCES record that triggered this delete log entry
COMMENT_GROUP_ID number 0  √  null
INC_COMMENT_GROUPS.ID ID_INCCOMGRP_FK R
DISPATCH_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ID_COMMENT" IS NOT NULL ID_ID_COMMENT_NN
"INC_REPORT_NUMBER" IS NOT NULL ID_INC_REPORT_NUMBER_NN
"INCIDENT_ID" IS NOT NULL ID_INCIDENT_ID_NN
"LOG_ID" IS NOT NULL ID_LOG_ID_NN
"SUPP_SEQ" IS NOT NULL ID_SUPP_SEQ_NN

Indexes:
Column(s) Type Sort Constraint Name
INCIDENT_ID + SUPP_SEQ + LOG_ID Primary key Asc/Asc/Asc ID_PK
LOADED_BY Performance Asc ID_EXSYS_FK_I
COMMENT_GROUP_ID Performance Asc ID_INCCOMGRP_FK_I
REVIEW_INSTANCE_ID Performance Asc ID_INCRVWRTINST_FK_I
NEW_STATUS_CODE Performance Asc ID_ISC_NEW_FK_I
OLD_STATUS_CODE Performance Asc ID_ISC_OLD_FK_I
NEW_STATUS_CODE_TYPE + NEW_STATUS_CODE Performance Asc/Asc ID_NEW_STATUS_CODE_EJS_CODE_I
OLD_STATUS_CODE_TYPE + OLD_STATUS_CODE Performance Asc/Asc ID_OLD_STATUS_CODE_EJS_CODE_I

Close relationships  within of separation: