Table slot9.WORLD.TSTA.EJSXML_DOCS
This table stores all XML documents leaving and coming into the RMS database from an interface using our table driven XML processing. (CAD, Citation, Arrest, Master indexes, etc)
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
EJS_XML_DOC_ATTACHMENTS.XML_DOC_ID EXDA_ED_FK R
EJS_XML_DOC_ERROR_VW.XML_DOC_ID Implied Constraint R
EJS_XML_DOC_ERRORS.XML_DOC_ID EXDE_ED_FK R
EJS_XML_DOC_KEYS.XML_DOC_ID EXDK_ED_FK R
EJS_XML_DOC_KEYS_VW.XML_DOC_ID Implied Constraint R
EJS_XML_DOC_NARRATIVES.XML_DOC_ID EXDN_ED_FK R
EJS_XML_PARENT_TAG_VALUES.XML_DOC_ID EXPTV_ED_FK R
EJS_XML_TRACE_LOG.XML_DOC_ID EXTL_EJSDOCS_FK C
EJS_XML_VALUES_VW.XML_DOC_ID Implied Constraint R
EJSXML_DOCS_PRE_XSLT.XML_DOC_ID Implied Constraint R
EJSXML_DOCS_VW.XML_DOC_ID Implied Constraint R
A unique sequence used to identify a XML Document.
STATUS_CODE varchar2 30
EJS_CODES.CODE EJSDOCS_STATUS_COD_EJS_CODE_FK R
DOCNAME varchar2 80 The name of the file or document.
DOC_CATEGORY_CODE varchar2 3  √  null
XML_DOCUMENT_CATEGORY_CODES.DOC_CATEGORY_CODE EJSDOCS_XML_DCC_FK R
The code used to identify each type of XML document being processed.
DOC clob 4000  √  null The XML Document
REMARKS varchar2 255  √  null
CREATOR_DATE date 7  √  null
CREATOR_ID varchar2 100  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
STATUS_DATE date 7  √  null The date the current status was created.
BUSY_FLAG varchar2 1  √  'N' A flag that monitors if a record is being viwed by someone else.
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE EJSDOCS_AGNCY_CD_FK R
DELIVERY_ATTEMPTS number 0  √  null The number of times and XML search request should be sent.
STATUS_CODE_TYPE varchar2 30  √  'EJS_XML_STATUS_CODES'
EJS_CODES.CODE_TYPE EJSDOCS_STATUS_COD_EJS_CODE_FK R
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DOCNAME" IS NOT NULL EJSDOCS_DOCNAME_NN
"STATUS_CODE" IS NOT NULL EJSDOCS_STATUS_CODE_NN
"XML_DOC_ID" IS NOT NULL EJSDOCS_XML_DOC_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
XML_DOC_ID Primary key Asc EJSDOCS_PK
AGENCY_CODE Performance Asc EJSDOCS_AGNCY_CD_FK_I
STATUS_CODE Performance Asc EJSDOCS_EXSC_FK_I
STATUS_CODE_TYPE + STATUS_CODE Performance Asc/Asc EJSDOCS_STATUS_COD_EJS_CODE_I
UPDATOR_DATE + DOC_CATEGORY_CODE Performance Asc/Asc EJSDOCS_UPDATOR_DOC_CAT_I
DOC_CATEGORY_CODE Performance Asc EJSDOCS_XML_DCC_FK_I

Close relationships  within of separation: