Table slot9.WORLD.TSTA.RV_MODULE_CODES
Stores modules using field validations
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
MODULE_CODE varchar2 30
QUESTION_TYPES_VW.MODULE_CODE Implied Constraint R
RV_ACCESSORS.MODULE_CODE RVACC_RVMC_FK R
RV_CONDITIONS.MODULE_CODE RVC_RVMC_FK R
RV_CUSTOM_OBJECTS.MODULE_CODE RVCUSTOB_RVMC_FK R
RV_FACTORS.MODULE_CODE RVFA_RVMC_FK R
RV_MODULE_CODES.PARENT_CODE RVMC_RVMC_FK R
RV_MODULE_SCREEN_TYPES.MODULE_CODE RVMODST_RVMC_FK C
RV_PROPERTIES.MODULE_CODE RVPROP_RVMC_FK R
DESCRIPTION varchar2 100  √  null
PARENT_CODE varchar2 30  √  null
RV_MODULE_CODES.MODULE_CODE RVMC_RVMC_FK R
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
ACCESSOR_ID number 0  √  null
RV_ACCESSORS.ID RVMC_RVACC_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"MODULE_CODE" IS NOT NULL RVMC_MOD_CD_NN

Indexes:
Column(s) Type Sort Constraint Name
MODULE_CODE Primary key Asc RVMC_PK
ACCESSOR_ID Performance Asc RVMC_RVACC_FK_I
PARENT_CODE Performance Asc RVMC_RVMC_FK_I

Close relationships  within of separation: