| Table slot9.WORLD.TSTA.ARREST_DISPATCHES This table stores an association between a dispatch record (referred to as Calls For Service in the application) and an ARREST as created in the application.
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "ARREST_ID" IS NOT NULL | ARRDISP_ARREST_ID_NN |
| "DISPATCH_ID" IS NOT NULL | ARRDISP_DISP_ID_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| ARREST_ID + DISPATCH_ID | Primary key | Asc/Asc | ARRDISP_PK |
| ARREST_ID | Performance | Asc | ARRDISP_ARR_FK_I |
| DISPATCH_ID | Performance | Asc | ARRDISP_DISPTCH_FK_I |
|