---
title: "anatomical_location_circle"
description: "A physical site on or within the human body that is described in terms of the direction, and optionally the distance, of the site from a central landmark."
---

A physical site on or within the human body that is described in terms of the direction, and optionally the distance, of the site from a central landmark.

**Purpose.** To record structured details about a physical site on or within the human body that is described in terms of the direction, and optionally the distance, of the site from a central landmark.

## Source

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

## Columns

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `reference_direction` | `text` | yes | Reference direction | `/items[at0065]` |
| `centre_landmark`<br />`centre_landmark_code`<br />`centre_landmark_system`<br />`centre_landmark_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Centre landmark | `/items[at0079]` |
| `circular_direction`<br />`circular_direction_code`<br />`circular_direction_system`<br />`circular_direction_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Circular direction | `/items[at0061]` |
| `distance_from_landmark_magnitude`<br />`distance_from_landmark_units` | quantity<br />`numeric`, `text` | yes | Distance from landmark | `/items[at0080]` |
| `description` | `text` | yes | Description | `/items[at0023]` |

## Constraints

```sql
check ((centre_landmark_code is null and centre_landmark_system is null and centre_landmark_valueset_id is null) or (centre_landmark is not null and centre_landmark_code is not null and centre_landmark_system is not null and centre_landmark_valueset_id is not null))
check ((circular_direction_code is null and circular_direction_system is null and circular_direction_valueset_id is null and circular_direction is null) or (circular_direction is not null and circular_direction_code is not null and circular_direction_system is not null and circular_direction_valueset_id is not null))
check ((distance_from_landmark_magnitude is null and distance_from_landmark_units is null) or (distance_from_landmark_magnitude is not null and distance_from_landmark_units is not null))
check (distance_from_landmark_magnitude is null or (distance_from_landmark_units = 'cm' and distance_from_landmark_magnitude >= 0) or (distance_from_landmark_units = '[in_i]' and distance_from_landmark_magnitude >= 0) or (distance_from_landmark_units = 'mm' and distance_from_landmark_magnitude >= 0))
```

## References

| Columns | Target | On delete |
|---|---|---|
| `centre_landmark_valueset_id, centre_landmark_code, centre_landmark_system, centre_landmark` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `circular_direction_valueset_id, circular_direction_code, circular_direction_system, circular_direction` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Referenced by

19 tables reference `anatomical_location_circle`, via `anatomical_location_circle_id`. The first 15 alphabetically:

- [`anatomical_location_alternative_structure`](/docs/tables/anatomical_location_alternative_structure) via `anatomical_location_circle_id`
- [`anatomical_location_circle_multimedia_representation`](/docs/tables/anatomical_location_circle_multimedia_representation) via `anatomical_location_circle_id`
- [`exposure_screening_specific_exposure_additional_details`](/docs/tables/exposure_screening_specific_exposure_additional_details) via `anatomical_location_circle_id`
- [`imaging_exam_structured_body_site`](/docs/tables/imaging_exam_structured_body_site) via `anatomical_location_circle_id`
- [`imaging_exam_cervix_structured_body_site`](/docs/tables/imaging_exam_cervix_structured_body_site) via `anatomical_location_circle_id`
- [`imaging_exam_fallopian_tube_structured_body_site`](/docs/tables/imaging_exam_fallopian_tube_structured_body_site) via `anatomical_location_circle_id`
- [`imaging_exam_foetus_structured_body_site`](/docs/tables/imaging_exam_foetus_structured_body_site) via `anatomical_location_circle_id`
- [`imaging_exam_gestational_sac_structured_body_site`](/docs/tables/imaging_exam_gestational_sac_structured_body_site) via `anatomical_location_circle_id`
- [`imaging_exam_hip_joint_structured_body_site`](/docs/tables/imaging_exam_hip_joint_structured_body_site) via `anatomical_location_circle_id`
- [`imaging_exam_lesion_adnexal_mass_structured_body_site`](/docs/tables/imaging_exam_lesion_adnexal_mass_structured_body_site) via `anatomical_location_circle_id`
- [`imaging_exam_ovary_structured_body_site`](/docs/tables/imaging_exam_ovary_structured_body_site) via `anatomical_location_circle_id`
- [`imaging_exam_rectouterine_pouch_structured_body_site`](/docs/tables/imaging_exam_rectouterine_pouch_structured_body_site) via `anatomical_location_circle_id`
- [`medication`](/docs/tables/medication) via `administration_details_structured_body_site_anatomical_l_afc7f9`
- [`medication_order`](/docs/tables/medication_order) via `structured_body_site_anatomical_location_circle`
- [`problem_diagnosis_structured_body_site`](/docs/tables/problem_diagnosis_structured_body_site) via `anatomical_location_circle_id`

## Child tables

1 table hang off `anatomical_location_circle`, one row per repetition.

### `anatomical_location_circle_multimedia_representation`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `anatomical_location_circle_id` | `uuid` → [`anatomical_location_circle`](/docs/tables/anatomical_location_circle) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `attachment_id` | `uuid` | no | Multimedia representation | `/items[at0054]` |

#### Unique

- `anatomical_location_circle_id, position`
- `anatomical_location_circle_id, attachment_id`

#### References

| Columns | Target | On delete |
|---|---|---|
| `anatomical_location_circle_id` | [`anatomical_location_circle`](/docs/tables/anatomical_location_circle) | cascade |
| `attachment_id` | [`attachment`](/docs/tables/attachment) | restrict |

#### Indexes

- `anatomical_location_circle_multimedia_representation_att_f3a774` on `attachment_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-CLUSTER.anatomical_location_circle.v1/circular_direction` | 12 |