Schema reference / Tables / view MDX source

hip_circumference

The measurement of the distance around the hips.

Purpose. To record the measurement of the distance around the hips.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.hip_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.	—
`hip_circumference_magnitude` `hip_circumference_units`	quantity `numeric`, `text`	yes	Hip 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]`
`device`	`uuid`	yes	Device	`/protocol[at0005]/items[at0006]`

Constraints

check ((hip_circumference_magnitude is null and hip_circumference_units is null) or (hip_circumference_magnitude is not null and hip_circumference_units is not null))
check (hip_circumference_magnitude is null or (hip_circumference_units = 'cm' and hip_circumference_magnitude between 0 and 400) or (hip_circumference_units = '[in_i]' and hip_circumference_magnitude between 0 and 150))

Unique

form_block_id

References

Columns	Target	On delete
`form_id`	`form`	cascade
`form_id, form_block_id`	`form_block`	cascade
`device`	`device`	no action

Indexes

hip_circumference_form_id_idx on form_id
hip_circumference_device_idx on device