Schema reference / Tables / view MDX source

clinical_evidence

Details about findings that support a clinical assertion.

Purpose. To record an explicit finding in support of a clinical assertion, such as a problem/diagnosis, adverse reaction risk, health risk assessment, or contraindication.

Source

Model	Leg	Role
`openEHR-EHR-CLUSTER.clinical_evidence.v1`	openEHR	defines this table

Columns

Column	Type	Null	Description	Source
`id`	`uuid primary key`	no	Primary key.	—
`evidence` `evidence_code` `evidence_system` `evidence_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Evidence	`/items[at0003]`
`summary`	`text`	yes	Summary	`/items[at0004]`
`result` `result_code` `result_system` `result_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Result	`/items[at0005]`
`date_time_of_result`	`timestamptz`	yes	Date/time of result	`/items[at0006]`
`date_time_clinically_relevant`	`timestamptz`	yes	Date/time clinically relevant	`/items[at0026]`
`method` `method_code` `method_system` `method_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Method	`/items[at0022]`
`method_description`	`text`	yes	Method description	`/items[at0001]`
`comment`	`text`	yes	Comment	`/items[at0023]`

Constraints

check ((evidence_code is null and evidence_system is null and evidence_valueset_id is null) or (evidence is not null and evidence_code is not null and evidence_system is not null and evidence_valueset_id is not null))
check ((result_code is null and result_system is null and result_valueset_id is null) or (result is not null and result_code is not null and result_system is not null and result_valueset_id is not null))
check ((method_code is null and method_system is null and method_valueset_id is null) or (method is not null and method_code is not null and method_system is not null and method_valueset_id is not null))

References

Columns	Target	On delete
`evidence_valueset_id, evidence_code, evidence_system, evidence`	`valueset_code`	restrict
`result_valueset_id, result_code, result_system, result`	`valueset_code`	restrict
`method_valueset_id, method_code, method_system, method`	`valueset_code`	restrict

Referenced by

clinical_evidence_multimedia_representation via clinical_evidence_id
differential_diagnoses_per_differential_clinical_evidence via clinical_evidence_id
intraocular_pressure_additional_details via clinical_evidence_id
precaution_additional_details via clinical_evidence_id

Child tables

1 table hang off clinical_evidence, one row per repetition.

`clinical_evidence_multimedia_representation`

Child table — one row per repetition, deleted with its parent.

Column	Type	Null	Description	Source
`id`	`uuid primary key`	no	Primary key.	—
`clinical_evidence_id`	`uuid` → `clinical_evidence`	no	—	—
`position`	`integer`	no	Order of this row within its parent, from zero.	—
`attachment_id`	`uuid`	no	Multimedia representation	`/items[at0018]`

Unique

clinical_evidence_id, position
clinical_evidence_id, attachment_id

References

Columns	Target	On delete
`clinical_evidence_id`	`clinical_evidence`	cascade
`attachment_id`	`attachment`	restrict

Indexes

clinical_evidence_multimedia_representation_attachment_id_idx on attachment_id