---
title: "adverse_reaction_event"
description: "Information about a specific adverse reaction event caused by exposure to a specific substance."
---

Information about a specific adverse reaction event caused by exposure to a specific substance.

**Purpose.** To record information about a specific adverse reaction event caused by exposure to a specific substance.

## Source

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

## Columns

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `specific_substance`<br />`specific_substance_code`<br />`specific_substance_system`<br />`specific_substance_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Specific substance | `/items[at0001]` |
| `certainty`<br />`certainty_code`<br />`certainty_system`<br />`certainty_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Certainty | `/items[at0002]` |
| `manifestation`<br />`manifestation_code`<br />`manifestation_system`<br />`manifestation_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Manifestation | `/items[at0006]` |
| `reaction_description` | `text` | yes | Reaction description | `/items[at0007]` |
| `onset_of_reaction` | `timestamptz` | yes | Onset of reaction | `/items[at0008]` |
| `duration_of_reaction` | `interval` | yes | Duration of reaction | `/items[at0009]` |
| `severity_of_reaction`<br />`severity_of_reaction_code`<br />`severity_of_reaction_system`<br />`severity_of_reaction_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Severity of reaction | `/items[at0010]` |
| `initial_exposure` | `timestamptz` | yes | Initial exposure | `/items[at0015]` |
| `duration_of_exposure` | `interval` | yes | Duration of exposure | `/items[at0016]` |
| `route_of_exposure`<br />`route_of_exposure_code`<br />`route_of_exposure_system`<br />`route_of_exposure_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Route of exposure | `/items[at0017]` |
| `exposure_description` | `text` | yes | Exposure description | `/items[at0018]` |
| `clinical_management_description` | `text` | yes | Clinical management description | `/items[at0020]` |
| `supporting_clinical_record_information` | `text` | yes | Supporting clinical record information | `/items[at0025]` |
| `comment` | `text` | yes | Comment | `/items[at0024]` |

## Constraints

```sql
check ((specific_substance_code is null and specific_substance_system is null and specific_substance_valueset_id is null) or (specific_substance is not null and specific_substance_code is not null and specific_substance_system is not null and specific_substance_valueset_id is not null))
check ((certainty_code is null and certainty_system is null and certainty_valueset_id is null) or (certainty is not null and certainty_code is not null and certainty_system is not null and certainty_valueset_id is not null))
check ((manifestation_code is null and manifestation_system is null and manifestation_valueset_id is null) or (manifestation is not null and manifestation_code is not null and manifestation_system is not null and manifestation_valueset_id is not null))
check ((severity_of_reaction_code is null and severity_of_reaction_system is null and severity_of_reaction_valueset_id is null) or (severity_of_reaction is not null and severity_of_reaction_code is not null and severity_of_reaction_system is not null and severity_of_reaction_valueset_id is not null))
check ((route_of_exposure_code is null and route_of_exposure_system is null and route_of_exposure_valueset_id is null) or (route_of_exposure is not null and route_of_exposure_code is not null and route_of_exposure_system is not null and route_of_exposure_valueset_id is not null))
```

## References

| Columns | Target | On delete |
|---|---|---|
| `specific_substance_valueset_id, specific_substance_code, specific_substance_system, specific_substance` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `certainty_valueset_id, certainty_code, certainty_system, certainty` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `manifestation_valueset_id, manifestation_code, manifestation_system, manifestation` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `severity_of_reaction_valueset_id, severity_of_reaction_code, severity_of_reaction_system, severity_of_reaction` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `route_of_exposure_valueset_id, route_of_exposure_code, route_of_exposure_system, route_of_exposure` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Referenced by

- [`adverse_reaction_event_reaction_details`](/docs/tables/adverse_reaction_event_reaction_details) via `adverse_reaction_event_id`
- [`adverse_reaction_event_information_source`](/docs/tables/adverse_reaction_event_information_source) via `adverse_reaction_event_id`
- [`adverse_reaction_monitoring`](/docs/tables/adverse_reaction_monitoring) via `reaction_event`
- [`adverse_reaction_risk_reaction_event_summary`](/docs/tables/adverse_reaction_risk_reaction_event_summary) via `adverse_reaction_event_id`

## Child tables

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

### `adverse_reaction_event_reaction_details`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `adverse_reaction_event_id` | `uuid` → [`adverse_reaction_event`](/docs/tables/adverse_reaction_event) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `anatomical_location_id` | `uuid` | yes | — | — |
| `anatomical_location_relative_id` | `uuid` | yes | — | — |
| `attachment_id` | `uuid` | yes | — | — |
| `ctcae_id` | `uuid` | yes | — | — |
| `symptom_sign_id` | `uuid` | yes | — | — |

#### Constraints

```sql
check (num_nonnulls(anatomical_location_id, anatomical_location_relative_id, attachment_id, ctcae_id, symptom_sign_id) = 1)
```

#### Unique

- `adverse_reaction_event_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `adverse_reaction_event_id` | [`adverse_reaction_event`](/docs/tables/adverse_reaction_event) | cascade |
| `anatomical_location_id` | [`anatomical_location`](/docs/tables/anatomical_location) | no action |
| `anatomical_location_relative_id` | [`anatomical_location_relative`](/docs/tables/anatomical_location_relative) | no action |
| `attachment_id` | [`attachment`](/docs/tables/attachment) | restrict |
| `ctcae_id` | [`ctcae`](/docs/tables/ctcae) | no action |
| `symptom_sign_id` | [`symptom_sign`](/docs/tables/symptom_sign) | no action |

#### Indexes

- `adverse_reaction_event_reaction_details_anatomical_locat_e49822` on `anatomical_location_id`
- `adverse_reaction_event_reaction_details_anatomical_locat_aa1ffa` on `anatomical_location_relative_id`
- `adverse_reaction_event_reaction_details_attachment_id_idx` on `attachment_id`
- `adverse_reaction_event_reaction_details_ctcae_id_idx` on `ctcae_id`
- `adverse_reaction_event_reaction_details_symptom_sign_id_idx` on `symptom_sign_id`

### `adverse_reaction_event_information_source`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `adverse_reaction_event_id` | `uuid` → [`adverse_reaction_event`](/docs/tables/adverse_reaction_event) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `organization_id` | `uuid` | yes | — | — |
| `person_id` | `uuid` | yes | — | — |

#### Constraints

```sql
check (num_nonnulls(organization_id, person_id) = 1)
```

#### Unique

- `adverse_reaction_event_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `adverse_reaction_event_id` | [`adverse_reaction_event`](/docs/tables/adverse_reaction_event) | cascade |
| `organization_id` | [`organization`](/docs/tables/organization) | no action |
| `person_id` | [`person`](/docs/tables/person) | no action |

#### Indexes

- `adverse_reaction_event_information_source_organization_id_idx` on `organization_id`
- `adverse_reaction_event_information_source_person_id_idx` on `person_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-CLUSTER.adverse_reaction_event.v1/certainty` | 3 |
| `org.openehr::openEHR-EHR-CLUSTER.adverse_reaction_event.v1/severity_of_reaction` | 3 |