ecg_result

Measurement of the electrical activity generated by the heart.

Measurement of the electrical activity generated by the heart.

Purpose. To record the measurements of electrical activity generated by the heart over a short period of time and its associated clinical interpretation.

Source

Columns

Constraints

check ((ecg_type_code is null and ecg_type_system is null and ecg_type_valueset_id is null) or (ecg_type is not null and ecg_type_code is not null and ecg_type_system is not null and ecg_type_valueset_id is not null))
check ((atrial_heart_rate_magnitude is null and atrial_heart_rate_units is null) or (atrial_heart_rate_magnitude is not null and atrial_heart_rate_units is not null))
check (atrial_heart_rate_magnitude is null or (atrial_heart_rate_units = '/min' and atrial_heart_rate_magnitude >= 0))
check ((ventricular_heart_rate_magnitude is null and ventricular_heart_rate_units is null) or (ventricular_heart_rate_magnitude is not null and ventricular_heart_rate_units is not null))
check (ventricular_heart_rate_magnitude is null or (ventricular_heart_rate_units = '/min' and ventricular_heart_rate_magnitude >= 0))
check ((qt_interval_global_magnitude is null and qt_interval_global_units is null) or (qt_interval_global_magnitude is not null and qt_interval_global_units is not null))
check (qt_interval_global_magnitude is null or (qt_interval_global_units = 'ms' and qt_interval_global_magnitude >= 0))
check ((qtc_interval_global_magnitude is null and qtc_interval_global_units is null) or (qtc_interval_global_magnitude is not null and qtc_interval_global_units is not null))
check (qtc_interval_global_magnitude is null or (qtc_interval_global_units = 'ms' and qtc_interval_global_magnitude >= 0))
check ((pr_interval_global_magnitude is null and pr_interval_global_units is null) or (pr_interval_global_magnitude is not null and pr_interval_global_units is not null))
check (pr_interval_global_magnitude is null or (pr_interval_global_units = 'ms' and pr_interval_global_magnitude >= 0))
check ((qrs_duration_global_magnitude is null and qrs_duration_global_units is null) or (qrs_duration_global_magnitude is not null and qrs_duration_global_units is not null))
check (qrs_duration_global_magnitude is null or (qrs_duration_global_units = 'ms' and qrs_duration_global_magnitude >= 0))
check ((rr_interval_global_magnitude is null and rr_interval_global_units is null) or (rr_interval_global_magnitude is not null and rr_interval_global_units is not null))
check ((device_interpretation_code is null and device_interpretation_system is null and device_interpretation_valueset_id is null) or (device_interpretation is not null and device_interpretation_code is not null and device_interpretation_system is not null and device_interpretation_valueset_id is not null))
check ((finding_code is null and finding_system is null and finding_valueset_id is null) or (finding is not null and finding_code is not null and finding_system is not null and finding_valueset_id is not null))
check ((ecg_diagnosis_code is null and ecg_diagnosis_system is null and ecg_diagnosis_valueset_id is null) or (ecg_diagnosis is not null and ecg_diagnosis_code is not null and ecg_diagnosis_system is not null and ecg_diagnosis_valueset_id is not null))
check ((p_axis_magnitude is null and p_axis_units is null) or (p_axis_magnitude is not null and p_axis_units is not null))
check ((qrs_axis_magnitude is null and qrs_axis_units is null) or (qrs_axis_magnitude is not null and qrs_axis_units is not null))
check ((t_axis_magnitude is null and t_axis_units is null) or (t_axis_magnitude is not null and t_axis_units is not null))
check ((pacemaker_stimulation_code is null and pacemaker_stimulation_system is null and pacemaker_stimulation_valueset_id is null) or (pacemaker_stimulation is not null and pacemaker_stimulation_code is not null and pacemaker_stimulation_system is not null and pacemaker_stimulation_valueset_id is not null))
check ((position_code is null and position_system is null and position_valueset_id is null and position is null) or (position is not null and position_code is not null and position_system is not null and position_valueset_id is not null))
check ((tilt_magnitude is null and tilt_units is null) or (tilt_magnitude is not null and tilt_units is not null))
check (tilt_magnitude is null or (tilt_units = 'deg' and tilt_magnitude between -90 and 90))
check ((ecg_lead_placement_code is null and ecg_lead_placement_system is null and ecg_lead_placement_valueset_id is null) or (ecg_lead_placement is not null and ecg_lead_placement_code is not null and ecg_lead_placement_system is not null and ecg_lead_placement_valueset_id is not null))
check ((qtc_algorithm_code is null and qtc_algorithm_system is null and qtc_algorithm_valueset_id is null) or (qtc_algorithm is not null and qtc_algorithm_code is not null and qtc_algorithm_system is not null and qtc_algorithm_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• ecg_result_multimedia_representation via ecg_result_id
• ecg_result_per_lead via ecg_result_id

Indexes

• ecg_result_form_id_idx on form_id
• ecg_result_recording_device_idx on recording_device
• ecg_result_viewing_device_idx on viewing_device

Child tables

2 tables hang off ecg_result, one row per repetition.

ecg_result_multimedia_representation

Child table — one row per repetition, deleted with its parent.

Unique

• ecg_result_id, position
• ecg_result_id, attachment_id

References

Indexes

• ecg_result_multimedia_representation_attachment_id_idx on attachment_id

ecg_result_per_lead

Child table — one row per repetition, deleted with its parent.

Constraints

check ((p_amplitude_magnitude is null and p_amplitude_units is null) or (p_amplitude_magnitude is not null and p_amplitude_units is not null))
check ((p_duration_magnitude is null and p_duration_units is null) or (p_duration_magnitude is not null and p_duration_units is not null))
check (p_duration_magnitude is null or (p_duration_units = 'ms' and p_duration_magnitude >= 0))
check ((p_area_magnitude is null and p_area_units is null) or (p_area_magnitude is not null and p_area_units is not null))
check ((p_amplitude_at0043_magnitude is null and p_amplitude_at0043_units is null) or (p_amplitude_at0043_magnitude is not null and p_amplitude_at0043_units is not null))
check ((p_duration_at0044_magnitude is null and p_duration_at0044_units is null) or (p_duration_at0044_magnitude is not null and p_duration_at0044_units is not null))
check (p_duration_at0044_magnitude is null or (p_duration_at0044_units = 'ms' and p_duration_at0044_magnitude >= 0))
check ((p_area_at0046_magnitude is null and p_area_at0046_units is null) or (p_area_at0046_magnitude is not null and p_area_at0046_units is not null))
check ((q_amplitude_magnitude is null and q_amplitude_units is null) or (q_amplitude_magnitude is not null and q_amplitude_units is not null))
check ((q_duration_magnitude is null and q_duration_units is null) or (q_duration_magnitude is not null and q_duration_units is not null))
check (q_duration_magnitude is null or (q_duration_units = 'ms' and q_duration_magnitude >= 0))
check ((r_amplitude_magnitude is null and r_amplitude_units is null) or (r_amplitude_magnitude is not null and r_amplitude_units is not null))
check ((r_duration_magnitude is null and r_duration_units is null) or (r_duration_magnitude is not null and r_duration_units is not null))
check (r_duration_magnitude is null or (r_duration_units = 'ms' and r_duration_magnitude >= 0))
check ((s_amplitude_magnitude is null and s_amplitude_units is null) or (s_amplitude_magnitude is not null and s_amplitude_units is not null))
check ((s_duration_magnitude is null and s_duration_units is null) or (s_duration_magnitude is not null and s_duration_units is not null))
check (s_duration_magnitude is null or (s_duration_units = 'ms' and s_duration_magnitude >= 0))
check ((r_amplitude_at0055_magnitude is null and r_amplitude_at0055_units is null) or (r_amplitude_at0055_magnitude is not null and r_amplitude_at0055_units is not null))
check ((r_duration_at0056_magnitude is null and r_duration_at0056_units is null) or (r_duration_at0056_magnitude is not null and r_duration_at0056_units is not null))
check (r_duration_at0056_magnitude is null or (r_duration_at0056_units = 'ms' and r_duration_at0056_magnitude >= 0))
check ((s_amplitude_at0057_magnitude is null and s_amplitude_at0057_units is null) or (s_amplitude_at0057_magnitude is not null and s_amplitude_at0057_units is not null))
check ((s_duration_at0058_magnitude is null and s_duration_at0058_units is null) or (s_duration_at0058_magnitude is not null and s_duration_at0058_units is not null))
check (s_duration_at0058_magnitude is null or (s_duration_at0058_units = 'ms' and s_duration_at0058_magnitude >= 0))
check ((ventricular_activation_time_vat_magnitude is null and ventricular_activation_time_vat_units is null) or (ventricular_activation_time_vat_magnitude is not null and ventricular_activation_time_vat_units is not null))
check (ventricular_activation_time_vat_magnitude is null or (ventricular_activation_time_vat_units = 'ms' and ventricular_activation_time_vat_magnitude >= 0))
check ((qrs_p_p_magnitude is null and qrs_p_p_units is null) or (qrs_p_p_magnitude is not null and qrs_p_p_units is not null))
check (qrs_p_p_magnitude is null or (qrs_p_p_units = 'mV' and qrs_p_p_magnitude >= 0))
check ((qrs_duration_magnitude is null and qrs_duration_units is null) or (qrs_duration_magnitude is not null and qrs_duration_units is not null))
check (qrs_duration_magnitude is null or (qrs_duration_units = 'ms' and qrs_duration_magnitude >= 0))
check ((qrs_area_magnitude is null and qrs_area_units is null) or (qrs_area_magnitude is not null and qrs_area_units is not null))
check ((st_onset_magnitude is null and st_onset_units is null) or (st_onset_magnitude is not null and st_onset_units is not null))
check ((st_midpoint_magnitude is null and st_midpoint_units is null) or (st_midpoint_magnitude is not null and st_midpoint_units is not null))
check ((st_80ms_magnitude is null and st_80ms_units is null) or (st_80ms_magnitude is not null and st_80ms_units is not null))
check ((st_60ms_magnitude is null and st_60ms_units is null) or (st_60ms_magnitude is not null and st_60ms_units is not null))
check ((st_end_magnitude is null and st_end_units is null) or (st_end_magnitude is not null and st_end_units is not null))
check ((st_duration_magnitude is null and st_duration_units is null) or (st_duration_magnitude is not null and st_duration_units is not null))
check (st_duration_magnitude is null or (st_duration_units = 'ms' and st_duration_magnitude >= 0))
check ((st_slope_magnitude is null and st_slope_units is null) or (st_slope_magnitude is not null and st_slope_units is not null))
check (st_slope_magnitude is null or (st_slope_units = 'deg' and st_slope_magnitude between -90 and 90))
check ((st_segment_morphology_code is null and st_segment_morphology_system is null and st_segment_morphology_valueset_id is null) or (st_segment_morphology is not null and st_segment_morphology_code is not null and st_segment_morphology_system is not null and st_segment_morphology_valueset_id is not null))
check ((t_amplitude_magnitude is null and t_amplitude_units is null) or (t_amplitude_magnitude is not null and t_amplitude_units is not null))
check ((t_duration_magnitude is null and t_duration_units is null) or (t_duration_magnitude is not null and t_duration_units is not null))
check (t_duration_magnitude is null or (t_duration_units = 'ms' and t_duration_magnitude >= 0))
check ((t_area_magnitude is null and t_area_units is null) or (t_area_magnitude is not null and t_area_units is not null))

Unique

• ecg_result_id, position

References

Value sets