Schema reference / Tables / view MDX source
progress_note
Narrative description of health-related events at a specific point-in-time about an individual, specifically from the perspective of a healthcare provider.
Narrative description of health-related events at a specific point-in-time about an individual, specifically from the perspective of a healthcare provider.
Purpose. To manually synthesise and record a narrative description about health related events that are current at the time of recording, from the perspective of a healthcare provider.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-OBSERVATION.progress_note.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. | — |
progress_note | text | yes | Progress Note | /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 |
Indexes
progress_note_form_id_idxonform_id