---
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.&#xD; &#xD; 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`

