Table slot9.WORLD.TSTA.INC_VAL_PROP_ATTR_CDE
This table is used 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
PROPERTY_CODE varchar2 30
INC_VALID_PROPERTIES.PROPERTY_CODE IVPAC_IVP_FK R
Foreign key to the INC_VALID_PROPERTIES table.
ATTRIBUTE_CODE varchar2 30
INC_VALID_ATTRIBUTES.ATTRIBUTE_CODE IVPAC_IVA_FK R
Foreign key to the INC_VALID_ATTRIBUTES table.
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_CODE" IS NOT NULL IVPAC_ATTR_CDE_NN
"PROPERTY_CODE" IS NOT NULL IVPAC_PROP_CDE_NN

Indexes:
Column(s) Type Sort Constraint Name
PROPERTY_CODE + ATTRIBUTE_CODE Primary key Asc/Asc IVPAC_PK
ATTRIBUTE_CODE Performance Asc IVPAC_IVA_FK_I
PROPERTY_CODE Performance Asc IVPAC_IVP_FK_I

Close relationships  within of separation: