v_incident_report_people: Many-to-One (N:1)
Many EMS records link to one person
Referenced through incident_report_people_id
v_nfirs_ems_medication: One-to-Many (1:N)
One EMS record can have many medications
Referenced through nfirs_ems_id
v_nfirs_ems_treatment: One-to-Many (1:N)
One EMS record can have many treatments
Referenced through nfirs_ems_id
v_nfirs_ems_vital_sign: One-to-Many (1:N)
One EMS record can have many vital signs
Referenced through nfirs_ems_id
Column | Type | Description |
id | integer | Primary key |
client_code | varchar(28) | Organization ID |
incident_report_people_id | integer | Person reference |
patient_number | integer | Patient number |
arrived_date | date | Arrival date |
arrived_time | time | Arrival time |
transfer_date | date | Transfer date |
transfer_time | time | Transfer time |
provider_impression_assessment | varchar(3) | Assessment code |
date_of_birth | date | Birth date |
race | varchar(2) | Race code |
ethnicity | varchar(2) | Ethnicity code |
human_factors_contributing_injury | varchar(2)[] | Contributing factors |
is_patient_injured | boolean | Injury status |
body_site_injury | varchar(2)[] | Injury sites |
injury_type | varchar(3)[] | Injury types |
cause_of_illness_injury | varchar(3)[] | Cause codes |
safety_equipment | varchar(2)[] | Equipment codes |
is_cardiac_arrest | boolean | Cardiac status |
cardiac_arrest | varchar(2) | Arrest code |
patient_status | varchar(2) | Status code |
narrative | text | Incident narrative |
created_by | integer | Creator reference |
created_at | timestamp | Creation time |
updated_at | timestamp | Update time |