| Table slot9.WORLD.TSTA.INC_CASE_ACTIVITY_NOTIFIES This table stores who a notification was sent to for an activity note added to a case in the application
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "ICAN_ID" IS NOT NULL | ICAN_ICAN_ID_NN |
| "INC_CASE_ACT_ID" IS NOT NULL | ICAN_INC_CASE_ACT_ID_NN |
| "LOGIN_ID" IS NOT NULL | ICAN_LOGIN_ID_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| ICAN_ID | Primary key | Asc | ICAN_PK |
| INC_CASE_ACT_ID | Performance | Asc | ICAN_INCCASACT_FK_I |
| LOGIN_ID | Performance | Asc | ICAN_IUP_FK_I |
| Performance | ICAN_UPPERTRIM_FNCBAS_I |
|