Schema reference / Tables / view MDX source
contraindication
A clinical intervention (including, but not limited to, use of a treatment or performance of a test or procedure) that should not be carried out due to the likelihood, or possibil…
A clinical intervention (including, but not limited to, use of a treatment or performance of a test or procedure) that should not be carried out due to the likelihood, or possibility, of harm being caused to an individual.
Purpose. To record a contraindication for a clinical intervention (including, but not limited to, a treatment, test or procedure) that should not be carried out due to the likelihood, or possibility, of harm being caused to an individual.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-EVALUATION.contraindication.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. | — |
contraindicated_interventioncontraindicated_intervention_codecontraindicated_intervention_systemcontraindicated_intervention_valueset_id | coded texttext, text, text, text | yes | Contraindicated intervention | /data[at0001]/items[at0002] |
statusstatus_codestatus_systemstatus_valueset_id | coded texttext, text, text, text | yes | Status | /data[at0001]/items[at0014] |
criticalitycriticality_codecriticality_systemcriticality_valueset_id | coded texttext, text, text, text | yes | Criticality | /data[at0001]/items[at0007] |
clinical_indicationclinical_indication_codeclinical_indication_systemclinical_indication_valueset_id | coded texttext, text, text, text | yes | Clinical indication | /data[at0001]/items[at0021] |
rationale | text | yes | Rationale | /data[at0001]/items[at0003] |
categorycategory_codecategory_systemcategory_valueset_id | coded texttext, text, text, text | yes | Category | /data[at0001]/items[at0013] |
comment | text | yes | Comment | /data[at0001]/items[at0008] |
valid_period_start | timestamptz | yes | Valid period start | /protocol[at0006]/items[at0022] |
valid_period_end | timestamptz | yes | Valid period end | /protocol[at0006]/items[at0023] |
review_date | timestamptz | yes | Review date | /protocol[at0006]/items[at0009] |
last_updated | timestamptz | yes | Last updated | /protocol[at0006]/items[at0004] |
Constraints
check ((contraindicated_intervention_code is null and contraindicated_intervention_system is null and contraindicated_intervention_valueset_id is null) or (contraindicated_intervention is not null and contraindicated_intervention_code is not null and contraindicated_intervention_system is not null and contraindicated_intervention_valueset_id is not null))
check ((status_code is null and status_system is null and status_valueset_id is null) or (status is not null and status_code is not null and status_system is not null and status_valueset_id is not null))
check ((criticality_code is null and criticality_system is null and criticality_valueset_id is null and criticality is null) or (criticality is not null and criticality_code is not null and criticality_system is not null and criticality_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))
check ((category_code is null and category_system is null and category_valueset_id is null) or (category is not null and category_code is not null and category_system is not null and category_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 |
contraindicated_intervention_valueset_id, contraindicated_intervention_code, contraindicated_intervention_system, contraindicated_intervention | valueset_code | restrict |
status_valueset_id, status_code, status_system, status | valueset_code | restrict |
criticality_valueset_id, criticality_code, criticality_system, criticality | valueset_code | restrict |
clinical_indication_valueset_id, clinical_indication_code, clinical_indication_system, clinical_indication | valueset_code | restrict |
category_valueset_id, category_code, category_system, category | valueset_code | restrict |
Indexes
contraindication_form_id_idxonform_id
Value sets
| Value set | Codes |
|---|---|
org.openehr::openEHR-EHR-EVALUATION.contraindication.v1/criticality | 3 |
org.openehr::openEHR-EHR-EVALUATION.contraindication.v1/status | 5 |