Table slot9.WORLD.TSTA.USER_SCREEN_TYPE_VIEWS
This table is used for custom form searches in the application

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
VIEW_ID number 0
USER_SCREEN_VIEWS.VIEW_ID USRSCRN_TV_USRSCRN_VW_FK R
SCREEN_TYPE_CODE varchar2 30
USER_SCREEN_TYPES.SCREEN_TYPE_CODE USRSCRN_TV_USRSCRN_TYP_FK R
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"SCREEN_TYPE_CODE" IS NOT NULL USRSCRN_TV_STC_NN
"VIEW_ID" IS NOT NULL USRSCRN_TV_VIEW_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
VIEW_ID + SCREEN_TYPE_CODE Primary key Asc/Asc USRSCRN_TV_PK
SCREEN_TYPE_CODE Performance Asc USRSCRN_TV_USRSCRN_TYP_FK_I
VIEW_ID Performance Asc USRSCRN_TV_USRSCRN_VW_FK_I

Close relationships  within of separation: