Table slot9.WORLD.TSTA.EJS_XML_DOC_KEY_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
KEY_NAME varchar2 20
EJS_XML_DOC_KEYS.KEY_NAME EXDK_EXDKC_FK R
The name of the XML document key.
KEY_DESCRIPTION varchar2 80  √  null The description of the XML document key.
SEARCHABLE varchar2 1  √  null A flag used to indicate if a query can be performed using the key.
DOC_CATEGORY_CODE varchar2 3  √  null
XML_DOCUMENT_CATEGORY_CODES.DOC_CATEGORY_CODE EXDKC_DCC_FK R
The XML Document Category associated with the key.
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"KEY_NAME" IS NOT NULL EXDKC_KEY_NAME_NN

Indexes:
Column(s) Type Sort Constraint Name
KEY_NAME Primary key Asc EXDKC_PK
DOC_CATEGORY_CODE Performance Asc EXDKC_DCC_FK_I

Close relationships  within of separation: