| espv_id | int(11) | NO | | PRI | auto_increment | |
| espv_cus_id | int(11) | NO | | MUL | | |
| espv_cli_id | int(11) | NO | | MUL | | |
| espv_enc_id | int(11) | NO | | MUL | | |
| espv_pat_id | int(11) | NO | | MUL | | |
| espv_usr_cur_id | int(11) | NO | | | | |
| espv_height | varchar(20) | NO | | | | Vitals height in inches |
| espv_weight_preferred_unit_id | int(11) | NO | 3 | MUL | | indicates the user selecter preferred unit type for the weight measurement |
| espv_height_preferred_unit_id | int(11) | NO | 1 | MUL | | indicates the user selecter preferred unit type for the height measurement |
| espv_weight | varchar(20) | NO | | | | Vitals weight in ounces |
| espv_bmi | varchar(8) | NO | | | | |
| espv_bmi_percentile | decimal(5,4) | YES | | | | BMI percentile saved as ratio. Null if not recorded. |
| espv_blood_pressure_mm | varchar(8) | NO | | | | |
| espv_blood_pressure_hg | varchar(8) | NO | | | | |
| espv_temp | varchar(8) | NO | | | | Body temp. in fahrenheit |
| espv_temp_preferred_unit_id | int(11) | NO | 7 | | | Preferred unit id. defaults to 7 (fahrenheit) |
| espv_pulse | varchar(8) | NO | | | | |
| espv_pulse_oximetry | varchar(8) | NO | | | | |
| espv_head_circum | varchar(8) | NO | | | | |
| espv_resp_rate | varchar(8) | NO | | | | |
| espv_oxy_inhaled | decimal(4,3) | YES | | | | Inhaled Oxygen Concentration |
| espv_oxy_inhaled_flow_rate | varchar(8) | NO | | | | Inhaled oxygen flow rate expressed as L/min |
| espv_position | varchar(45) | NO | | | | |
| espv_location | varchar(45) | NO | | | | |
| espv_notes | text | YES | | | | |
| espv_completed_ts | varchar(12) | NO | | | | 12 digit date vitals were taken |
| espv_completed_dt | datetime | YES | | MUL | | datetime vitals were taken |
| espv_disabled | char(1) | NO | | | | |
| espv_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| espv_created | timestamp | YES | CURRENT_TIMESTAMP | | | |