| Table slot9.WORLD.TSTA.INC_CASE_WORKGROUPS This table stores the workgroup information added to a case in the application
|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "ICW_ID" IS NOT NULL | ICW_ICW_ID_NN |
| "INC_CASE_ID" IS NOT NULL | ICW_INC_CASE_ID_NN |
| "WORKGROUP_CODE" IS NOT NULL | ICW_WORKGROUP_CODE_NN |
| "WORKGROUP_CODE_TYPE" IS NOT NULL | ICW_WORKGROUP_CODE_TYPE_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| ICW_ID | Primary key | Asc | ICW_PK |
| WORKGROUP_CODE_TYPE + WORKGROUP_CODE | Performance | Asc/Asc | ICW_EJS_CODES_FK_I |
| INC_CASE_ID | Performance | Asc | ICW_IC_FK_I |
|