v_incident_report: Many-to-One (N:1)
Many apparatus responses link to one incident
Referenced through incident_report_id
v_apparatus: Many-to-One (N:1)
Many responses link to one apparatus
Referenced through apparatus_id
v_incident_report_personnel: One-to-Many (1:N)
One apparatus response can have many personnel
Referenced through incident_report_apparatus_id
Column | Type | Description |
id | integer | Primary key |
client_code | varchar(28) | Organization ID |
incident_report_id | integer | Incident reference |
apparatus_id | integer | Apparatus reference |
name | varchar(100) | Apparatus name |
aid | boolean | Mutual aid flag |
type_of_apparatus_or_resource | varchar(3) | Resource type |
number_of_people | integer | Personnel count |
location_flag | boolean | Location marker |
dispatch_time | time | Dispatch time |
arrive_time | time | Arrival time |
clear_time | time | Clear time |
back_in_service_time | time | Service return time |
dispatch_to_enroute | interval | Response interval |
enroute_to_scene | interval | Travel interval |
scene_to_clear | interval | Scene interval |
created_by | integer | Creator reference |
created_at | timestamp | Creation time |
department_name | varchar(100) | Department name |
is_canceled | boolean | Cancellation flag |
is_first_arriving_unit | boolean | First arrival flag |