Table slot9.WORLD.TSTA.REPORT_SCREENS
Administration table used for reporting
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
REPORT_SCREEN_ID number 0
REPORT_PARAMETER_J_SCREENS.REPORT_SCREEN_ID RPJS_RSCR_FK R
REPORT_SCREEN_REPORTS.REPORT_SCREEN_ID RSREP_RSCR_FK R
SCREEN_NAME varchar2 50
DISPLAY_NAME varchar2 100  √  null
DESCRIPTION varchar2 255  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null
SHOW_MENU_OPTION char 1  √  'Y'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
SHOW_MENU_OPTION IN ( 'Y','N') CK_RS_SMOPT
"REPORT_SCREEN_ID" IS NOT NULL RSCR_REP_SCREEN_ID_NN
"SCREEN_NAME" IS NOT NULL RSCR_SCREEN_NAME_NN

Indexes:
Column(s) Type Sort Constraint Name
REPORT_SCREEN_ID Primary key Asc RSCR_PK
SCREEN_NAME Must be unique Asc RSCR_UK

Close relationships  within of separation: