imaging_exam_lesion_adnexal_mass

Findings on radiological examination of an adnexal mass identified in the pelvis, usually related to a single ovary and/or fallopian tube and associated connective tissues.

Findings on radiological examination of an adnexal mass identified in the pelvis, usually related to a single ovary and/or fallopian tube and associated connective tissues.

Purpose. To record the findings on radiological examination of a single adnexal mass.

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 ((type_code is null and type_system is null and type_valueset_id is null) or (type is not null and type_code is not null and type_system is not null and type_valueset_id is not null))
check ((shape_code is null and shape_system is null and shape_valueset_id is null) or (shape is not null and shape_code is not null and shape_system is not null and shape_valueset_id is not null))
check ((texture_code is null and texture_system is null and texture_valueset_id is null) or (texture is not null and texture_code is not null and texture_system is not null and texture_valueset_id is not null))
check ((definition_code is null and definition_system is null and definition_valueset_id is null) or (definition is not null and definition_code is not null and definition_system is not null and definition_valueset_id is not null))
check ((contour_code is null and contour_system is null and contour_valueset_id is null) or (contour is not null and contour_code is not null and contour_system is not null and contour_valueset_id is not null))
check ((margin_code is null and margin_system is null and margin_valueset_id is null) or (margin is not null and margin_code is not null and margin_system is not null and margin_valueset_id is not null))
check ((calcification_code is null and calcification_system is null and calcification_valueset_id is null and calcification is null) or (calcification is not null and calcification_code is not null and calcification_system is not null and calcification_valueset_id is not null))
check ((vascularisation_code is null and vascularisation_system is null and vascularisation_valueset_id is null) or (vascularisation is not null and vascularisation_code is not null and vascularisation_system is not null and vascularisation_valueset_id is not null))
check (number_of_cyst_locules is null or number_of_cyst_locules >= 0)
check (number_of_papillary_projections is null or number_of_papillary_projections >= 0)
check ((maximal_septum_thickness_magnitude is null and maximal_septum_thickness_units is null) or (maximal_septum_thickness_magnitude is not null and maximal_septum_thickness_units is not null))
check (maximal_septum_thickness_magnitude is null or (maximal_septum_thickness_units = 'mm' and maximal_septum_thickness_magnitude >= 0))

References

Referenced by

• imaging_exam_additional_details via imaging_exam_lesion_adnexal_mass_id
• imaging_exam_cervix_additional_details via imaging_exam_lesion_adnexal_mass_id
• imaging_exam_fallopian_tube_additional_details via imaging_exam_lesion_adnexal_mass_id
• imaging_exam_foetus_additional_details via imaging_exam_lesion_adnexal_mass_id
• imaging_exam_gestational_sac_additional_details via imaging_exam_lesion_adnexal_mass_id
• imaging_exam_hip_joint_additional_details via imaging_exam_lesion_adnexal_mass_id
• imaging_exam_lesion_adnexal_mass_structured_body_site via imaging_exam_lesion_adnexal_mass_id
• imaging_exam_lesion_adnexal_mass_additional_details via imaging_exam_lesion_adnexal_mass_id
• imaging_exam_lesion_adnexal_mass_additional_details via additional_details_id
• imaging_exam_lesion_adnexal_mass_diameter via imaging_exam_lesion_adnexal_mass_id
• imaging_exam_lesion_adnexal_mass_solid_diameter via imaging_exam_lesion_adnexal_mass_id
• imaging_exam_ovary_additional_details via imaging_exam_lesion_adnexal_mass_id
• imaging_exam_rectouterine_pouch_additional_details via imaging_exam_lesion_adnexal_mass_id

Child tables

4 tables hang off imaging_exam_lesion_adnexal_mass, one row per repetition.

imaging_exam_lesion_adnexal_mass_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_lesion_adnexal_mass_id, position

References

Indexes

• imaging_exam_lesion_adnexal_mass_structured_body_site_an_966cf0 on anatomical_location_id
• imaging_exam_lesion_adnexal_mass_structured_body_site_an_6b5812 on anatomical_location_circle_id
• imaging_exam_lesion_adnexal_mass_structured_body_site_an_b58f7a on anatomical_location_relative_id

imaging_exam_lesion_adnexal_mass_additional_details

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

Unique

• imaging_exam_lesion_adnexal_mass_id, position
• imaging_exam_lesion_adnexal_mass_id, additional_details_id

References

Indexes

• imaging_exam_lesion_adnexal_mass_additional_details_addi_04d069 on additional_details_id

imaging_exam_lesion_adnexal_mass_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_lesion_adnexal_mass_id, position

References

imaging_exam_lesion_adnexal_mass_solid_diameter

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

Constraints

check ((solid_diameter_magnitude is null and solid_diameter_units is null) or (solid_diameter_magnitude is not null and solid_diameter_units is not null))
check (solid_diameter_magnitude is null or (solid_diameter_units = 'mm' and solid_diameter_magnitude >= 0) or (solid_diameter_units = 'cm' and solid_diameter_magnitude >= 0))

Unique

• imaging_exam_lesion_adnexal_mass_id, position

References

Value sets