Table slot9.WORLD.TSTA.EJS_XML_ROW_TAG_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
ROW_TAG_ID number 0
EJS_XML_ROW_TAGS.ROW_TAG_ID EXTNK_EXRTP_FK R
A unique number used to identify a row tag.
ROW_TAG_KEY varchar2 80 The name of the parent row tag key. (i.e. person id)
TAG_NAME_KEY varchar2 80 The name of the tag for the parent record
NUMBER_PARENT number 38  √  null The number of parent tags that need to be climbed in the XML tree.
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ROW_TAG_ID" IS NOT NULL EXTNK_ROW_TAG_ID_NN
"ROW_TAG_KEY" IS NOT NULL EXTNK_ROW_TAG_KEY_NN
"TAG_NAME_KEY" IS NOT NULL EXTNK_TAG_NAME_KEY_NN

Indexes:
Column(s) Type Sort Constraint Name
ROW_TAG_ID + ROW_TAG_KEY + TAG_NAME_KEY Primary key Asc/Asc/Asc EXTNK_PK
ROW_TAG_ID Performance Asc EXTNK_EXRTP_FK_I

Close relationships  within of separation: