| Table slot9.WORLD.TSTA.EJS_XREFS 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 |
|---|---|
| "EXTERNAL_CODE" IS NOT NULL | EJSX_EXTERNAL_CODE_NN |
| "INTERNAL_CODE" IS NOT NULL | EJSX_INTERNAL_CODE_NN |
| "XREF_TYPE_CODE" IS NOT NULL | EJSX_XREF_TYPE_CODE_NN |
| "XREF_TYPE_CODE_TYPE" IS NOT NULL | EJSX_XREF_TYPE_CODE_TYPE_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| XREF_TYPE_CODE + XREF_TYPE_CODE_TYPE + INTERNAL_CODE + EXTERNAL_CODE | Primary key | Asc/Asc/Asc/Asc | EJSX_PK |
| XREF_TYPE_CODE_TYPE + XREF_TYPE_CODE | Performance | Asc/Asc | EJSX_EJS_CODE_FK_I |
| XREF_TYPE_CODE + EXTERNAL_CODE + INTERNAL_CODE | Performance | Asc/Asc/Asc | EJSX_TYPE_EXT_CODE_I |
|