Table slot9.WORLD.TSTA.EJS_XML_TAG_VALUES
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_VALUE_ID number 0
EJS_XML_VALUES_VW.XML_VALUE_ID Implied Constraint R
The primary key/unique identifier for a XML value
ROW_TAG_ID number 0
EJS_XML_TAG_NAMES.ROW_TAG_ID EXTV_EXTN_FK R
A unique number used to identify a row tag.
TAG_NAME varchar2 80
EJS_XML_TAG_NAMES.TAG_NAME EXTV_EXTN_FK R
The tag name being catured from an XML document.
XML_PARENT_ID number 0  √  null
EJS_XML_PARENT_TAG_VALUES.XML_PARENT_ID EXTV_EXPTV_FK R
The parent element for the child tags.
XML_VALUE varchar2 4000  √  null The value from the xml document.
TAG_LABEL varchar2 80  √  null The table to be used for hte xml value.
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null Domain to store an Oracle USER DATE
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null Domain to store an Oracle Creator date
XML_PARENT_ID_2 number 0  √  null
EJS_XML_PARENT_TAG_VALUES.XML_PARENT_ID EXTV_EXPTV_SECOND_CHILD_OF_FK R
The parent element for the child tags.
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 EXTV_ROW_TAG_ID_NN
"TAG_NAME" IS NOT NULL EXTV_TAG_NAME_NN
"XML_VALUE_ID" IS NOT NULL EXTV_XML_VALUE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
XML_VALUE_ID Primary key Asc EXTV_PK
XML_PARENT_ID Performance Asc EXTV_EXPTV_FK_I
XML_PARENT_ID_2 Performance Asc EXTV_EXPTV_SECOND_CHILD_OF_F_I
ROW_TAG_ID + TAG_NAME Performance Asc/Asc EXTV_EXTN_FK_I
ROW_TAG_ID Performance Asc EXTV_ROW_TAG_ID_I

Close relationships  within of separation: