Table slot9.WORLD.TSTA.RV_ACCESSORS
This table stores a hierarchical structure which defines objects that can be validated by the Rules & Validations Engine
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
ID number 0
RV_ACCESS_CHAIN_NODES.ACCESSOR_ID RVACCHNO_RVACC_ACC_FK R
RV_ACCESS_CHAIN_NODES.PARENT_ACCESSOR_ID RVACCHNO_RVACC_PAR_FK R
RV_ACCESSOR_FIELD_TYPES.ACCESSOR_ID RVAFT_RVACC_FK R
RV_ACCESSORS.COLLECTION_REF_ID RVACC_RVACC_COLLREF_FK R
RV_ACCESSORS.PARENT_ID RVACC_RVACC_PARENT_FK R
RV_ACCESSORS.REF_ID RVACC_RVACC_REF_FK R
RV_CONDITION_FACTORS.ACCESSOR_ID RVCF_RVACC_FK R
RV_CONDITION_PROPERTIES.ACCESSOR_ID RVCOPR_RVACC_FK C
RV_MODULE_CODES.ACCESSOR_ID RVMC_RVACC_FK R
COURT_CASE_DELETE.ID Implied Constraint R
PARENT_ID number 0  √  null
RV_ACCESSORS.ID RVACC_RVACC_PARENT_FK R
REF_ID number 0  √  null
RV_ACCESSORS.ID RVACC_RVACC_REF_FK R
COLLECTION_REF_ID number 0  √  null
RV_ACCESSORS.ID RVACC_RVACC_COLLREF_FK R
FIELD varchar2 100  √  null
DESCRIPTION varchar2 100  √  null
SECTION varchar2 100  √  null
MODULE_CODE varchar2 30  √  null
RV_MODULE_CODES.MODULE_CODE RVACC_RVMC_FK R
NATURE_CODE varchar2 30  √  null
RV_NATURE_CODES.NATURE_CODE RVACC_RVNC_FK R
SELECTABLE_FLAG varchar2 1  √  'N'
DATA_SOURCE_CODE varchar2 30  √  null
RV_DATA_SOURCE_CODES.SOURCE_CODE RVACC_RVDSC_FK R
DATA_SOURCE_EJS_CODE varchar2 30  √  null
EJS_CODES.CODE RVACC_EJSCD_SRC_FK R
DATA_SOURCE_EJS_CODE_TYPE varchar2 30  √  'EJS_CODES'
EJS_CODES.CODE_TYPE RVACC_EJSCD_SRC_FK R
ROOT_OBJECT_CODE varchar2 100  √  null
RV_ACCESSOR_OBJECTS.OBJECT_CODE RVACC_RVACCOB_FK R
FACTOR_FLAG varchar2 1  √  'N'
PROPERTY_FLAG varchar2 1  √  'N'
VISIBLE_FLAG varchar2 1  √  'Y'
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ID" IS NOT NULL RVACC_ID_NN

Indexes:
Column(s) Type Sort Constraint Name Anomalies
ID Primary key Asc RVACC_PK  
DATA_SOURCE_EJS_CODE_TYPE + DATA_SOURCE_EJS_CODE Performance Asc/Asc RVACC_EJSCD_SRC_FK_I  
ROOT_OBJECT_CODE Must be unique Asc RVACC_ROC_UK This unique column is also nullable
COLLECTION_REF_ID Performance Asc RVACC_RVACC_COLLREF_FK_I  
PARENT_ID Performance Asc RVACC_RVACC_PARENT_FK_I  
REF_ID Performance Asc RVACC_RVACC_REF_FK_I  
DATA_SOURCE_CODE Performance Asc RVACC_RVDSC_FK_I  
MODULE_CODE Performance Asc RVACC_RVMC_FK_I  
NATURE_CODE Performance Asc RVACC_RVNC_FK_I  

Close relationships  within of separation: