| Table slot9.WORLD.TSTA.USI_CASE_ACTIVITY_FIELDS This table maps an instance of a case activity to the instance of the associated custom fields
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "INC_CASE_ACT_ID" IS NOT NULL | USICASACTFLD_ACTIVITY_ID_NN |
| "INSTANCE_ID" IS NOT NULL | USICASACTFLD_INSTANCE_ID_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| INSTANCE_ID + INC_CASE_ACT_ID | Primary key | Asc/Asc | USICASACTFLD_PK |
| INC_CASE_ACT_ID | Performance | Asc | USICASACTFLD_INCCASACT_I |
| INSTANCE_ID | Performance | Asc | USICASACTFLD_USRSCRN_INST_FK_I |
|