---
title: "anatomical_location_relative"
description: "A physical site on or within the human body that is described in terms of its relationship to other body parts."
---

A physical site on or within the human body that is described in terms of its relationship to other body parts.

**Purpose.** To identify and record structured details about a single physical site on, or within, the human body in terms of its relationship to other macroscopic anatomical landmarks.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-CLUSTER.anatomical_location_relative.v2` | openEHR | defines this table |

## Columns

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `description` | `text` | yes | Description | `/items[at0023]` |

## Referenced by

23 tables reference `anatomical_location_relative`, via `anatomical_location_relative_id`. The first 15 alphabetically:

- [`adverse_reaction_event_reaction_details`](/docs/tables/adverse_reaction_event_reaction_details) via `anatomical_location_relative_id`
- [`anatomical_location_alternative_structure`](/docs/tables/anatomical_location_alternative_structure) via `anatomical_location_relative_id`
- [`anatomical_location_relative_relative_location`](/docs/tables/anatomical_location_relative_relative_location) via `anatomical_location_relative_id`
- [`anatomical_location_relative_multimedia_representation`](/docs/tables/anatomical_location_relative_multimedia_representation) via `anatomical_location_relative_id`
- [`capillary_refill`](/docs/tables/capillary_refill) via `structured_measurement_location_anatomical_location_relative`
- [`exposure_screening_specific_exposure_additional_details`](/docs/tables/exposure_screening_specific_exposure_additional_details) via `anatomical_location_relative_id`
- [`imaging_exam_structured_body_site`](/docs/tables/imaging_exam_structured_body_site) via `anatomical_location_relative_id`
- [`imaging_exam_cervix_structured_body_site`](/docs/tables/imaging_exam_cervix_structured_body_site) via `anatomical_location_relative_id`
- [`imaging_exam_fallopian_tube_structured_body_site`](/docs/tables/imaging_exam_fallopian_tube_structured_body_site) via `anatomical_location_relative_id`
- [`imaging_exam_foetus_structured_body_site`](/docs/tables/imaging_exam_foetus_structured_body_site) via `anatomical_location_relative_id`
- [`imaging_exam_gestational_sac_structured_body_site`](/docs/tables/imaging_exam_gestational_sac_structured_body_site) via `anatomical_location_relative_id`
- [`imaging_exam_hip_joint_structured_body_site`](/docs/tables/imaging_exam_hip_joint_structured_body_site) via `anatomical_location_relative_id`
- [`imaging_exam_lesion_adnexal_mass_structured_body_site`](/docs/tables/imaging_exam_lesion_adnexal_mass_structured_body_site) via `anatomical_location_relative_id`
- [`imaging_exam_ovary_structured_body_site`](/docs/tables/imaging_exam_ovary_structured_body_site) via `anatomical_location_relative_id`
- [`imaging_exam_rectouterine_pouch_structured_body_site`](/docs/tables/imaging_exam_rectouterine_pouch_structured_body_site) via `anatomical_location_relative_id`

## Child tables

2 tables hang off `anatomical_location_relative`, one row per repetition.

### `anatomical_location_relative_relative_location`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `anatomical_location_relative_id` | `uuid` → [`anatomical_location_relative`](/docs/tables/anatomical_location_relative) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `landmark_name`<br />`landmark_name_code`<br />`landmark_name_system`<br />`landmark_name_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Landmark name | `/items[at0020]/items[at0021]` |
| `laterality`<br />`laterality_code`<br />`laterality_system`<br />`laterality_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Laterality | `/items[at0020]/items[at0062]` |
| `distance_from_landmark_magnitude`<br />`distance_from_landmark_units` | quantity<br />`numeric`, `text` | yes | Distance from landmark | `/items[at0020]/items[at0022]` |
| `direction`<br />`direction_code`<br />`direction_system`<br />`direction_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Direction | `/items[at0020]/items[at0006]` |

#### Constraints

```sql
check ((landmark_name_code is null and landmark_name_system is null and landmark_name_valueset_id is null) or (landmark_name is not null and landmark_name_code is not null and landmark_name_system is not null and landmark_name_valueset_id is not null))
check ((laterality_code is null and laterality_system is null and laterality_valueset_id is null and laterality is null) or (laterality is not null and laterality_code is not null and laterality_system is not null and laterality_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))
check ((direction_code is null and direction_system is null and direction_valueset_id is null) or (direction is not null and direction_code is not null and direction_system is not null and direction_valueset_id is not null))
```

#### Unique

- `anatomical_location_relative_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `anatomical_location_relative_id` | [`anatomical_location_relative`](/docs/tables/anatomical_location_relative) | cascade |
| `landmark_name_valueset_id, landmark_name_code, landmark_name_system, landmark_name` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `laterality_valueset_id, laterality_code, laterality_system, laterality` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `direction_valueset_id, direction_code, direction_system, direction` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

### `anatomical_location_relative_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_relative_id` | `uuid` → [`anatomical_location_relative`](/docs/tables/anatomical_location_relative) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `attachment_id` | `uuid` | no | Multimedia representation | `/items[at0054]` |

#### Unique

- `anatomical_location_relative_id, position`
- `anatomical_location_relative_id, attachment_id`

#### References

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

#### Indexes

- `anatomical_location_relative_multimedia_representation_a_c5ef86` on `attachment_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-CLUSTER.anatomical_location_relative.v2/direction` | 17 |
| `org.openehr::openEHR-EHR-CLUSTER.anatomical_location_relative.v2/laterality` | 2 |

