Schema reference / Tables / view MDX source
recommendation
A suggestion, advice or proposal for clinical management.
A suggestion, advice or proposal for clinical management.
Purpose. To record a suggestion, advice or proposal for clinical management at a specific time.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-EVALUATION.recommendation.v2 | 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. | — |
topic | text | yes | Topic | /data[at0001]/items[at0006] |
recommendationrecommendation_coderecommendation_systemrecommendation_valueset_id | coded texttext, text, text, text | yes | Recommendation | /data[at0001]/items[at0002] |
rationale | text | yes | Rationale | /data[at0001]/items[at0003] |
last_updated | timestamptz | yes | Last updated | /protocol[at0004]/items[at0007] |
Constraints
check ((recommendation_code is null and recommendation_system is null and recommendation_valueset_id is null) or (recommendation is not null and recommendation_code is not null and recommendation_system is not null and recommendation_valueset_id is not null))Unique
form_block_id
References
| Columns | Target | On delete |
|---|---|---|
form_id | form | cascade |
form_id, form_block_id | form_block | cascade |
recommendation_valueset_id, recommendation_code, recommendation_system, recommendation | valueset_code | restrict |
Indexes
recommendation_form_id_idxonform_id