Schema reference / Tables / view MDX source

functional_support_requirements

Summary information about the supports needed to enable or assist an individual in performing an activity.

Purpose. To record summary information about the supports required to enable or assist an individual to perform an activity.

Source

Model	Leg	Role
`openEHR-EHR-EVALUATION.functional_support_requirements.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.	—
`activity_name` `activity_name_code` `activity_name_system` `activity_name_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Activity name	`/data[at0001]/items[at0002]`
`support_description`	`text`	yes	Support description	`/data[at0001]/items[at0003]`
`assistive_devices_description`	`text`	yes	Assistive devices description	`/data[at0001]/items[at0025]`
`assistance_type` `assistance_type_code` `assistance_type_system` `assistance_type_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Assistance type	`/data[at0001]/items[at0005]`
`physical_assistance_type` `physical_assistance_type_code` `physical_assistance_type_system` `physical_assistance_type_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Physical assistance type	`/data[at0001]/items[at0011]`
`number_of_people`	`integer`	yes	Number of people	`/data[at0001]/items[at0018]`
`comment`	`text`	yes	Comment	`/data[at0001]/items[at0022]`
`last_updated`	`timestamptz`	yes	Last updated	`/protocol[at0004]/items[at0023]`

Constraints

check ((activity_name_code is null and activity_name_system is null and activity_name_valueset_id is null) or (activity_name is not null and activity_name_code is not null and activity_name_system is not null and activity_name_valueset_id is not null))
check ((assistance_type_code is null and assistance_type_system is null and assistance_type_valueset_id is null) or (assistance_type is not null and assistance_type_code is not null and assistance_type_system is not null and assistance_type_valueset_id is not null))
check ((physical_assistance_type_code is null and physical_assistance_type_system is null and physical_assistance_type_valueset_id is null and physical_assistance_type is null) or (physical_assistance_type is not null and physical_assistance_type_code is not null and physical_assistance_type_system is not null and physical_assistance_type_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
`activity_name_valueset_id, activity_name_code, activity_name_system, activity_name`	`valueset_code`	restrict
`assistance_type_valueset_id, assistance_type_code, assistance_type_system, assistance_type`	`valueset_code`	restrict
`physical_assistance_type_valueset_id, physical_assistance_type_code, physical_assistance_type_system, physical_assistance_type`	`valueset_code`	restrict

Referenced by

functional_support_requirements_assistive_device_details via functional_support_requirements_id
functional_support_requirements_support_person_details via functional_support_requirements_id

Indexes

functional_support_requirements_form_id_idx on form_id

Child tables

2 tables hang off functional_support_requirements, one row per repetition.

`functional_support_requirements_assistive_device_details`

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

Column	Type	Null	Description	Source
`id`	`uuid primary key`	no	Primary key.	—
`functional_support_requirements_id`	`uuid` → `functional_support_requirements`	no	—	—
`position`	`integer`	no	Order of this row within its parent, from zero.	—
`device_id`	`uuid`	no	Assistive device details	`/data[at0001]/items[at0020]`

Unique

functional_support_requirements_id, position
functional_support_requirements_id, device_id

References

Columns	Target	On delete
`functional_support_requirements_id`	`functional_support_requirements`	cascade
`device_id`	`device`	no action

Indexes

functional_support_requirements_assistive_device_details_482c7a on device_id

`functional_support_requirements_support_person_details`

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

Column	Type	Null	Description	Source
`id`	`uuid primary key`	no	Primary key.	—
`functional_support_requirements_id`	`uuid` → `functional_support_requirements`	no	—	—
`position`	`integer`	no	Order of this row within its parent, from zero.	—
`person_id`	`uuid`	no	Support person details	`/data[at0001]/items[at0019]`

Unique

functional_support_requirements_id, position
functional_support_requirements_id, person_id

References

Columns	Target	On delete
`functional_support_requirements_id`	`functional_support_requirements`	cascade
`person_id`	`person`	no action

Indexes

functional_support_requirements_support_person_details_p_e10c98 on person_id

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-EVALUATION.functional_support_requirements.v0/assistance_type`	5
`org.openehr::openEHR-EHR-EVALUATION.functional_support_requirements.v0/physical_assistance_type`	6