story
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 | 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 | cascade |
form_id, form_block_id | form_block | cascade |
Referenced by
story_structured_detailviastory_id
Indexes
story_form_id_idxonform_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 | 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, positionstory_id, symptom_sign_id
References
| Columns | Target | On delete |
|---|---|---|
story_id | story | cascade |
symptom_sign_id | symptom_sign | no action |
Indexes
story_structured_detail_symptom_sign_id_idxonsymptom_sign_id