Table slot9.WORLD.TSTA.EJS_INC_REPORT_VALIDATIONS
This table defines the different INCIDENT report validation and checks
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
REPORT_VALDN_ID number 0
EJS_INC_VLDN_ERR_VARIABLES.REPORT_VALDN_ID EIVLDNERR_EIRV_FK R
EJS_INC_VLDN_ERRORS.REPORT_VALDN_ID EIVE_EIRV_FK R
The sequence generated value for each validation entry
DESCRIPTION varchar2 4000  √  null
ERROR_ID number 0  √  null
ERROR_CODES.ERROR_ID EIRV_EC_FK R
SECTION_CODE varchar2 30  √  null
EJS_CODES.CODE EIRV_SECT_TYPE_COD_EJS_CODE_FK R
SECTION_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EIRV_SECT_TYPE_COD_EJS_CODE_FK R
ACTION_NAME varchar2 255  √  null
ACTION_DISPATCHTO varchar2 255  √  null
SORT_ORDER number 0  √  null
STATUS_CODE varchar2 30  √  null
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
REC_ID number 0  √  null
UCR_ENABLED varchar2 1 'N'
INIT_SUPP_ONLY varchar2 1 'N'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
UCR_ENABLED IN ('N', 'Y') CK_EIRV_UCR_ENABLED
"INIT_SUPP_ONLY" IS NOT NULL EIRV_INIT_ONLY_NN
"REPORT_VALDN_ID" IS NOT NULL EIRV_REPORT_VALDN_ID_NN
"UCR_ENABLED" IS NOT NULL EIRV_UCR_ENABLED_NN

Indexes:
Column(s) Type Sort Constraint Name Anomalies
REPORT_VALDN_ID Primary key Asc EIRV_PK  
ACTION_NAME + ERROR_ID Must be unique Asc/Asc EIRV_ACTION_ERROR_UK These unique columns are also nullable
ERROR_ID Performance Asc EIRV_EC_FK_I  
SECTION_CODE_TYPE + SECTION_CODE Performance Asc/Asc EJS_INC_REPORT_VALIDATIONS_I  

Close relationships  within of separation: