Table slot9.WORLD.TSTA.INC_VAL_COND_PROP_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
CONDITION_CODE varchar2 30
INC_VALID_CONDITIONS.CONDITION_CODE IVCPC_IVC_FK R
Foreign key to the INC_VALID_CONDITIONS table.
PROPERTY_CODE varchar2 30
INC_VALID_PROPERTIES.PROPERTY_CODE IVCPC_IVP_FK R
Foreign key to the INC_VALID_PROPERTIES 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
"CONDITION_CODE" IS NOT NULL IVCPC_COND_CDE_NN
"PROPERTY_CODE" IS NOT NULL IVCPC_PROP_CDE_NN

Indexes:
Column(s) Type Sort Constraint Name
CONDITION_CODE + PROPERTY_CODE Primary key Asc/Asc IVCPC_PK
CONDITION_CODE Performance Asc IVCPC_IVC_FK_I
PROPERTY_CODE Performance Asc IVCPC_IVP_FK_I

Close relationships  within of separation: