blood_pressure

The local measurement of arterial blood pressure which is a surrogate for arterial pressure in the systemic circulation.

The local measurement of arterial blood pressure which is a surrogate for arterial pressure in the systemic circulation.

Purpose. To record the systemic arterial blood pressure of an individual.

Source

Columns

Constraints

check ((systolic_magnitude is null and systolic_units is null) or (systolic_magnitude is not null and systolic_units is not null))
check (systolic_magnitude is null or (systolic_units = 'mm[Hg]' and systolic_magnitude between 0 and 1000))
check ((diastolic_magnitude is null and diastolic_units is null) or (diastolic_magnitude is not null and diastolic_units is not null))
check (diastolic_magnitude is null or (diastolic_units = 'mm[Hg]' and diastolic_magnitude between 0 and 1000))
check ((mean_arterial_pressure_magnitude is null and mean_arterial_pressure_units is null) or (mean_arterial_pressure_magnitude is not null and mean_arterial_pressure_units is not null))
check (mean_arterial_pressure_magnitude is null or (mean_arterial_pressure_units = 'mm[Hg]' and mean_arterial_pressure_magnitude between 0 and 1000))
check ((pulse_pressure_magnitude is null and pulse_pressure_units is null) or (pulse_pressure_magnitude is not null and pulse_pressure_units is not null))
check (pulse_pressure_magnitude is null or (pulse_pressure_units = 'mm[Hg]' and pulse_pressure_magnitude between 0 and 1000))
check ((clinical_interpretation_code is null and clinical_interpretation_system is null and clinical_interpretation_valueset_id is null) or (clinical_interpretation is not null and clinical_interpretation_code is not null and clinical_interpretation_system is not null and clinical_interpretation_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 ((sleep_status_code is null and sleep_status_system is null and sleep_status_valueset_id is null and sleep_status is null) or (sleep_status is not null and sleep_status_code is not null and sleep_status_system is not null and sleep_status_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 ((cuff_size_code is null and cuff_size_system is null and cuff_size_valueset_id is null and cuff_size is null) or (cuff_size is not null and cuff_size_code is not null and cuff_size_system is not null and cuff_size_valueset_id is not null))
check ((location_of_measurement_code is null and location_of_measurement_system is null and location_of_measurement_valueset_id is null) or (location_of_measurement is not null and location_of_measurement_code is not null and location_of_measurement_system is not null and location_of_measurement_valueset_id is not null))
check ((method_code is null and method_system is null and method_valueset_id is null and method is null) or (method is not null and method_code is not null and method_system is not null and method_valueset_id is not null))
check ((diastolic_endpoint_code is null and diastolic_endpoint_system is null and diastolic_endpoint_valueset_id is null and diastolic_endpoint is null) or (diastolic_endpoint is not null and diastolic_endpoint_code is not null and diastolic_endpoint_system is not null and diastolic_endpoint_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• blood_pressure_structured_measurement_location via blood_pressure_id

Indexes

• blood_pressure_form_id_idx on form_id
• blood_pressure_device_idx on device

Child tables

1 table hang off blood_pressure, one row per repetition.

blood_pressure_structured_measurement_location

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

Unique

• blood_pressure_id, position
• blood_pressure_id, anatomical_location_id

References

Indexes

• blood_pressure_structured_measurement_location_anatomica_253b08 on anatomical_location_id

Value sets