---
title: "clinical_evidence"
description: "Details about findings that support a clinical assertion."
---

Details about findings that support a clinical assertion.

**Purpose.** To record an explicit finding in support of a clinical assertion, such as a problem/diagnosis, adverse reaction risk, health risk assessment, or contraindication.

## Source

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

## Columns

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `evidence`<br />`evidence_code`<br />`evidence_system`<br />`evidence_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Evidence | `/items[at0003]` |
| `summary` | `text` | yes | Summary | `/items[at0004]` |
| `result`<br />`result_code`<br />`result_system`<br />`result_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Result | `/items[at0005]` |
| `date_time_of_result` | `timestamptz` | yes | Date/time of result | `/items[at0006]` |
| `date_time_clinically_relevant` | `timestamptz` | yes | Date/time clinically relevant | `/items[at0026]` |
| `method`<br />`method_code`<br />`method_system`<br />`method_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Method | `/items[at0022]` |
| `method_description` | `text` | yes | Method description | `/items[at0001]` |
| `comment` | `text` | yes | Comment | `/items[at0023]` |

## Constraints

```sql
check ((evidence_code is null and evidence_system is null and evidence_valueset_id is null) or (evidence is not null and evidence_code is not null and evidence_system is not null and evidence_valueset_id is not null))
check ((result_code is null and result_system is null and result_valueset_id is null) or (result is not null and result_code is not null and result_system is not null and result_valueset_id is not null))
check ((method_code is null and method_system is null and method_valueset_id is null) or (method is not null and method_code is not null and method_system is not null and method_valueset_id is not null))
```

## References

| Columns | Target | On delete |
|---|---|---|
| `evidence_valueset_id, evidence_code, evidence_system, evidence` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `result_valueset_id, result_code, result_system, result` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `method_valueset_id, method_code, method_system, method` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Referenced by

- [`clinical_evidence_multimedia_representation`](/docs/tables/clinical_evidence_multimedia_representation) via `clinical_evidence_id`
- [`differential_diagnoses_per_differential_clinical_evidence`](/docs/tables/differential_diagnoses_per_differential_clinical_evidence) via `clinical_evidence_id`
- [`intraocular_pressure_additional_details`](/docs/tables/intraocular_pressure_additional_details) via `clinical_evidence_id`
- [`precaution_additional_details`](/docs/tables/precaution_additional_details) via `clinical_evidence_id`

## Child tables

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

### `clinical_evidence_multimedia_representation`

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

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

#### Unique

- `clinical_evidence_id, position`
- `clinical_evidence_id, attachment_id`

#### References

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

#### Indexes

- `clinical_evidence_multimedia_representation_attachment_id_idx` on `attachment_id`