Table slot9.WORLD.TSTA.USER_SCREEN_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
SCREEN_TYPE_SCREENS.VIEW_ID USRSCRN_STS_USRSCRN_VW_FK R
USER_SCREEN_TYPE_VIEWS.VIEW_ID USRSCRN_TV_USRSCRN_VW_FK R
USER_SCREEN_TYPES.DEFAULT_VIEW_ID USRSCRN_TYP_USRSCRN_VW_FK R
USER_SCREEN_VIEW_COLUMNS.VIEW_ID USRSCRN_VWCL_USRSCRN_VW_FK R
VIEW_NAME varchar2 100
DESCRIPTION varchar2 255  √  null
JOIN_FIELD_1 varchar2 100  √  null
JOIN_FIELD_2 varchar2 100  √  null
JOIN_FIELD_3 varchar2 100  √  null
JOIN_FIELD_4 varchar2 100  √  null
JOIN_FIELD_5 varchar2 100  √  null
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
"VIEW_NAME" IS NOT NULL USRSCRN_VW_VW_NAME_NN
"VIEW_ID" IS NOT NULL USRSCRN_VW_VWID_NN

Indexes:
Column(s) Type Sort Constraint Name
VIEW_ID Primary key Asc USRSCRN_VW_PK

Close relationships  within of separation: