Schema reference / Tables / view MDX source

pregnancy_care_context

The current pregnancy care context of an individual, used to support safe and appropriate clinical decision-making.

Purpose. To record the level of pregnancy-related precautions and care requirements applicable to an individual, as the basis for safe and appropriate clinical decision-making.

Source

Model	Leg	Role
`openEHR-EHR-EVALUATION.pregnancy_care_context.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_context` `care_context_code` `care_context_system` `care_context_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Care context	`/data[at0001]/items[at0002]`
`applicable_from`	`date`	yes	Applicable from	`/data[at0001]/items[at0008]`
`applicable_until`	`date`	yes	Applicable until	`/data[at0001]/items[at0009]`
`review_date`	`date`	yes	Review date	`/data[at0001]/items[at0010]`
`comment`	`text`	yes	Comment	`/data[at0001]/items[at0012]`
`last_updated`	`timestamptz`	yes	Last updated	`/protocol[at0013]/items[at0015]`

Constraints

check ((care_context_code is null and care_context_system is null and care_context_valueset_id is null) or (care_context is not null and care_context_code is not null and care_context_system is not null and care_context_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_context_valueset_id, care_context_code, care_context_system, care_context`	`valueset_code`	restrict

Indexes

pregnancy_care_context_form_id_idx on form_id

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-EVALUATION.pregnancy_care_context.v0/care_context`	5