v_incident_report: Many-to-One (N:1)
Many casualties link to one incident
Referenced through incident_report_id
v_nfirs_firefighter_casualty_equipment: One-to-Many (1:N)
One casualty can have many equipment records
Referenced through nfirs_firefighter_casualty_id
v_personnel: Many-to-One (N:1)
Many casualties recorded by one personnel
Referenced through created_by
Column | Type | Description |
id | integer | Primary key |
client_code | varchar(28) | Organization ID |
incident_report_id | integer | Incident reference |
casualty_id | integer | Casualty reference |
first_name | varchar(100) | First name |
last_name | varchar(100) | Last name |
injury_date_time | timestamp | Injury time |
activity_at_time_of_injury | varchar(3) | Activity code |
where_injury_occurred | varchar(2) | Location code |
firefighter_casualty_severity | varchar(2) | Severity code |
note | text | Additional notes |
taken_to | varchar(2) | Treatment location |
physical_condition_just_prior_to_injury | varchar(2) | Prior condition |
number_of_responses_during_past_24_hours | integer | Recent responses |
object_involved_in_injury | varchar(3) | Object code |
specific_location_where_injury_occurred | varchar(3) | Specific location |
factor_contributing_to_injury | varchar(3) | Contributing factor |
primary_area_of_body_injured | varchar(3) | Primary injury site |
created_by | integer | Creator reference |
created_at | timestamp | Creation time |
updated_at | timestamp | Update time |