Table slot9.WORLD.TSTA.RV_CONDITION_PROPERTIES
Associates properties with conditions
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_ID number 0
RV_CONDITIONS.CONDITION_ID RVCOPR_RVC_FK C
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
ID number 0
RV_COND_PROP_ATTRIBUTES.CP_ID RVCPA_RVCOPR_FK C
RV_COND_PROP_OBJ_VAR_VALUES.CP_ID RVCPOVV_RVCOPR_FK C
RV_CONDITION_PROPERTIES.PARENT_ID RPCOPR_RVCOPR_PAR_FK C
COURT_CASE_DELETE.ID Implied Constraint R
CUSTOM_OBJECT_ID number 0  √  null
FIELD_ID number 0  √  null
USER_FIELDS.FIELD_ID RVCOPR_USRSCRN_F_FK C
ACCESSOR_ID number 0  √  null
RV_ACCESSORS.ID RVCOPR_RVACC_FK C
ACCESSOR_CHAIN_ID number 0  √  null
RV_ACCESS_CHAINS.CHAIN_ID RVCOPR_RVACCH_FK R
PARENT_ID number 0  √  null
RV_CONDITION_PROPERTIES.ID RPCOPR_RVCOPR_PAR_FK C

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CONDITION_ID" IS NOT NULL RVCOPR_COND_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc RVCOPR_PK
CUSTOM_OBJECT_ID Performance Asc RPCOPR_CUSTOM_OBJECTID_I
PARENT_ID Performance Asc RPCOPR_RVCOPR_PAR_FK_I
ACCESSOR_ID Performance Asc RVCOPR_RVACC_FK_I
ACCESSOR_CHAIN_ID Performance Asc RVCOPR_RVACCH_FK_I
CONDITION_ID Performance Asc RVCOPR_RVC_FK_I
FIELD_ID Performance Asc RVCOPR_USRSCRN_F_FK_I

Close relationships  within of separation: