| Table slot9.WORLD.TSTA.XML_MULTIMATCH_CRITERIA This table is an administration table that is used for processing XML documents being loaded into the database
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "CRITERIA_NAME" IS NOT NULL | XMLMMC_CRITERIA_NAME_NN |
| "DOC_CATEGORY_CODE" IS NOT NULL | XMLMMC_DOCCD_NN |
| "MULTI_CRITERIA_NAME" IS NOT NULL | XMLMMC_MULTCRIT_NAME_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| DOC_CATEGORY_CODE + CRITERIA_NAME + MULTI_CRITERIA_NAME | Primary key | Asc/Asc/Asc | XMLMMC_PK |
| CRITERIA_NAME | Performance | Asc | XMLMMC_CRITERIA_NAME_I |
| MULTI_CRITERIA_NAME | Performance | Asc | XMLMMC_XMLAMC_FK_I |
| DOC_CATEGORY_CODE + CRITERIA_NAME | Performance | Asc/Asc | XMLMMC_XMLDOC_CATC_FK_I |
|