v_nfirs_ems: Many-to-One (N:1)
Many vital signs link to one EMS record
Referenced through nfirs_ems_id
v_personnel: Many-to-One (N:1)
Many vital signs taken by one provider
Referenced through provider
Column | Type | Description |
id | integer | Primary key |
client_code | varchar(28) | Organization ID |
nfirs_ems_id | integer | EMS record reference |
provider | integer | Provider reference |
performed_date | date | Assessment date |
performed_time | time | Assessment time |
performed_code | varchar(10) | Performance code |
heart_rate | integer | Heart rate value |
heart_rate_code | varchar(10) | HR code |
systolic_blood_pressure | integer | Systolic BP |
systolic_blood_pressure_code | varchar(10) | BP code |
diastolic_blood_pressure | varchar(100) | Diastolic BP |
respiratory_rate | integer | Resp rate |
respiratory_effort_code | varchar(7) | Effort code |
pulse_oximetry | integer | SpO2 value |
blood_glucose_level | varchar(5) | Glucose level |
blood_glucose_level_code | varchar(10) | Glucose code |
created_at | timestamp | Creation time |
updated_at | timestamp | Update time |