Table slot9.WORLD.TSTA.EJS_TAG_SCREEN_PARAMS
Legacy table. This table is not currently used
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
PARAMETER_NAME varchar2 80
EJS_XML_MATCH_SCREEN_PARAMS.PARAMETER_NAME ETSP_EXMSP_FK R
This is the name of the parameter defined on the master index search screen.
ROW_TAG_ID number 0
EJS_XML_TAG_NAMES.ROW_TAG_ID ETSP_EXTN_FK R
A unique number used to identify a row tag.
SEARCH_SCREEN varchar2 16
EJS_XML_MATCH_SCREEN_PARAMS.SEARCH_SCREEN ETSP_EXMSP_FK R
TAG_NAME varchar2 80
EJS_XML_TAG_NAMES.TAG_NAME ETSP_EXTN_FK R
The tag name being catured from an XML document.
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"PARAMETER_NAME" IS NOT NULL ETSP_PARAMETER_NAME_NN
"ROW_TAG_ID" IS NOT NULL ETSP_ROW_TAG_ID_NN
"SEARCH_SCREEN" IS NOT NULL ETSP_SEARCH_SCREEN_NN
"TAG_NAME" IS NOT NULL ETSP_TAG_NAME_NN

Indexes:
Column(s) Type Sort Constraint Name
TAG_NAME + ROW_TAG_ID + PARAMETER_NAME + SEARCH_SCREEN Primary key Asc/Asc/Asc/Asc ETSP_PK
SEARCH_SCREEN + PARAMETER_NAME Performance Asc/Asc ETSP_EXMSP_FK_I
ROW_TAG_ID + TAG_NAME Performance Asc/Asc ETSP_EXTN_FK_I
ROW_TAG_ID Performance Asc ETSP_ROW_TAG_ID_I

Close relationships  within of separation: