| Table slot9.WORLD.TSTA.NOTIFICATION_DTL_ROLES This table defines the roles that are able to access a sent notification
|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| BUSY_FLAG IN ('Y','N') | CK_NTDTLRL_BUSY_FLAG |
| "BUSY_FLAG" IS NOT NULL | NTDTLRL_BF_NN |
| "NOTIFY_DTL_NUMBER" IS NOT NULL | NTDTLRL_DTL_NM_NN |
| "ROLE_NAME" IS NOT NULL | NTDTLRL_RL_NM_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| NOTIFY_DTL_NUMBER + ROLE_NAME | Primary key | Asc/Asc | NTDTLRL_PK |
| NOTIFY_DTL_NUMBER | Performance | Asc | NTDTLRL_NDTL_FK_I |
| ROLE_NAME | Performance | Asc | NTDTLRL_RS_FK_I |
|