Schema reference / Tables / view MDX source

education_summary

Summary or persistent information about an individual's current and past education or training.

Purpose. To record summary information about an individual's current and past education or training, which provides an overview of their educational background.

Source

Model	Leg	Role
`openEHR-EHR-EVALUATION.education_summary.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.	—
`description`	`text`	yes	Description	`/data[at0001]/items[at0018]`
`age_started`	`interval`	yes	Age started	`/data[at0001]/items[at0003]`
`age_ended`	`interval`	yes	Age ended	`/data[at0001]/items[at0031]`
`highest_level_completed` `highest_level_completed_code` `highest_level_completed_system` `highest_level_completed_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Highest level completed	`/data[at0001]/items[at0002]`
`comment`	`text`	yes	Comment	`/data[at0001]/items[at0007]`
`last_updated`	`timestamptz`	yes	Last updated	`/protocol[at0026]/items[at0028]`

Constraints

check ((highest_level_completed_code is null and highest_level_completed_system is null and highest_level_completed_valueset_id is null) or (highest_level_completed is not null and highest_level_completed_code is not null and highest_level_completed_system is not null and highest_level_completed_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
`highest_level_completed_valueset_id, highest_level_completed_code, highest_level_completed_system, highest_level_completed`	`valueset_code`	restrict

Indexes

education_summary_form_id_idx on form_id