Table slot9.WORLD.TSTA.EJS_XML_MATCH_SCREENS
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_XML_MATCH_SCREEN_PARAMS.SEARCH_SCREEN EXMSP_EXMS_FK R
EJS_XML_TAG_CATEGORY_CODES.SEARCH_SCREEN EXCC_EXMS_FK R
XML_DOCUMENT_CATEGORY_CODES.POST_SCREEN DCC_EXMS_FK N
EJS_INDEX_NAME varchar2 80  √  null The index name used for a master index. (i.e. person id)
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"SEARCH_SCREEN" IS NOT NULL EXMS_SEARCH_SCREEN_NN

Indexes:
Column(s) Type Sort Constraint Name
SEARCH_SCREEN Primary key Asc EXMS_PK

Close relationships  within of separation: