---
title: "imaging_exam_ovary"
description: "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

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-CLUSTER.imaging_exam-ovary.v1` | openEHR | defines this table |

## Columns

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `body_structure`<br />`body_structure_code`<br />`body_structure_system`<br />`body_structure_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Body structure | `/items[at0001.1]` |
| `body_site`<br />`body_site_code`<br />`body_site_system`<br />`body_site_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Body site | `/items[at0002]` |
| `imaging_findings` | `text` | yes | Imaging findings | `/items[at0004]` |
| `impression`<br />`impression_code`<br />`impression_system`<br />`impression_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Impression | `/items[at0006]` |
| `comment` | `text` | yes | Comment | `/items[at0007]` |
| `volume_magnitude`<br />`volume_units` | quantity<br />`numeric`, `text` | yes | Volume | `/items[at0.9]` |
| `number_of_antral_follicles` | `integer` | yes | Number of antral follicles | `/items[at0.5]` |
| `follicle_distribution` | `text` | yes | Follicle distribution | `/items[at0.10]` |

## 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 ((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

| 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 |

## Referenced by

- [`imaging_exam_ovary_structured_body_site`](/docs/tables/imaging_exam_ovary_structured_body_site) via `imaging_exam_ovary_id`
- [`imaging_exam_ovary_additional_details`](/docs/tables/imaging_exam_ovary_additional_details) via `imaging_exam_ovary_id`
- [`imaging_exam_ovary_diameter`](/docs/tables/imaging_exam_ovary_diameter) via `imaging_exam_ovary_id`
- [`imaging_exam_ovary_largest_follicle_diameter`](/docs/tables/imaging_exam_ovary_largest_follicle_diameter) via `imaging_exam_ovary_id`
- [`imaging_exam_ovary_per_follicle`](/docs/tables/imaging_exam_ovary_per_follicle) via `imaging_exam_ovary_id`
- [`imaging_exam_result_structured_imaging_findings`](/docs/tables/imaging_exam_result_structured_imaging_findings) via `imaging_exam_ovary_id`
- [`investigation_screening_specific_investigation_additiona_45e74e`](/docs/tables/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.

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `imaging_exam_ovary_id` | `uuid` → [`imaging_exam_ovary`](/docs/tables/imaging_exam_ovary) | 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_ovary_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `imaging_exam_ovary_id` | [`imaging_exam_ovary`](/docs/tables/imaging_exam_ovary) | 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_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.

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `imaging_exam_ovary_id` | `uuid` → [`imaging_exam_ovary`](/docs/tables/imaging_exam_ovary) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `imaging_exam_lesion_adnexal_mass_id` | `uuid` | no | Additional details | `/items[at0005]` |

#### Unique

- `imaging_exam_ovary_id, position`
- `imaging_exam_ovary_id, imaging_exam_lesion_adnexal_mass_id`

#### References

| Columns | Target | On delete |
|---|---|---|
| `imaging_exam_ovary_id` | [`imaging_exam_ovary`](/docs/tables/imaging_exam_ovary) | cascade |
| `imaging_exam_lesion_adnexal_mass_id` | [`imaging_exam_lesion_adnexal_mass`](/docs/tables/imaging_exam_lesion_adnexal_mass) | no action |

#### 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.

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `imaging_exam_ovary_id` | `uuid` → [`imaging_exam_ovary`](/docs/tables/imaging_exam_ovary) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `diameter_magnitude`<br />`diameter_units` | quantity<br />`numeric`, `text` | yes | Diameter | `/items[at0.3]` |

#### 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_ovary_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `imaging_exam_ovary_id` | [`imaging_exam_ovary`](/docs/tables/imaging_exam_ovary) | cascade |

### `imaging_exam_ovary_largest_follicle_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_ovary_id` | `uuid` → [`imaging_exam_ovary`](/docs/tables/imaging_exam_ovary) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `largest_follicle_diameter_magnitude`<br />`largest_follicle_diameter_units` | quantity<br />`numeric`, `text` | yes | Largest follicle diameter | `/items[at0.4]` |

#### Constraints

```sql
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

| Columns | Target | On delete |
|---|---|---|
| `imaging_exam_ovary_id` | [`imaging_exam_ovary`](/docs/tables/imaging_exam_ovary) | cascade |

### `imaging_exam_ovary_per_follicle`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `imaging_exam_ovary_id` | `uuid` → [`imaging_exam_ovary`](/docs/tables/imaging_exam_ovary) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `label` | `text` | yes | Label | `/items[at0.6]/items[at0.11]` |
| `description` | `text` | yes | Description | `/items[at0.6]/items[at0.8]` |

#### Unique

- `imaging_exam_ovary_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `imaging_exam_ovary_id` | [`imaging_exam_ovary`](/docs/tables/imaging_exam_ovary) | cascade |

### Referenced by

- [`imaging_exam_ovary_per_follicle_diameter`](/docs/tables/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.

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `imaging_exam_ovary_per_follicle_id` | `uuid` → [`imaging_exam_ovary_per_follicle`](/docs/tables/imaging_exam_ovary_per_follicle) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `diameter_magnitude`<br />`diameter_units` | quantity<br />`numeric`, `text` | yes | Diameter | `/items[at0.6]/items[at0.7]` |

#### 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_ovary_per_follicle_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `imaging_exam_ovary_per_follicle_id` | [`imaging_exam_ovary_per_follicle`](/docs/tables/imaging_exam_ovary_per_follicle) | cascade |

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-CLUSTER.imaging_exam-ovary.v1/body_structure` | 2 |

