| Table slot9.WORLD.TSTA.NOTIFICATION_TYPES This table defines the types of notifications that can be sent from the application
|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "NOTIFY_TYPE_CD" IS NOT NULL | NOTYP_NOTIFY_TYPE_CD_NN |
| "TYPE_CODE" IS NOT NULL | NOTYP_TYPE_CODE_NN |
| "TYPE_CODE_TYPE" IS NOT NULL | NOTYP_TYPE_CODE_TYPE_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| NOTIFY_TYPE_CD + TYPE_CODE_TYPE + TYPE_CODE | Primary key | Asc/Asc/Asc | NOTYP_PK |
| TYPE_CODE_TYPE + TYPE_CODE | Performance | Asc/Asc | NOTYP_EJS_CODES_TYPE_FK_I |
| NOTIFY_TYPE_CD | Performance | Asc | NOTYP_NDM_FK_I |
|