Table slot9.WORLD.TSTA.MAP_USER_SCREENS
Allows custom forms to be set up for use in RMS mapping.
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
SCREEN_ID number 0
USER_SCREEN_DELETE_AUDIT.SCREEN_ID Implied Constraint R
USER_SCREEN_INSTANCE_DELETE.SCREEN_ID Implied Constraint R
USER_SCREENS.SCREEN_ID MUS_USRSCRN_FK R
SCREEN_EVENT_TYPE_CODE varchar2 30
ADDRESS_FIELD_ID number 0
USER_FIELDS.FIELD_ID MUS_USRSCRN_F_6_FK R
DATE_FIELD_ID number 0
USER_FIELDS.FIELD_ID MUS_USRSCRN_F_5_FK R
FIELD_DISPLAY_1 number 0  √  null
USER_FIELDS.FIELD_ID MUS_USRSCRN_F_1_FK R
FIELD_DISPLAY_2 number 0  √  null
USER_FIELDS.FIELD_ID MUS_USRSCRN_F_2_FK R
FIELD_DISPLAY_3 number 0  √  null
USER_FIELDS.FIELD_ID MUS_USRSCRN_F_3_FK R
FIELD_DISPLAY_4 number 0  √  null
USER_FIELDS.FIELD_ID MUS_USRSCRN_F_4_FK R
MAP_ICON_ID number 0  √  null
MAP_ICONS.ID MUS_MAPIC_FK 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
"ADDRESS_FIELD_ID" IS NOT NULL MUS_ADDR_ID_NN
"DATE_FIELD_ID" IS NOT NULL MUS_DT_ID_NN
"SCREEN_EVENT_TYPE_CODE" IS NOT NULL MUS_SC_EVT_NN
"SCREEN_ID" IS NOT NULL MUS_SCRN_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
SCREEN_ID Primary key Asc MUS_PK
MAP_ICON_ID Performance Asc MUS_MAPIC_FK_I
FIELD_DISPLAY_1 Performance Asc MUS_USRSCRN_F_1_FK_I
FIELD_DISPLAY_2 Performance Asc MUS_USRSCRN_F_2_FK_I
FIELD_DISPLAY_3 Performance Asc MUS_USRSCRN_F_3_FK_I
FIELD_DISPLAY_4 Performance Asc MUS_USRSCRN_F_4_FK_I
DATE_FIELD_ID Performance Asc MUS_USRSCRN_F_5_FK_I
ADDRESS_FIELD_ID Performance Asc MUS_USRSCRN_F_6_FK_I

Close relationships  within of separation: