imaging_exam_rectouterine_pouch

Findings on radiological examination of the rectouterine pouch.

Findings on radiological examination of the rectouterine pouch.

Purpose. To record the findings on radiological examination of the rectouterine pouch, and their interpretation.

Source

Columns

Constraints

check ((body_structure_code is null and body_structure_system is null and body_structure_valueset_id is null and body_structure is null) or (body_structure is not null and body_structure_code is not null and body_structure_system is not null and body_structure_valueset_id is not null))
check ((body_site_code is null and body_site_system is null and body_site_valueset_id is null) or (body_site is not null and body_site_code is not null and body_site_system is not null and body_site_valueset_id is not null))
check ((impression_code is null and impression_system is null and impression_valueset_id is null) or (impression is not null and impression_code is not null and impression_system is not null and impression_valueset_id is not null))
check ((fluid_presence_code is null and fluid_presence_system is null and fluid_presence_valueset_id is null and fluid_presence is null) or (fluid_presence is not null and fluid_presence_code is not null and fluid_presence_system is not null and fluid_presence_valueset_id is not null))
check ((amount_of_free_fluid_coded_text_code is null and amount_of_free_fluid_coded_text_system is null and amount_of_free_fluid_coded_text_valueset_id is null and amount_of_free_fluid_coded_text is null) or (amount_of_free_fluid_coded_text is not null and amount_of_free_fluid_coded_text_code is not null and amount_of_free_fluid_coded_text_system is not null and amount_of_free_fluid_coded_text_valueset_id is not null))
check ((amount_of_free_fluid_quantity_magnitude is null and amount_of_free_fluid_quantity_units is null) or (amount_of_free_fluid_quantity_magnitude is not null and amount_of_free_fluid_quantity_units is not null))
check (amount_of_free_fluid_quantity_magnitude is null or (amount_of_free_fluid_quantity_units = 'L' and amount_of_free_fluid_quantity_magnitude >= 0) or (amount_of_free_fluid_quantity_units = 'mL' and amount_of_free_fluid_quantity_magnitude >= 0))
check (num_nonnulls(amount_of_free_fluid_coded_text, amount_of_free_fluid_quantity_magnitude) <= 1)

References

Referenced by

• imaging_exam_rectouterine_pouch_structured_body_site via imaging_exam_rectouterine_pouch_id
• imaging_exam_rectouterine_pouch_additional_details via imaging_exam_rectouterine_pouch_id
• imaging_exam_rectouterine_pouch_diameter via imaging_exam_rectouterine_pouch_id
• imaging_exam_result_structured_imaging_findings via imaging_exam_rectouterine_pouch_id
• investigation_screening_specific_investigation_additiona_45e74e via imaging_exam_rectouterine_pouch_id

Child tables

3 tables hang off imaging_exam_rectouterine_pouch, one row per repetition.

imaging_exam_rectouterine_pouch_structured_body_site

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

Constraints

check (num_nonnulls(anatomical_location_id, anatomical_location_circle_id, anatomical_location_relative_id) = 1)

Unique

• imaging_exam_rectouterine_pouch_id, position

References

Indexes

• imaging_exam_rectouterine_pouch_structured_body_site_ana_8c8df7 on anatomical_location_id
• imaging_exam_rectouterine_pouch_structured_body_site_ana_47c054 on anatomical_location_circle_id
• imaging_exam_rectouterine_pouch_structured_body_site_ana_83364d on anatomical_location_relative_id

imaging_exam_rectouterine_pouch_additional_details

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

Unique

• imaging_exam_rectouterine_pouch_id, position
• imaging_exam_rectouterine_pouch_id, imaging_exam_lesion_adnexal_mass_id

References

Indexes

• imaging_exam_rectouterine_pouch_additional_details_imagi_d21d97 on imaging_exam_lesion_adnexal_mass_id

imaging_exam_rectouterine_pouch_diameter

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

Constraints

check ((diameter_magnitude is null and diameter_units is null) or (diameter_magnitude is not null and diameter_units is not null))
check (diameter_magnitude is null or (diameter_units = 'mm' and diameter_magnitude >= 0) or (diameter_units = 'cm' and diameter_magnitude >= 0))

Unique

• imaging_exam_rectouterine_pouch_id, position

References

Value sets