Schema reference / Tables / view MDX source
clinical_pathway_order
An order for a standardised care process for a specific condition or treatment.
An order for a standardised care process for a specific condition or treatment.
Purpose. To order the initiation of a standardised care process for a specific condition or treatment.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-INSTRUCTION.clinical_pathway_order.v0 | 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. | — |
care_pathway_namecare_pathway_name_codecare_pathway_name_systemcare_pathway_name_valueset_id | coded texttext, text, text, text | yes | Care pathway name | /activities[at0001]/description[at0002]/items[at0003] |
description | text | yes | Description | /activities[at0001]/description[at0002]/items[at0005] |
clinical_indicationclinical_indication_codeclinical_indication_systemclinical_indication_valueset_id | coded texttext, text, text, text | yes | Clinical indication | /activities[at0001]/description[at0002]/items[at0014] |
start_date_time | timestamptz | yes | Start date/time | /activities[at0001]/description[at0002]/items[at0004] |
end_date_time | timestamptz | yes | End date/time | /activities[at0001]/description[at0002]/items[at0015] |
comment | text | yes | Comment | /activities[at0001]/description[at0002]/items[at0013] |
review_date | timestamptz | yes | Review date | /protocol[at0007]/items[at0016] |
Constraints
check ((care_pathway_name_code is null and care_pathway_name_system is null and care_pathway_name_valueset_id is null) or (care_pathway_name is not null and care_pathway_name_code is not null and care_pathway_name_system is not null and care_pathway_name_valueset_id is not null))
check ((clinical_indication_code is null and clinical_indication_system is null and clinical_indication_valueset_id is null) or (clinical_indication is not null and clinical_indication_code is not null and clinical_indication_system is not null and clinical_indication_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 |
care_pathway_name_valueset_id, care_pathway_name_code, care_pathway_name_system, care_pathway_name | valueset_code | restrict |
clinical_indication_valueset_id, clinical_indication_code, clinical_indication_system, clinical_indication | valueset_code | restrict |
Referenced by
clinical_pathway_order_knowledge_base_referenceviaclinical_pathway_order_id
Indexes
clinical_pathway_order_form_id_idxonform_id
Child tables
1 table hang off clinical_pathway_order, one row per repetition.
clinical_pathway_order_knowledge_base_reference
Child table — one row per repetition, deleted with its parent.
| Column | Type | Null | Description | Source |
|---|---|---|---|---|
id | uuid primary key | no | Primary key. | — |
clinical_pathway_order_id | uuid → clinical_pathway_order | no | — | — |
position | integer | no | Order of this row within its parent, from zero. | — |
knowledge_base_reference_id | uuid | no | Knowledge base reference | /activities[at0001]/description[at0002]/items[at0017] |
Unique
clinical_pathway_order_id, positionclinical_pathway_order_id, knowledge_base_reference_id
References
| Columns | Target | On delete |
|---|---|---|
clinical_pathway_order_id | clinical_pathway_order | cascade |
knowledge_base_reference_id | knowledge_base_reference | no action |
Indexes
clinical_pathway_order_knowledge_base_reference_knowledg_edf211onknowledge_base_reference_id