| dispatch_id |
bigint(20)
|
|
|
|
| incident_id |
bigint(20)
|
|
|
Browse foreign values
|
| dispatched_by |
bigint(20)
|
|
|
|
| tanod_id |
bigint(20)
|
|
|
|
| priority |
enum('normal', 'high', 'critical')
|
utf8mb4_unicode_ci
|
|
|
| route_json |
longtext
|
utf8mb4_bin
|
|
|
| route_status |
enum('available', 'unavailable', 'stale')
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('assigned', 'en_route', 'arrived', 'completed', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| dispatched_at |
datetime
|
|
|
|
| en_route_at |
datetime
|
|
|
|
| arrived_at |
datetime
|
|
|
|
| completed_at |
datetime
|
|
|
|
| cancelled_at |
datetime
|
|
|
|
| cancelled_by |
bigint(20)
|
|
|
|
| created_client_request_id |
char(36)
|
utf8mb4_unicode_ci
|
|
|