| Table slot9.WORLD.TSTA.ARREST_PERSON_ROLES This table stores roles assigned to the a person added to an ARREST in the application
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "ARREST_PERSON_ID" IS NOT NULL | ARRPR_PERSON_ID_NN |
| "ROLE_CODE" IS NOT NULL | ARRPR_ROLE_CODE_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| ARREST_PERSON_ID + ROLE_CODE | Primary key | Asc/Asc | ARRRPR_PK |
| ARREST_PERSON_ID | Performance | Asc | ARRPR_ARRP_FK_I |
| ROLE_CODE | Performance | Asc | ARRPR_ROLE_FK_I |
|