Table slot9.WORLD.TSTA.RV_MODULE_SCREEN_TYPES
This table associates modules with custom from types
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
RV_MODULE_CODES.MODULE_CODE RVMODST_RVMC_FK C
SCREEN_TYPE_CODE varchar2 30
USER_SCREEN_TYPES.SCREEN_TYPE_CODE RVMODST_USRSCRN_TYP_FK C
OPERATOR_CODE varchar2 30  √  null
RV_OPERATOR_CODES.OPERATOR_CODE Implied Constraint R
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
"MODULE_CODE" IS NOT NULL RVMODST_MOD_CD_NN
"SCREEN_TYPE_CODE" IS NOT NULL RVMODST_STS_CD_NN

Indexes:
Column(s) Type Sort Constraint Name
MODULE_CODE + SCREEN_TYPE_CODE Primary key Asc/Asc RVMODST_PK
MODULE_CODE Performance Asc RVMODST_RVMC_FK_I
SCREEN_TYPE_CODE Performance Asc RVMODST_USRSCRN_TYP_FK_I

Close relationships  within of separation: