--- title: "imaging_exam_lesion_adnexal_mass" description: "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 | Model | Leg | Role | |---|---|---| | `openEHR-EHR-CLUSTER.imaging_exam-lesion-adnexal_mass.v0` | openEHR | defines this table | ## Columns | Column | Type | Null | Description | Source | |---|---|---|---|---| | `id` | `uuid primary key` | no | Primary key. | — | | `body_structure`
`body_structure_code`
`body_structure_system`
`body_structure_valueset_id` | coded text
`text`, `text`, `text`, `text` | yes | Body structure | `/items[at0001.1.1]` | | `body_site`
`body_site_code`
`body_site_system`
`body_site_valueset_id` | coded text
`text`, `text`, `text`, `text` | yes | Body site | `/items[at0002]` | | `imaging_findings` | `text` | yes | Imaging findings | `/items[at0004]` | | `impression`
`impression_code`
`impression_system`
`impression_valueset_id` | coded text
`text`, `text`, `text`, `text` | yes | Impression | `/items[at0006]` | | `comment` | `text` | yes | Comment | `/items[at0007]` | | `label` | `text` | yes | Label | `/items[at0.2]` | | `type`
`type_code`
`type_system`
`type_valueset_id` | coded text
`text`, `text`, `text`, `text` | yes | Type | `/items[at0.3.1]` | | `shape`
`shape_code`
`shape_system`
`shape_valueset_id` | coded text
`text`, `text`, `text`, `text` | yes | Shape | `/items[at0.9]` | | `texture`
`texture_code`
`texture_system`
`texture_valueset_id` | coded text
`text`, `text`, `text`, `text` | yes | Texture | `/items[at0.10]` | | `definition`
`definition_code`
`definition_system`
`definition_valueset_id` | coded text
`text`, `text`, `text`, `text` | yes | Definition | `/items[at0.11]` | | `contour`
`contour_code`
`contour_system`
`contour_valueset_id` | coded text
`text`, `text`, `text`, `text` | yes | Contour | `/items[at0.14]` | | `margin`
`margin_code`
`margin_system`
`margin_valueset_id` | coded text
`text`, `text`, `text`, `text` | yes | Margin | `/items[at0.15]` | | `calcification`
`calcification_code`
`calcification_system`
`calcification_valueset_id` | coded text
`text`, `text`, `text`, `text` | yes | Calcification | `/items[at0.16]` | | `effect` | `text` | yes | Effect | `/items[at0.19]` | | `vascularisation`
`vascularisation_code`
`vascularisation_system`
`vascularisation_valueset_id` | coded text
`text`, `text`, `text`, `text` | yes | Vascularisation | `/items[at0.20]` | | `vascularisation_description` | `text` | yes | Vascularisation description | `/items[at0.25]` | | `number_of_cyst_locules` | `integer` | yes | Number of cyst locules | `/items[at0.0.8]` | | `number_of_papillary_projections` | `integer` | yes | Number of papillary projections | `/items[at0.0.13]` | | `maximal_septum_thickness_magnitude`
`maximal_septum_thickness_units` | quantity
`numeric`, `text` | yes | Maximal septum thickness | `/items[at0.0.14]` | ## Constraints ```sql 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 | Columns | Target | On delete | |---|---|---| | `body_structure_valueset_id, body_structure_code, body_structure_system, body_structure` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `body_site_valueset_id, body_site_code, body_site_system, body_site` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `impression_valueset_id, impression_code, impression_system, impression` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `type_valueset_id, type_code, type_system, type` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `shape_valueset_id, shape_code, shape_system, shape` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `texture_valueset_id, texture_code, texture_system, texture` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `definition_valueset_id, definition_code, definition_system, definition` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `contour_valueset_id, contour_code, contour_system, contour` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `margin_valueset_id, margin_code, margin_system, margin` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `calcification_valueset_id, calcification_code, calcification_system, calcification` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `vascularisation_valueset_id, vascularisation_code, vascularisation_system, vascularisation` | [`valueset_code`](/docs/tables/valueset_code) | restrict | ## Referenced by - [`imaging_exam_additional_details`](/docs/tables/imaging_exam_additional_details) via `imaging_exam_lesion_adnexal_mass_id` - [`imaging_exam_cervix_additional_details`](/docs/tables/imaging_exam_cervix_additional_details) via `imaging_exam_lesion_adnexal_mass_id` - [`imaging_exam_fallopian_tube_additional_details`](/docs/tables/imaging_exam_fallopian_tube_additional_details) via `imaging_exam_lesion_adnexal_mass_id` - [`imaging_exam_foetus_additional_details`](/docs/tables/imaging_exam_foetus_additional_details) via `imaging_exam_lesion_adnexal_mass_id` - [`imaging_exam_gestational_sac_additional_details`](/docs/tables/imaging_exam_gestational_sac_additional_details) via `imaging_exam_lesion_adnexal_mass_id` - [`imaging_exam_hip_joint_additional_details`](/docs/tables/imaging_exam_hip_joint_additional_details) via `imaging_exam_lesion_adnexal_mass_id` - [`imaging_exam_lesion_adnexal_mass_structured_body_site`](/docs/tables/imaging_exam_lesion_adnexal_mass_structured_body_site) via `imaging_exam_lesion_adnexal_mass_id` - [`imaging_exam_lesion_adnexal_mass_additional_details`](/docs/tables/imaging_exam_lesion_adnexal_mass_additional_details) via `imaging_exam_lesion_adnexal_mass_id` - [`imaging_exam_lesion_adnexal_mass_additional_details`](/docs/tables/imaging_exam_lesion_adnexal_mass_additional_details) via `additional_details_id` - [`imaging_exam_lesion_adnexal_mass_diameter`](/docs/tables/imaging_exam_lesion_adnexal_mass_diameter) via `imaging_exam_lesion_adnexal_mass_id` - [`imaging_exam_lesion_adnexal_mass_solid_diameter`](/docs/tables/imaging_exam_lesion_adnexal_mass_solid_diameter) via `imaging_exam_lesion_adnexal_mass_id` - [`imaging_exam_ovary_additional_details`](/docs/tables/imaging_exam_ovary_additional_details) via `imaging_exam_lesion_adnexal_mass_id` - [`imaging_exam_rectouterine_pouch_additional_details`](/docs/tables/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. | Column | Type | Null | Description | Source | |---|---|---|---|---| | `id` | `uuid primary key` | no | Primary key. | — | | `imaging_exam_lesion_adnexal_mass_id` | `uuid` → [`imaging_exam_lesion_adnexal_mass`](/docs/tables/imaging_exam_lesion_adnexal_mass) | no | — | — | | `position` | `integer` | no | Order of this row within its parent, from zero. | — | | `anatomical_location_id` | `uuid` | yes | — | — | | `anatomical_location_circle_id` | `uuid` | yes | — | — | | `anatomical_location_relative_id` | `uuid` | yes | — | — | #### Constraints ```sql check (num_nonnulls(anatomical_location_id, anatomical_location_circle_id, anatomical_location_relative_id) = 1) ``` #### Unique - `imaging_exam_lesion_adnexal_mass_id, position` #### References | Columns | Target | On delete | |---|---|---| | `imaging_exam_lesion_adnexal_mass_id` | [`imaging_exam_lesion_adnexal_mass`](/docs/tables/imaging_exam_lesion_adnexal_mass) | cascade | | `anatomical_location_id` | [`anatomical_location`](/docs/tables/anatomical_location) | no action | | `anatomical_location_circle_id` | [`anatomical_location_circle`](/docs/tables/anatomical_location_circle) | no action | | `anatomical_location_relative_id` | [`anatomical_location_relative`](/docs/tables/anatomical_location_relative) | no action | #### 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. | Column | Type | Null | Description | Source | |---|---|---|---|---| | `id` | `uuid primary key` | no | Primary key. | — | | `imaging_exam_lesion_adnexal_mass_id` | `uuid` → [`imaging_exam_lesion_adnexal_mass`](/docs/tables/imaging_exam_lesion_adnexal_mass) | no | — | — | | `position` | `integer` | no | Order of this row within its parent, from zero. | — | | `additional_details_id` | `uuid` | no | Additional details | `/items[at0005]` | #### Unique - `imaging_exam_lesion_adnexal_mass_id, position` - `imaging_exam_lesion_adnexal_mass_id, additional_details_id` #### References | Columns | Target | On delete | |---|---|---| | `imaging_exam_lesion_adnexal_mass_id` | [`imaging_exam_lesion_adnexal_mass`](/docs/tables/imaging_exam_lesion_adnexal_mass) | cascade | | `additional_details_id` | [`imaging_exam_lesion_adnexal_mass`](/docs/tables/imaging_exam_lesion_adnexal_mass) | no action | #### 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. | Column | Type | Null | Description | Source | |---|---|---|---|---| | `id` | `uuid primary key` | no | Primary key. | — | | `imaging_exam_lesion_adnexal_mass_id` | `uuid` → [`imaging_exam_lesion_adnexal_mass`](/docs/tables/imaging_exam_lesion_adnexal_mass) | no | — | — | | `position` | `integer` | no | Order of this row within its parent, from zero. | — | | `diameter_magnitude`
`diameter_units` | quantity
`numeric`, `text` | yes | Diameter | `/items[at0.4]` | #### Constraints ```sql 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 | Columns | Target | On delete | |---|---|---| | `imaging_exam_lesion_adnexal_mass_id` | [`imaging_exam_lesion_adnexal_mass`](/docs/tables/imaging_exam_lesion_adnexal_mass) | cascade | ### `imaging_exam_lesion_adnexal_mass_solid_diameter` Child table — one row per repetition, deleted with its parent. | Column | Type | Null | Description | Source | |---|---|---|---|---| | `id` | `uuid primary key` | no | Primary key. | — | | `imaging_exam_lesion_adnexal_mass_id` | `uuid` → [`imaging_exam_lesion_adnexal_mass`](/docs/tables/imaging_exam_lesion_adnexal_mass) | no | — | — | | `position` | `integer` | no | Order of this row within its parent, from zero. | — | | `solid_diameter_magnitude`
`solid_diameter_units` | quantity
`numeric`, `text` | yes | Solid diameter | `/items[at0.0.15]` | #### Constraints ```sql 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 | Columns | Target | On delete | |---|---|---| | `imaging_exam_lesion_adnexal_mass_id` | [`imaging_exam_lesion_adnexal_mass`](/docs/tables/imaging_exam_lesion_adnexal_mass) | cascade | ## Value sets | Value set | Codes | |---|---| | `org.openehr::openEHR-EHR-CLUSTER.imaging_exam-lesion-adnexal_mass.v0/body_structure` | 1 | | `org.openehr::openEHR-EHR-CLUSTER.imaging_exam-lesion-adnexal_mass.v0/calcification` | 2 |