intraocular_pressure

The measurement of intraocular pressure, most commonly using a tonometry device.

The measurement of intraocular pressure, most commonly using a tonometry device.

Purpose. To record one or more intraocular pressure measurements as part of a single assessment.

Source

Columns

Constraints

check ((eye_examined_code is null and eye_examined_system is null and eye_examined_valueset_id is null and eye_examined is null) or (eye_examined is not null and eye_examined_code is not null and eye_examined_system is not null and eye_examined_valueset_id is not null))
check ((pressure_magnitude is null and pressure_units is null) or (pressure_magnitude is not null and pressure_units is not null))
check (pressure_magnitude is null or (pressure_units = 'mm[Hg]' and pressure_magnitude between 0 and 1000))
check ((tonometry_type_code is null and tonometry_type_system is null and tonometry_type_valueset_id is null) or (tonometry_type is not null and tonometry_type_code is not null and tonometry_type_system is not null and tonometry_type_valueset_id is not null))
check ((corrected_pressure_magnitude is null and corrected_pressure_units is null) or (corrected_pressure_magnitude is not null and corrected_pressure_units is not null))
check (corrected_pressure_magnitude is null or (corrected_pressure_units = 'mm[Hg]' and corrected_pressure_magnitude between 0 and 1000))
check ((correction_type_code is null and correction_type_system is null and correction_type_valueset_id is null) or (correction_type is not null and correction_type_code is not null and correction_type_system is not null and correction_type_valueset_id is not null))
check ((palpation_finding_code is null and palpation_finding_system is null and palpation_finding_valueset_id is null) or (palpation_finding is not null and palpation_finding_code is not null and palpation_finding_system is not null and palpation_finding_valueset_id is not null))
check ((inspection_finding_code is null and inspection_finding_system is null and inspection_finding_valueset_id is null) or (inspection_finding is not null and inspection_finding_code is not null and inspection_finding_system is not null and inspection_finding_valueset_id is not null))
check ((pupil_state_code is null and pupil_state_system is null and pupil_state_valueset_id is null) or (pupil_state is not null and pupil_state_code is not null and pupil_state_system is not null and pupil_state_valueset_id is not null))
check ((body_position_code is null and body_position_system is null and body_position_valueset_id is null) or (body_position is not null and body_position_code is not null and body_position_system is not null and body_position_valueset_id is not null))
check ((anaesthesia_state_code is null and anaesthesia_state_system is null and anaesthesia_state_valueset_id is null) or (anaesthesia_state is not null and anaesthesia_state_code is not null and anaesthesia_state_system is not null and anaesthesia_state_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• intraocular_pressure_test_not_done via intraocular_pressure_id
• intraocular_pressure_additional_details via intraocular_pressure_id

Indexes

• intraocular_pressure_form_id_idx on form_id
• intraocular_pressure_tonometer_details_idx on tonometer_details

Child tables

2 tables hang off intraocular_pressure, one row per repetition.

intraocular_pressure_test_not_done

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

Unique

• intraocular_pressure_id, position
• intraocular_pressure_id, exclusion_exam_id

References

Indexes

• intraocular_pressure_test_not_done_exclusion_exam_id_idx on exclusion_exam_id

intraocular_pressure_additional_details

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

Unique

• intraocular_pressure_id, position
• intraocular_pressure_id, clinical_evidence_id

References

Indexes

• intraocular_pressure_additional_details_clinical_evidenc_ff54ed on clinical_evidence_id

Value sets