f_epcr: One-to-Many (1:N)
One incident can have multiple EPCRs
Referenced through incident_report_id
v_incident_report_apparatus: One-to-Many (1:N)
One incident can have multiple apparatus responses
Referenced through incident_report_id
v_incident_report_personnel: One-to-Many (1:N)
One incident can have multiple personnel responses
Referenced through incident_report_id
v_personnel: Many-to-One (N:1)
Many incidents can have one officer in charge
Referenced through officer_in_charge
Column | Type | Description |
id | integer | Primary key |
client_code | varchar | Organization identifier |
alarm_at | timestamp | Alarm time |
created_at | timestamp | Creation time |
first_arriving_unit | integer | First unit |
shift_name | varchar | Shift reference |
incident_reporting_status_code | varchar | Report status |
officer_in_charge | integer | Officer ID |
incident_type | varchar | Incident type |
nfb_incident_number | varchar | Incident number |
address | varchar | Incident location |
dispatch_type | varchar | Dispatch type |
exposure | integer | Exposure value |
completed_by | integer | Completing user |
incident_number | varchar | Reference number |
unit | varchar | Unit reference |
location_type | varchar | Location type |
officer_in_charge_name | varchar | Officer name |
aid_type | integer | Aid type |
property_loss | integer | Property loss value |
contents_loss | integer | Contents loss value |
actual_incident_type | varchar | Verified type |
fire_station_id | integer | Station reference |
station_num | varchar | Station number |