Table slot9.WORLD.TSTA.RV_CONDITION_FACTORS
Associates Conditions With Factors
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 RVCF_RVC_FK C
FACTOR varchar2 100  √  null
OPERATOR_CODE varchar2 30  √  null
RV_OPERATOR_CODES.OPERATOR_CODE RVCF_RVOC_FK R
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
ID number 0
RV_CONDITION_FACTORS.PARENT_ID RVCF_RVCF_PAR_FK R
COURT_CASE_DELETE.ID Implied Constraint R
CUSTOM_OBJECT_ID number 0  √  null
RV_CUSTOM_OBJECTS.ID RVCF_RVCUSTOB_FK R
FIELD_ID number 0  √  null
USER_FIELDS.FIELD_ID RVCF_USRSCRN_F_FK C
ACCESSOR_ID number 0  √  null
RV_ACCESSORS.ID RVCF_RVACC_FK R
ACCESSOR_CHAIN_ID number 0  √  null
RV_ACCESS_CHAINS.CHAIN_ID RVCF_RVACCH_FK R
PARENT_ID number 0  √  null
RV_CONDITION_FACTORS.ID RVCF_RVCF_PAR_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

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

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc RVCF_PK
ACCESSOR_ID Performance Asc RVCF_RVACC_FK_I
ACCESSOR_CHAIN_ID Performance Asc RVCF_RVACCH_FK_I
CONDITION_ID Performance Asc RVCF_RVC_FK_I
PARENT_ID Performance Asc RVCF_RVCF_PAR_FK_I
CUSTOM_OBJECT_ID Performance Asc RVCF_RVCUSTOB_FK_I
OPERATOR_CODE Performance Asc RVCF_RVOC_FK_I
FIELD_ID Performance Asc RVCF_USRSCRN_F_FK_I

Close relationships  within of separation: