Table slot9.WORLD.TSTA.EJS_XML_PARENT_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_PARENT_ID number 0
EJS_XML_TAG_VALUES.XML_PARENT_ID EXTV_EXPTV_FK R
EJS_XML_TAG_VALUES.XML_PARENT_ID_2 EXTV_EXPTV_SECOND_CHILD_OF_FK R
EJS_XML_VALUES_VW.XML_PARENT_ID Implied Constraint R
The parent element for the child tags.
STATUS_CODE varchar2 30
EJS_CODES.CODE EXPTV_STATUS_CODE_EJS_CODE_FK R
TAG_CATEGORY_CODE varchar2 3
EJS_XML_TAG_CATEGORY_CODES.TAG_CATEGORY_CODE EXPTV_EXCC_FK R
XML_DOC_ID number 0
EJSXML_DOCS.XML_DOC_ID EXPTV_ED_FK R
A unique sequence used to identify a XML Document.
EJS_INDEX_ID number 0  √  null The value of the index id to be used during the creation of a report or other record.
PARENT_KEY_VALUE varchar2 240  √  null The value of the parent key row and tag key.
PARENT_TAG_NAME_KEY varchar2 240  √  null
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
STATUS_CODE_TYPE varchar2 30  √  'EJS_XML_STATUS_CODES'
EJS_CODES.CODE_TYPE EXPTV_STATUS_CODE_EJS_CODE_FK R
REC_ID number 0  √  null
ROW_TAG_ID number 0  √  null
EJS_XML_ROW_TAGS.ROW_TAG_ID Implied Constraint R
The row_tag_id from ejs_xml_row_tags that corresponds to this row tag
PARENT_XML_PARENT_ID number 0  √  null The xml_parent_id value of the parent row tag for this row tag

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"STATUS_CODE" IS NOT NULL EXPTV_STATUS_CODE_NN
"TAG_CATEGORY_CODE" IS NOT NULL EXPTV_TAG_CATEGORY_CODE_NN
"XML_DOC_ID" IS NOT NULL EXPTV_XML_DOC_ID_NN
"XML_PARENT_ID" IS NOT NULL EXPTV_XML_PARENT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
XML_PARENT_ID Primary key Asc EXPTV_PK
XML_DOC_ID Performance Asc EXPTV_ED_FK_I
TAG_CATEGORY_CODE Performance Asc EXPTV_EXCC_FK_I
STATUS_CODE Performance Asc EXPTV_EXSC_FK_I
PARENT_XML_PARENT_ID Performance Asc EXPTV_PARENT_ID_I
ROW_TAG_ID Performance Asc EXPTV_ROW_TAG_ID_I
STATUS_CODE_TYPE + STATUS_CODE Performance Asc/Asc EXPTV_STATUS_CODE_EJS_CODE_I

Close relationships  within of separation: