| Table slot9.WORLD.TSTA.MISC_ID_REST_CODES This table defines the valid restriction codes for a miscellaneous id
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "MISC_ID_CODE" IS NOT NULL | MIRC_MISC_ID_CODE_NN |
| "RESTRICTION_CODE" IS NOT NULL | MIRC_RESTRICTION_CODE_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| MISC_ID_CODE + RESTRICTION_CODE | Primary key | Asc/Asc | MIRC_PK |
| MISC_ID_CODE | Performance | Asc | MIRC_MISC_CD_FK_I |
|