Table slot9.WORLD.TSTA.SCREEN_TYPE_SCREENS
This table maps custom forms from USER_SCREENS to a SCREEN_TYPE (e.g. Incident, Field Arrest) in order for the application to know where to associate the custom form
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 38
RV_CONDITIONS.SCREEN_ID RVC_USRSCRN_STS_FK C
SCREEN_TYPE_SCREEN_PDFS.SCREEN_ID STSP_USRSCRN_STS_FK R
SCREEN_TYPE_SCREEN_RPTS.SCREEN_ID STSR_USRSCRN_STS_FK R
USER_SCREENS.SCREEN_ID USRSCRN_STS_USRSCRN_FK R
SCREEN_TYPE_CODE varchar2 30
RV_CONDITIONS.SCREEN_TYPE_CODE RVC_USRSCRN_STS_FK C
SCREEN_TYPE_SCREEN_PDFS.SCREEN_TYPE_CODE STSP_USRSCRN_STS_FK R
SCREEN_TYPE_SCREEN_RPTS.SCREEN_TYPE_CODE STSR_USRSCRN_STS_FK R
USER_SCREEN_TYPES.SCREEN_TYPE_CODE USRSCRN_STS_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
REPORT_ID number 0  √  null
MASTER_REPORTS.MASTER_REPORT_ID USRSCRN_STS_MREP_FK R
VIEW_ID number 0  √  null
USER_SCREEN_VIEWS.VIEW_ID USRSCRN_STS_USRSCRN_VW_FK R
HEADER_ID number 38  √  null
USER_SCREEN_HEADERS.HEADER_ID USRSCRN_STS_USH_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"SCREEN_ID" IS NOT NULL USRSCRN_STS_SCREEN_ID_NN
"SCREEN_TYPE_CODE" IS NOT NULL USRSCRN_STS_SCRNTYPECD_NN

Indexes:
Column(s) Type Sort Constraint Name
SCREEN_ID + SCREEN_TYPE_CODE Primary key Asc/Asc USRSCRN_STS_PK
REPORT_ID Performance Asc USRSCRN_STS_MREP_FK_I
HEADER_ID Performance Asc USRSCRN_STS_USH_FK_I
SCREEN_ID Performance Asc USRSCRN_STS_USRSCRN_FK_I
SCREEN_TYPE_CODE Performance Asc USRSCRN_STS_USRSCRN_TYP_FK_I
VIEW_ID Performance Asc USRSCRN_STS_USRSCRN_VW_FK_I

Close relationships  within of separation: