| Table slot9.WORLD.TSTA.INCIDENT_PERSON_ROLES This table stores the roles for a MASTER PERSON added to an INCIDENT in the application
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "INC_PER_ID" IS NOT NULL | IPR_INC_PER_ID_NN |
| "ROLE_TYPE" IS NOT NULL | IPR_ROLE_CD_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| INC_PER_ID + ROLE_TYPE | Primary key | Asc/Asc | INC_PER_ROLES_PK |
| INC_PER_ID | Performance | Asc | IPR_INC_PER_ID_FK_I |
| ROLE_TYPE | Performance | Asc | IPR_RT_FK_I |
|