---
title: "story"
description: "The subjective clinical history of the subject of care as recorded directly by the subject, or reported to a clinician by the subject or a carer."
---

The subjective clinical history of the subject of care as recorded directly by the subject, or reported to a clinician by the subject or a carer.

**Purpose.** To record a narrative description of the clinical history of the subject of care and to provide a framework in which to nest detailed CLUSTER archetypes, each of which will support the narrative with additional structured detail for symptoms, health events and related topics.
 
 Use to record detail about the clinical history as reported by an individual, parent, care-giver or other party.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-OBSERVATION.story.v1` | 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. | — |
| `story` | `text` | yes | Story | `/data[at0001]/events[at0002]/data[at0003]/items[at0004]` |

## 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 |

## Referenced by

- [`story_structured_detail`](/docs/tables/story_structured_detail) via `story_id`

## Indexes

- `story_form_id_idx` on `form_id`

## Child tables

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

### `story_structured_detail`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `story_id` | `uuid` → [`story`](/docs/tables/story) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `symptom_sign_id` | `uuid` | no | Structured detail | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]` |

#### Unique

- `story_id, position`
- `story_id, symptom_sign_id`

#### References

| Columns | Target | On delete |
|---|---|---|
| `story_id` | [`story`](/docs/tables/story) | cascade |
| `symptom_sign_id` | [`symptom_sign`](/docs/tables/symptom_sign) | no action |

#### Indexes

- `story_structured_detail_symptom_sign_id_idx` on `symptom_sign_id`