Table slot9.WORLD.TSTA.USER_SCREEN_TYPES
This table defines the module type within the application that a custom form can be associated with (e.g. Incident, field ARREST)
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_TYPE_CODE varchar2 30
RV_MODULE_SCREEN_TYPES.SCREEN_TYPE_CODE RVMODST_USRSCRN_TYP_FK C
SCREEN_TYPE_RPT_INCLUDES.SCREEN_TYPE_CODE STRI_USRSCRN_TYP_FK R
SCREEN_TYPE_SCREENS.SCREEN_TYPE_CODE USRSCRN_STS_USRSCRN_TYP_FK R
USER_SCREEN_HEADERS.SCREEN_TYPE_CODE USH_USRSCRN_TYP_FK R
USER_SCREEN_INSTANCES.SCREEN_TYPE_CODE USRSCRN_INST_USRSCRN_TYP_FK R
USER_SCREEN_TYPE_VIEWS.SCREEN_TYPE_CODE USRSCRN_TV_USRSCRN_TYP_FK R
USI_SEARCH_VW.SCREEN_TYPE_CODE Implied Constraint R
NAME varchar2 255  √  null
KEY_NAME_1 varchar2 100  √  null
KEY_NAME_2 varchar2 100  √  null
KEY_NAME_3 varchar2 100  √  null
KEY_NAME_4 varchar2 100  √  null
KEY_NAME_5 varchar2 100  √  null
DEFAULT_REPORT_ID number 0  √  null
MASTER_REPORTS.MASTER_REPORT_ID USRSCRN_TYP_MREP_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
DEFAULT_VIEW_ID number 0  √  null
USER_SCREEN_VIEWS.VIEW_ID USRSCRN_TYP_USRSCRN_VW_FK R
TABLE_NAME varchar2 40  √  null
APPLICATION_TABLES.TABLE_NAME USRSCRN_TYP_APP_TABLES_FK R
TABLE_COL_1 varchar2 40  √  null
TABLE_COL_2 varchar2 40  √  null
TABLE_COL_3 varchar2 40  √  null
TABLE_COL_4 varchar2 40  √  null
TABLE_COL_5 varchar2 40  √  null
TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE USRSCRN_TYP_TYP_CODE_FK R
TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE USRSCRN_TYP_TYP_CODE_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"SCREEN_TYPE_CODE" IS NOT NULL USRSCRN_TYP_SCRNTYPCD_NN

Indexes:
Column(s) Type Sort Constraint Name
SCREEN_TYPE_CODE Primary key Asc USRSCRN_TYP_PK
TABLE_NAME Performance Asc USRSCRN_TYP_APP_TABLES_FK_I
DEFAULT_REPORT_ID Performance Asc USRSCRN_TYP_MREP_FK_I
TYPE_CODE_TYPE + TYPE_CODE Performance Asc/Asc USRSCRN_TYP_TYP_CODE_FK_I
DEFAULT_VIEW_ID Performance Asc USRSCRN_TYP_USRSCRN_VW_FK_I

Close relationships  within of separation: