---
title: "adverse_reaction_risk"
description: "Clinical assessment of the propensity for an individual to experience a harmful or undesirable physiological response if exposed, or re-exposed, to a substance."
---

Clinical assessment of the propensity for an individual to experience a harmful or undesirable physiological response if exposed, or re-exposed, to a substance.

**Purpose.** To record the clinical assessment of the propensity for an individual to experience an adverse reaction if exposed, or re-exposed, to a specified substance or class of substances.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-EVALUATION.adverse_reaction_risk.v2` | openEHR | defines this table |

## Columns

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `form_id` | `uuid` → [`form`](/docs/tables/form) | no | The form this entry was recorded on. | — |
| `form_block_id` | `uuid` | yes | The block within the form, when the entry is bound to one. | — |
| `substance`<br />`substance_code`<br />`substance_system`<br />`substance_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Substance | `/data[at0001]/items[at0002]` |
| `active_inactive_status`<br />`active_inactive_status_code`<br />`active_inactive_status_system`<br />`active_inactive_status_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Active/inactive status | `/data[at0001]/items[at0130]` |
| `verification_status`<br />`verification_status_code`<br />`verification_status_system`<br />`verification_status_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Verification status | `/data[at0001]/items[at0063]` |
| `criticality`<br />`criticality_code`<br />`criticality_system`<br />`criticality_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Criticality | `/data[at0001]/items[at0101]` |
| `category`<br />`category_code`<br />`category_system`<br />`category_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Category | `/data[at0001]/items[at0120]` |
| `onset_of_last_reaction` | `timestamptz` | yes | Onset of last reaction | `/data[at0001]/items[at0117]` |
| `onset_of_first_reaction` | `timestamptz` | yes | Onset of first reaction | `/data[at0001]/items[at0133]` |
| `reaction_mechanism`<br />`reaction_mechanism_code`<br />`reaction_mechanism_system`<br />`reaction_mechanism_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Reaction mechanism | `/data[at0001]/items[at0058]` |
| `comment` | `text` | yes | Comment | `/data[at0001]/items[at0006]` |
| `last_updated` | `timestamptz` | yes | Last updated | `/protocol[at0042]/items[at0062]` |
| `supporting_clinical_record_information` | `text` | yes | Supporting clinical record information | `/protocol[at0042]/items[at0047]` |

## Constraints

```sql
check ((substance_code is null and substance_system is null and substance_valueset_id is null) or (substance is not null and substance_code is not null and substance_system is not null and substance_valueset_id is not null))
check ((active_inactive_status_code is null and active_inactive_status_system is null and active_inactive_status_valueset_id is null) or (active_inactive_status is not null and active_inactive_status_code is not null and active_inactive_status_system is not null and active_inactive_status_valueset_id is not null))
check ((verification_status_code is null and verification_status_system is null and verification_status_valueset_id is null) or (verification_status is not null and verification_status_code is not null and verification_status_system is not null and verification_status_valueset_id is not null))
check ((criticality_code is null and criticality_system is null and criticality_valueset_id is null) or (criticality is not null and criticality_code is not null and criticality_system is not null and criticality_valueset_id is not null))
check ((category_code is null and category_system is null and category_valueset_id is null) or (category is not null and category_code is not null and category_system is not null and category_valueset_id is not null))
check ((reaction_mechanism_code is null and reaction_mechanism_system is null and reaction_mechanism_valueset_id is null) or (reaction_mechanism is not null and reaction_mechanism_code is not null and reaction_mechanism_system is not null and reaction_mechanism_valueset_id is not null))
```

## Unique

- `form_block_id`

## References

| Columns | Target | On delete |
|---|---|---|
| `form_id` | [`form`](/docs/tables/form) | cascade |
| `form_id, form_block_id` | [`form_block`](/docs/tables/form_block) | cascade |
| `substance_valueset_id, substance_code, substance_system, substance` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `active_inactive_status_valueset_id, active_inactive_status_code, active_inactive_status_system, active_inactive_status` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `verification_status_valueset_id, verification_status_code, verification_status_system, verification_status` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `criticality_valueset_id, criticality_code, criticality_system, criticality` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `category_valueset_id, category_code, category_system, category` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `reaction_mechanism_valueset_id, reaction_mechanism_code, reaction_mechanism_system, reaction_mechanism` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Referenced by

- [`adverse_reaction_risk_reaction_event_summary`](/docs/tables/adverse_reaction_risk_reaction_event_summary) via `adverse_reaction_risk_id`

## Indexes

- `adverse_reaction_risk_form_id_idx` on `form_id`

## Child tables

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

### `adverse_reaction_risk_reaction_event_summary`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `adverse_reaction_risk_id` | `uuid` → [`adverse_reaction_risk`](/docs/tables/adverse_reaction_risk) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `adverse_reaction_event_id` | `uuid` | no | Reaction event summary | `/data[at0001]/items[at0129]` |

#### Unique

- `adverse_reaction_risk_id, position`
- `adverse_reaction_risk_id, adverse_reaction_event_id`

#### References

| Columns | Target | On delete |
|---|---|---|
| `adverse_reaction_risk_id` | [`adverse_reaction_risk`](/docs/tables/adverse_reaction_risk) | cascade |
| `adverse_reaction_event_id` | [`adverse_reaction_event`](/docs/tables/adverse_reaction_event) | no action |

#### Indexes

- `adverse_reaction_risk_reaction_event_summary_adverse_rea_dc1156` on `adverse_reaction_event_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-EVALUATION.adverse_reaction_risk.v2/active_inactive_status` | 2 |
| `org.openehr::openEHR-EHR-EVALUATION.adverse_reaction_risk.v2/category` | 3 |
| `org.openehr::openEHR-EHR-EVALUATION.adverse_reaction_risk.v2/criticality` | 3 |
| `org.openehr::openEHR-EHR-EVALUATION.adverse_reaction_risk.v2/reaction_mechanism` | 3 |
| `org.openehr::openEHR-EHR-EVALUATION.adverse_reaction_risk.v2/verification_status` | 3 |

