Table slot9.WORLD.TSTA.XML_AUTOMATCH_CRITERIA
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
CRITERIA_NAME varchar2 255
XML_AUTOMATCH_FIELDS.CRITERIA_NAME XMLAMF_XMLAMC_FK C
XML_DOC_CAT_CRITERIA.CRITERIA_NAME XMLDOC_CATC_XMLAMC_FK R
XML_MULTIMATCH_CRITERIA.MULTI_CRITERIA_NAME XMLMMC_XMLAMC_FK R
INDEX_CODE varchar2 255
MATCH_QUERY clob 4000  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CRITERIA_NAME" IS NOT NULL XMLAMC_CRITERIA_NAME_NN
"INDEX_CODE" IS NOT NULL XMLAMC_INDEX_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
CRITERIA_NAME Primary key Asc XMLAMC_PK

Close relationships  within of separation: