Table slot9.WORLD.TSTA.EJS_XML_DOC_ERRORS
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
DOC_ERR_ID number 15
EJS_XML_DOC_ERROR_VW.DOC_ERR_ID Implied Constraint R
Domain to store an Oracle USER ID
XML_DOC_ID number 0
EJSXML_DOCS.XML_DOC_ID EXDE_ED_FK R
A unique sequence used to identify a XML Document.
ERROR_ID number 0
ERROR_CODES.ERROR_ID EXDE_EC_FK R
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null Domain to store an Oracle USER DATE
DTL_ERROR_MSG varchar2 255  √  null
SQL_ERROR_MSG varchar2 255  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DOC_ERR_ID" IS NOT NULL EXDE_DOC_ERR_ID_NN
"ERROR_ID" IS NOT NULL EXDE_ERROR_ID_NN
"XML_DOC_ID" IS NOT NULL EXDE_XML_DOC_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
DOC_ERR_ID Primary key Asc EXDE_PK
ERROR_ID Performance Asc EXDE_EC_FK_I
XML_DOC_ID Performance Asc EXDE_ED_FK_I

Close relationships  within of separation: