Table slot9.WORLD.TSTA.EJSXML_DOCS_PRE_XSLT
This table contains XML to/from an interface before an XSLT is applied.
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 Implied Constraint R
The unique sequence used to identify a XML Document, copied from EJSXML_DOCS
DOC_CATEGORY_CODE varchar2 3  √  null
XML_DOCUMENT_CATEGORY_CODES.DOC_CATEGORY_CODE Implied Constraint R
The code used to identify the type of XML document being processed.
DOC clob 4000  √  null The XML Document as originally generated.
CREATOR_ID varchar2 100  √  null Audting info, user ID that created record
CREATOR_DATE date 7  √  null Audting info, date/time record created
UPDATOR_ID varchar2 100  √  null Audting info, user ID that last updated record
UPDATOR_DATE date 7  √  null Audting info, date/time record last updated
REC_ID number 0  √  null Schema-wide record ID.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"XML_DOC_ID" IS NOT NULL EXDPX_XML_DOC_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
DOC_CATEGORY_CODE + CREATOR_DATE Performance Asc/Asc EXDPX_DOC_CAT_I
XML_DOC_ID Performance Asc EXDPX_XMLDOCID_I

Close relationships: