Table slot9.WORLD.TSTA.EJS_XML_MATCH_SCREEN_PARAMS
This table is an administration table that is used for processing XML documents being loaded into the database
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
SEARCH_SCREEN varchar2 16
EJS_TAG_SCREEN_PARAMS.SEARCH_SCREEN ETSP_EXMSP_FK R
EJS_XML_MATCH_SCREENS.SEARCH_SCREEN EXMSP_EXMS_FK R
PARAMETER_NAME varchar2 80
EJS_TAG_SCREEN_PARAMS.PARAMETER_NAME ETSP_EXMSP_FK R
This is the name of the parameter defined on the master index search screen.
PARAMETER_REQUIRED varchar2 1  √  'N' This enables screens that are dynamically using these values to know if they are required or not.
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
PARAMETER_REQUIRED IN ('Y', 'N') CK_EXMSP_PARAMETER_REQUIRED
"PARAMETER_NAME" IS NOT NULL EXMSP_PARAMETER_NAME_NN
"SEARCH_SCREEN" IS NOT NULL EXMSP_SEARCH_SCREEN_NN

Indexes:
Column(s) Type Sort Constraint Name
SEARCH_SCREEN + PARAMETER_NAME Primary key Asc/Asc EXMSP_PK
SEARCH_SCREEN Performance Asc EXMSP_EXMS_FK_I

Close relationships  within of separation: