Table slot9.WORLD.TSTA.EJS_XML_DOC_KEYS
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
XML_DOC_ID number 0
EJSXML_DOCS.XML_DOC_ID EXDK_ED_FK R
A unique sequence used to identify a XML Document.
KEY_NAME varchar2 80
EJS_XML_DOC_KEY_CODES.KEY_NAME EXDK_EXDKC_FK R
KEY_VALUE varchar2 80
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"KEY_NAME" IS NOT NULL EXDK_KEY_NAME_NN
"KEY_VALUE" IS NOT NULL EXDK_KEY_VALUE_NN
"XML_DOC_ID" IS NOT NULL EXDK_XML_DOC_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
XML_DOC_ID + KEY_NAME + KEY_VALUE Primary key Asc/Asc/Asc EXDK_PK
XML_DOC_ID Performance Asc EXDK_ED_FK_I
KEY_NAME Performance Asc EXDK_EXDKC_FK_I

Close relationships  within of separation: