Table slot9.WORLD.TSTA.XML_DOCUMENT_OPTIONS
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_OPTION_SEQ number 0 Primary key generated from sequence XMLDOP_SEQ
DOC_CATEGORY_CODE varchar2 30
XML_DOCUMENT_CATEGORY_CODES.DOC_CATEGORY_CODE XMLDOP_XML_DCC_FK R
XML document category code that option applies to.
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE XMLDOP_AGNCY_CD_FK R
Optional agency to which option applies. Null means all agencies.
OPTION_CODE varchar2 30
EJS_CODES.CODE XMLDOP_OPTION_EJS_CODE_FK R
Option name, stored as code in EJS_CODES.
OPTION_CODE_TYPE varchar2 30 'XML_DOC_OPTION_CODES'
EJS_CODES.CODE_TYPE XMLDOP_OPTION_EJS_CODE_FK R
Code type in EJS_CODES, default is XML_DOC_OPTION_CODES
OPTION_VALUE varchar2 1000  √  null Value for the option
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
DESCRIPTION varchar2 1000  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DOC_CATEGORY_CODE" IS NOT NULL XMLDOP_DOC_CAT_NN
"DOC_OPTION_SEQ" IS NOT NULL XMLDOP_DOC_OPTION_SEQ_NN
"OPTION_CODE" IS NOT NULL XMLDOP_OPT_CODE_NN
"OPTION_CODE_TYPE" IS NOT NULL XMLDOP_OPT_CODE_TYPE_NN

Indexes:
Column(s) Type Sort Constraint Name
DOC_OPTION_SEQ Primary key Asc XMLDOP_PK
AGENCY_CODE Performance Asc XMLDOP_AGNCY_CD_FK_I
OPTION_CODE_TYPE + OPTION_CODE Performance Asc/Asc XMLDOP_OPTION_EJS_CODE_FK_I
DOC_CATEGORY_CODE + OPTION_CODE + AGENCY_CODE Must be unique Asc/Asc/Asc XMLDOP_UK
DOC_CATEGORY_CODE Performance Asc XMLDOP_XML_DCC_FK_I

Close relationships  within of separation: