Schema reference / Tables / view MDX source

esas_r

Self-reporting tool used to assess the intensity of symptoms in palliative care patients.

Purpose. To record a self-reported assessment of symptoms, usually within a palliative care setting.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.esas_r.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.	—
`pain`	`integer`	yes	Pain	`/data[at0001]/events[at0002]/data[at0003]/items[at0004]`
`tiredness`	`integer`	yes	Tiredness	`/data[at0001]/events[at0002]/data[at0003]/items[at0005]`
`drowsiness`	`integer`	yes	Drowsiness	`/data[at0001]/events[at0002]/data[at0003]/items[at0006]`
`nausea`	`integer`	yes	Nausea	`/data[at0001]/events[at0002]/data[at0003]/items[at0007]`
`lack_of_appetite`	`integer`	yes	Lack of appetite	`/data[at0001]/events[at0002]/data[at0003]/items[at0008]`
`shortness_of_breath`	`integer`	yes	Shortness of breath	`/data[at0001]/events[at0002]/data[at0003]/items[at0009]`
`depression`	`integer`	yes	Depression	`/data[at0001]/events[at0002]/data[at0003]/items[at0010]`
`anxiety`	`integer`	yes	Anxiety	`/data[at0001]/events[at0002]/data[at0003]/items[at0011]`
`well_being`	`integer`	yes	Well-being	`/data[at0001]/events[at0002]/data[at0003]/items[at0012]`

Constraints

check (pain is null or pain between 0 and 10)
check (tiredness is null or tiredness between 0 and 10)
check (drowsiness is null or drowsiness between 0 and 10)
check (nausea is null or nausea between 0 and 10)
check (lack_of_appetite is null or lack_of_appetite between 0 and 10)
check (shortness_of_breath is null or shortness_of_breath between 0 and 10)
check (depression is null or depression between 0 and 10)
check (anxiety is null or anxiety between 0 and 10)
check (well_being is null or well_being between 0 and 10)

Unique

form_block_id

References

Columns	Target	On delete
`form_id`	`form`	cascade
`form_id, form_block_id`	`form_block`	cascade

Referenced by

esas_r_other_problem via esas_r_id

Indexes

esas_r_form_id_idx on form_id

Child tables

1 table hang off esas_r, one row per repetition.

`esas_r_other_problem`

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

Column	Type	Null	Description	Source
`id`	`uuid primary key`	no	Primary key.	—
`esas_r_id`	`uuid` → `esas_r`	no	—	—
`position`	`integer`	no	Order of this row within its parent, from zero.	—
`problem_name` `problem_name_code` `problem_name_system` `problem_name_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Problem name	`/data[at0001]/events[at0002]/data[at0003]/items[at0014]/items[at0016]`
`rating`	`integer`	yes	Rating	`/data[at0001]/events[at0002]/data[at0003]/items[at0014]/items[at0017]`

Constraints

check ((problem_name_code is null and problem_name_system is null and problem_name_valueset_id is null) or (problem_name is not null and problem_name_code is not null and problem_name_system is not null and problem_name_valueset_id is not null))
check (rating is null or rating between 0 and 10)

Unique

esas_r_id, position

References

Columns	Target	On delete
`esas_r_id`	`esas_r`	cascade
`problem_name_valueset_id, problem_name_code, problem_name_system, problem_name`	`valueset_code`	restrict