f_epcr: Many-to-One (N:1)
Many vitals link to one EPCR
Referenced through epcr_id
v_personnel: Many-to-One (N:1)
Many vitals taken by one provider
Referenced through vital_provider
Column | Type | Description |
id | integer | Primary key |
epcr_id | integer | EPCR reference |
taken_at | timestamp | Assessment time |
pta_code | varchar(20) | PTA code |
cardiac_rhythm_codes | varchar(20)[] | Rhythm codes |
ecg_type_code | varchar(20) | ECG type |
systolic_blood_pressure | integer | Systolic BP |
diastolic_blood_pressure | varchar | Diastolic BP |
heart_rate | integer | Heart rate |
pulse_oximetry | integer | O2 saturation |
respiratory_rate | integer | Resp rate |
end_tidal_carbon_dioxide | double precision | ETCO2 |
blood_glucose_level | varchar(5) | Glucose level |
temperature | double precision | Temperature |
total_glasgow_coma_score | integer | GCS total |
vital_provider | integer | Provider ID |