Schema reference / Tables / view MDX source
social_summary
Summary information about social circumstances or experiences that may have a potential impact on an individual's health.
Summary information about social circumstances or experiences that may have a potential impact on an individual's health.
Purpose. To record a narrative summary about social circumstances or experiences that may have a potential impact on an individual's health, and to provide a framework in which to nest detailed CLUSTER archetypes, each of which will describe the various aspects of social circumstances or experiences in detail.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-EVALUATION.social_summary.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. | — |
summary | text | yes | Summary | /data[at0001]/items[at0002] |
last_updated | timestamptz | yes | Last updated | /protocol[at0004]/items[at0006] |
Unique
form_block_id
References
| Columns | Target | On delete |
|---|---|---|
form_id | form | cascade |
form_id, form_block_id | form_block | cascade |
Indexes
social_summary_form_id_idxonform_id