Schema reference / Tables / view MDX source

health_education

Communication to improve health literacy and life skills.

Purpose. To record details about communication to improve health literacy and life skills.

Source

Model	Leg	Role
`openEHR-EHR-ACTION.health_education.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.	—
`topic_name` `topic_name_code` `topic_name_system` `topic_name_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Topic name	`/description[at0001]/items[at0002]`
`description`	`text`	yes	Description	`/description[at0001]/items[at0003]`
`clinical_indication` `clinical_indication_code` `clinical_indication_system` `clinical_indication_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Clinical indication	`/description[at0001]/items[at0035]`
`method`	`text`	yes	Method	`/description[at0001]/items[at0004]`
`session_number`	`integer`	yes	Session Number	`/description[at0001]/items[at0020]`
`reason`	`text`	yes	Reason	`/description[at0001]/items[at0010]`
`outcome` `outcome_code` `outcome_system` `outcome_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Outcome	`/description[at0001]/items[at0019]`
`scheduled_date_time`	`timestamptz`	yes	Scheduled date/ time	`/description[at0001]/items[at0026]`
`comment`	`text`	yes	Comment	`/description[at0001]/items[at0027]`
`requestor_order_identifier_value` `requestor_order_identifier_system`	text, text `text`, `text`	yes	Requestor order identifier	`/protocol[at0021]/items[at0030]`
`receiver_order_identifier_value` `receiver_order_identifier_system`	text, text `text`, `text`	yes	Receiver order identifier	`/protocol[at0021]/items[at0031]`

Constraints

check ((topic_name_code is null and topic_name_system is null and topic_name_valueset_id is null) or (topic_name is not null and topic_name_code is not null and topic_name_system is not null and topic_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))
check ((outcome_code is null and outcome_system is null and outcome_valueset_id is null) or (outcome is not null and outcome_code is not null and outcome_system is not null and outcome_valueset_id is not null))
check (requestor_order_identifier_system is null or requestor_order_identifier_value is not null)
check (receiver_order_identifier_system is null or receiver_order_identifier_value is not null)

Unique

form_block_id

References

Columns	Target	On delete
`form_id`	`form`	cascade
`form_id, form_block_id`	`form_block`	cascade
`topic_name_valueset_id, topic_name_code, topic_name_system, topic_name`	`valueset_code`	restrict
`clinical_indication_valueset_id, clinical_indication_code, clinical_indication_system, clinical_indication`	`valueset_code`	restrict
`outcome_valueset_id, outcome_code, outcome_system, outcome`	`valueset_code`	restrict

Indexes

health_education_form_id_idx on form_id