Table slot9.WORLD.TSTA.XML_DOCUMENT_CATEGORY_CODES
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_CATEGORY_CODE varchar2 3
EJS_XML_DEFAULT_VALUES.DOC_CATEGORY_CODE EXDV_DCC_FK R
EJS_XML_DEST_COLUMN_VW.DOC_CATEGORY_CODE Implied Constraint R
EJS_XML_DOC_ERROR_VW.DOC_CATEGORY_CODE Implied Constraint R
EJS_XML_DOC_KEY_CODES.DOC_CATEGORY_CODE EXDKC_DCC_FK R
EJS_XML_DOC_KEYS_VW.DOC_CATEGORY_CODE Implied Constraint R
EJS_XML_DOC_QUEUE.DOC_CATEGORY_CODE EJS_XML_DOC_QUEUE_FK R
EJS_XML_ROW_TAGS.DOC_CATEGORY_CODE EXRTP_DCC_FK R
EJS_XML_VALUES_VW.DOC_CATEGORY_CODE Implied Constraint R
EJSXML_DOCS.DOC_CATEGORY_CODE EJSDOCS_XML_DCC_FK R
EJSXML_DOCS_PRE_XSLT.DOC_CATEGORY_CODE Implied Constraint R
EJSXML_DOCS_VW.DOC_CATEGORY_CODE Implied Constraint R
EXT_SEARCH_AGENCIES.DOC_CATEGORY_CODE EXTSA_DCC_FK R
EXTERNAL_SYSTEM_CODES.EXSYS_DOC_CATEGORY_CODE DCC_EXSYS_FK R
HYBRID_TRANSFERS.DOC_CATEGORY_CODE Implied Constraint R
INTERFACE_XML_DOCS.DOC_CATEGORY_CODE IDOC_XML_DCC_FK C
XML_DOC_APP_TABLES.DOC_CATEGORY_CODE XDAT_DCC_FK R
XML_DOC_CAT_CRITERIA.DOC_CATEGORY_CODE XMLDOC_CATC_XML_DCC_FK C
XML_DOC_DESTINATIONS.DOC_CATEGORY_CODE XMLDD_DCC_FK R
XML_DOCUMENT_OPTIONS.DOC_CATEGORY_CODE XMLDOP_XML_DCC_FK R
The code used to identify each type of XML document being processed.
DESCRIPTION varchar2 80  √  null
AUTO_UPLOAD varchar2 1  √  'N' Yes or No Fields
VIRTUAL_DIRECTORY varchar2 80  √  null The name of the virtual directory for the document processing.
STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE XML_DCC_STATUS_COD_EJS_CODE_FK R
UPLOAD_PROCEDURE varchar2 80  √  null Procedure to call to perform upload
POST_UPLOAD_PROCEDURE varchar2 80  √  null Procedure to call after upload
TEMPLATE_NAME varchar2 255  √  null
MSG_TYPE_CODE varchar2 30 'IN'
EJS_CODES.CODE XML_DCC_MSG_TYPE_C_EJS_CODE_FK R
XSLT_NAME varchar2 255  √  null
POST_SCREEN varchar2 16  √  null
EJS_XML_MATCH_SCREENS.SEARCH_SCREEN DCC_EXMS_FK N
EJS Screen to call after upload via report button.
PHYSICAL_DIRECTORY varchar2 255  √  null
FTP_ID number 0  √  null
EJS_FTP.FTP_ID DCC_EJS_FTP_FK R
POST_PARSE_PROCEDURE varchar2 80  √  null Procedure to call after document parsing.
MSG_TYPE_CODE_TYPE varchar2 30  √  'XML_DOC_MSG_TYPE_CODES'
EJS_CODES.CODE_TYPE XML_DCC_MSG_TYPE_C_EJS_CODE_FK R
STATUS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE XML_DCC_STATUS_COD_EJS_CODE_FK R
REC_ID number 0  √  null
FILE_ROOT_TAG varchar2 100  √  null Root tag of an XML file containing one or more documents.
DOCUMENT_START_TAG varchar2 100  √  null XML tag that starts each document in a file that contains multiple documents

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
AUTO_UPLOAD IN ('N', 'Y') CK_XML_DCC_AUTO_UPLOAD
"DOC_CATEGORY_CODE" IS NOT NULL XML_DCC_DOC_CATEGORY_CODE_NN
"MSG_TYPE_CODE" IS NOT NULL XML_DCC_MSG_TYPE_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
DOC_CATEGORY_CODE Primary key Asc XML_DCC_PK
FTP_ID Performance Asc DCC_EJS_FTP_FK_I
POST_SCREEN Performance Asc DCC_EXMS_FK_I
STATUS_CODE Performance Asc DCC_EXSC_FK_I
MSG_TYPE_CODE_TYPE + MSG_TYPE_CODE Performance Asc/Asc XML_DCC_MSG_TYPE_C_EJS_CODE_I
STATUS_CODE_TYPE + STATUS_CODE Performance Asc/Asc XML_DCC_STATUS_COD_EJS_CODE_I

Close relationships  within of separation: