Table slot9.WORLD.TSTA.INCIDENT_WARNINGS
This table stores incident warnings messages. Admin use only.
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
WARNING_ID number 0
ACTIVE_FLAG varchar2 1  √  'Y'
TYPE varchar2 50  √  null
SOLR_ASYNC_SETTINGS.TYPE Implied Constraint R
SECTION_CODE_TYPE varchar2 30
EJS_CODES.CODE_TYPE INCWARN_EJSCD_SECTION_FK R
SECTION_CODE varchar2 30
EJS_CODES.CODE INCWARN_EJSCD_SECTION_FK R
MESSAGE varchar2 1000  √  null
SQL varchar2 2000
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"SECTION_CODE" IS NOT NULL INCWARN_SEC_CD_NN
"SECTION_CODE_TYPE" IS NOT NULL INCWARN_SEC_CD_TYP_NN
"SQL" IS NOT NULL INCWARN_SQL_NN
"WARNING_ID" IS NOT NULL INCWARN_WAR_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
WARNING_ID Primary key Asc INCWARN_PK
SECTION_CODE_TYPE + SECTION_CODE Performance Asc/Asc INCWARN_EJSCD_SECTION_FK_I

Close relationships  within of separation: