spirometry_result

Pulmonary function test results using a spirometer or peak flow meter.

Pulmonary function test results using a spirometer or peak flow meter.

Purpose. To record the results of a pulmonary function test performed using a spirometer or peak flow meter.

Source

Columns

Constraints

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 ((type_of_measurement_code is null and type_of_measurement_system is null and type_of_measurement_valueset_id is null and type_of_measurement is null) or (type_of_measurement is not null and type_of_measurement_code is not null and type_of_measurement_system is not null and type_of_measurement_valueset_id is not null))
check ((method_code is null and method_system is null and method_valueset_id 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 ((challenge_reversibility_code is null and challenge_reversibility_system is null and challenge_reversibility_valueset_id is null and challenge_reversibility is null) or (challenge_reversibility is not null and challenge_reversibility_code is not null and challenge_reversibility_system is not null and challenge_reversibility_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• spirometry_result_volume via spirometry_result_id
• spirometry_result_flow_rate via spirometry_result_id
• spirometry_result_pressure via spirometry_result_id
• spirometry_result_ratio via spirometry_result_id
• spirometry_result_multimedia_representation via spirometry_result_id
• spirometry_result_device via spirometry_result_id
• spirometry_result_predicted_results_source via spirometry_result_id

Indexes

• spirometry_result_form_id_idx on form_id

Child tables

7 tables hang off spirometry_result, one row per repetition.

spirometry_result_volume

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

Constraints

check ((result_magnitude is null and result_units is null) or (result_magnitude is not null and result_units is not null))
check (result_magnitude is null or (result_units = 'L' and result_magnitude >= 0) or (result_units = 'mL' and result_magnitude >= 0))
check ((predicted_result_magnitude is null and predicted_result_units is null) or (predicted_result_magnitude is not null and predicted_result_units is not null))
check (predicted_result_magnitude is null or (predicted_result_units = 'L' and predicted_result_magnitude >= 0) or (predicted_result_units = 'mL' and predicted_result_magnitude >= 0))
check ((measured_predicted_ratio_numerator is null and measured_predicted_ratio_denominator is null) or (measured_predicted_ratio_numerator is not null and measured_predicted_ratio_denominator is not null))
check (measured_predicted_ratio_denominator is null or measured_predicted_ratio_denominator <> 0)
check (measured_predicted_ratio_denominator is null or measured_predicted_ratio_denominator = 100)
check (measured_predicted_ratio_numerator is null or measured_predicted_ratio_numerator >= 0)

Unique

• spirometry_result_id, position

References

spirometry_result_flow_rate

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

Constraints

check ((result_magnitude is null and result_units is null) or (result_magnitude is not null and result_units is not null))
check (result_magnitude is null or (result_units = 'L/s' and result_magnitude >= 0) or (result_units = 'mL/s' and result_magnitude >= 0) or (result_units = 'L/min' and result_magnitude >= 0))
check ((predicted_result_magnitude is null and predicted_result_units is null) or (predicted_result_magnitude is not null and predicted_result_units is not null))
check (predicted_result_magnitude is null or (predicted_result_units = 'L/s' and predicted_result_magnitude >= 0) or (predicted_result_units = 'mL/s' and predicted_result_magnitude >= 0) or (predicted_result_units = 'L/min' and predicted_result_magnitude >= 0))
check ((measured_predicted_ratio_numerator is null and measured_predicted_ratio_denominator is null) or (measured_predicted_ratio_numerator is not null and measured_predicted_ratio_denominator is not null))
check (measured_predicted_ratio_denominator is null or measured_predicted_ratio_denominator <> 0)
check (measured_predicted_ratio_denominator is null or measured_predicted_ratio_denominator = 100)
check (measured_predicted_ratio_numerator is null or measured_predicted_ratio_numerator >= 0)

Unique

• spirometry_result_id, position

References

spirometry_result_pressure

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

Constraints

check ((result_magnitude is null and result_units is null) or (result_magnitude is not null and result_units is not null))
check (result_magnitude is null or (result_units = 'cm[H2O]' and result_magnitude >= 0) or (result_units = 'mm[Hg]' and result_magnitude >= 0))
check ((predicted_result_magnitude is null and predicted_result_units is null) or (predicted_result_magnitude is not null and predicted_result_units is not null))
check (predicted_result_magnitude is null or (predicted_result_units = 'cm[H2O]' and predicted_result_magnitude >= 0) or (predicted_result_units = 'mm[Hg]' and predicted_result_magnitude >= 0))
check ((measured_predicted_ratio_numerator is null and measured_predicted_ratio_denominator is null) or (measured_predicted_ratio_numerator is not null and measured_predicted_ratio_denominator is not null))
check (measured_predicted_ratio_denominator is null or measured_predicted_ratio_denominator <> 0)
check (measured_predicted_ratio_denominator is null or measured_predicted_ratio_denominator = 100)
check (measured_predicted_ratio_numerator is null or measured_predicted_ratio_numerator >= 0)

Unique

• spirometry_result_id, position

References

spirometry_result_ratio

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

Constraints

check ((result_numerator is null and result_denominator is null) or (result_numerator is not null and result_denominator is not null))
check (result_denominator is null or result_denominator <> 0)
check (result_denominator is null or result_denominator = 100)
check (result_numerator is null or result_numerator >= 0)
check ((predicted_result_numerator is null and predicted_result_denominator is null) or (predicted_result_numerator is not null and predicted_result_denominator is not null))
check (predicted_result_denominator is null or predicted_result_denominator <> 0)
check (predicted_result_denominator is null or predicted_result_denominator = 100)
check (predicted_result_numerator is null or predicted_result_numerator >= 0)

Unique

• spirometry_result_id, position

References

spirometry_result_multimedia_representation

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

Unique

• spirometry_result_id, position
• spirometry_result_id, attachment_id

References

Indexes

• spirometry_result_multimedia_representation_attachment_id_idx on attachment_id

spirometry_result_device

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

Unique

• spirometry_result_id, position
• spirometry_result_id, device_id

References

Indexes

• spirometry_result_device_device_id_idx on device_id

spirometry_result_predicted_results_source

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

Unique

• spirometry_result_id, position
• spirometry_result_id, knowledge_base_reference_id

References

Indexes

• spirometry_result_predicted_results_source_knowledge_bas_130a06 on knowledge_base_reference_id

Value sets