imaging_exam_ovary

Findings on radiological examination of a single ovary.

Findings on radiological examination of a single ovary.

Purpose. To record the findings on radiological examination of an ovary, 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 ((volume_magnitude is null and volume_units is null) or (volume_magnitude is not null and volume_units is not null))
check (volume_magnitude is null or (volume_units = 'mL' and volume_magnitude >= 0))
check (number_of_antral_follicles is null or number_of_antral_follicles >= 0)

References

Referenced by

• imaging_exam_ovary_structured_body_site via imaging_exam_ovary_id
• imaging_exam_ovary_additional_details via imaging_exam_ovary_id
• imaging_exam_ovary_diameter via imaging_exam_ovary_id
• imaging_exam_ovary_largest_follicle_diameter via imaging_exam_ovary_id
• imaging_exam_ovary_per_follicle via imaging_exam_ovary_id
• imaging_exam_result_structured_imaging_findings via imaging_exam_ovary_id
• investigation_screening_specific_investigation_additiona_45e74e via imaging_exam_ovary_id

Child tables

6 tables hang off imaging_exam_ovary, one row per repetition.

imaging_exam_ovary_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_ovary_id, position

References

Indexes

• imaging_exam_ovary_structured_body_site_anatomical_locat_b08124 on anatomical_location_id
• imaging_exam_ovary_structured_body_site_anatomical_locat_7eefd2 on anatomical_location_circle_id
• imaging_exam_ovary_structured_body_site_anatomical_locat_7ccbc8 on anatomical_location_relative_id

imaging_exam_ovary_additional_details

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

Unique

• imaging_exam_ovary_id, position
• imaging_exam_ovary_id, imaging_exam_lesion_adnexal_mass_id

References

Indexes

• imaging_exam_ovary_additional_details_imaging_exam_lesio_281c1b on imaging_exam_lesion_adnexal_mass_id

imaging_exam_ovary_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_ovary_id, position

References

imaging_exam_ovary_largest_follicle_diameter

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

Constraints

check ((largest_follicle_diameter_magnitude is null and largest_follicle_diameter_units is null) or (largest_follicle_diameter_magnitude is not null and largest_follicle_diameter_units is not null))
check (largest_follicle_diameter_magnitude is null or (largest_follicle_diameter_units = 'mm' and largest_follicle_diameter_magnitude >= 0) or (largest_follicle_diameter_units = 'cm' and largest_follicle_diameter_magnitude >= 0))

Unique

• imaging_exam_ovary_id, position

References

imaging_exam_ovary_per_follicle

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

Unique

• imaging_exam_ovary_id, position

References

Referenced by

• imaging_exam_ovary_per_follicle_diameter via imaging_exam_ovary_per_follicle_id

imaging_exam_ovary_per_follicle_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_ovary_per_follicle_id, position

References

Value sets