Table slot9.WORLD.TSTA.INC_VALID_ATTRIBUTES
This tables stores attributes for INCIDENT rule validations executed 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
ATTRIBUTE_CODE varchar2 30
INC_VAL_PROP_ATTR_CDE.ATTRIBUTE_CODE IVPAC_IVA_FK R
RV_ATTRIBUTES.ATTRIBUTE_CODE Implied Constraint R
Unique Primary key for each attribute.
ATTRIBUTE_TYPE_CODE varchar2 30
EJS_CODES.CODE IVA_ATC_EJS_CODES_FK R
Foreign key to EJS_CODES to identify the Rules attrbute element.
ATTRIBUTE_TYPE_CODE_TYPE varchar2 30
EJS_CODES.CODE_TYPE IVA_ATC_EJS_CODES_FK R
ATTRIBUTE_TYPE_CODES to identify the EJS_CODE_TYPE
ATTRIBUTE_OPERATOR varchar2 2 The operator that indicates the relation of the attribute to the value(e.g. EQ, LE).
ATTRIBUTE_VALUE varchar2 255 The value to be related to the attribute.
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
ATTRIBUTE_OPERATOR IN ('EQ', 'NE', 'LT', 'LE', 'GT', 'GE') CK_IVA_ATTRIBUTE_OPERATOR
"ATTRIBUTE_TYPE_CODE_TYPE" IS NOT NULL IVA_ATTC_TYPE_NN
"ATTRIBUTE_CODE" IS NOT NULL IVA_ATTR_CODE_NN
"ATTRIBUTE_OPERATOR" IS NOT NULL IVA_ATTR_OPER_NN
"ATTRIBUTE_VALUE" IS NOT NULL IVA_ATTR_VALUE_NN
"ATTRIBUTE_TYPE_CODE" IS NOT NULL IVA_ATTY_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
ATTRIBUTE_CODE Primary key Asc IVA_PK
ATTRIBUTE_TYPE_CODE_TYPE + ATTRIBUTE_TYPE_CODE Performance Asc/Asc IVA_ATC_EJS_CODES_FK_I

Close relationships  within of separation: