Schema reference / Tables / view MDX source

waist_circumference

The measurement of the distance around the waist.

Purpose. To record the measurement of the circumference of the waist.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.waist_circumference.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.	—
`waist_circumference_magnitude` `waist_circumference_units`	quantity `numeric`, `text`	yes	Waist circumference	`/data[at0001]/events[at0010]/data[at0003]/items[at0004]`
`comment`	`text`	yes	Comment	`/data[at0001]/events[at0010]/data[at0003]/items[at0007]`
`confounding_factors`	`text`	yes	Confounding factors	`/data[at0001]/events[at0010]/state[at0008]/items[at0009]`
`method` `method_code` `method_system` `method_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Method	`/protocol[at0005]/items[at0013]`
`device`	`uuid`	yes	Device	`/protocol[at0005]/items[at0006]`

Constraints

check ((waist_circumference_magnitude is null and waist_circumference_units is null) or (waist_circumference_magnitude is not null and waist_circumference_units is not null))
check (waist_circumference_magnitude is null or (waist_circumference_units = 'cm' and waist_circumference_magnitude between 0 and 500) or (waist_circumference_units = '[in_i]' and waist_circumference_magnitude between 0 and 400))
check ((method_code is null and method_system is null and method_valueset_id is null) or (method is not null and method_code is not null and method_system is not null and method_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
`method_valueset_id, method_code, method_system, method`	`valueset_code`	restrict
`device`	`device`	no action

Indexes

waist_circumference_form_id_idx on form_id
waist_circumference_device_idx on device