Schema reference / Tables / view MDX source

height

Height, or body length, is measured from crown of head to sole of foot.

Purpose. To record the length of the body from crown of head to sole of foot of an individual - either measured or approximated, and either in a standing or recumbent position.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.height.v2`	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.	—
`event_type`	`text`	yes	null represents any_event	—
`height_length_magnitude` `height_length_units`	quantity `numeric`, `text`	yes	Height/Length	`/data[at0001]/events[at0002]/data[at0003]/items[at0004]`
`comment`	`text`	yes	Comment	`/data[at0001]/events[at0002]/data[at0003]/items[at0018]`
`position` `position_code` `position_system` `position_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Position	`/data[at0001]/events[at0002]/state[at0013]/items[at0014]`
`confounding_factors`	`text`	yes	Confounding factors	`/data[at0001]/events[at0002]/state[at0013]/items[at0019]`
`device`	`uuid`	yes	Device	`/protocol[at0007]/items[at0011]`

Constraints

check ((height_length_magnitude is null and height_length_units is null) or (height_length_magnitude is not null and height_length_units is not null))
check (height_length_magnitude is null or (height_length_units = 'cm' and height_length_magnitude between 0 and 1000) or (height_length_units = '[in_i]' and height_length_magnitude between 0 and 250))
check ((position_code is null and position_system is null and position_valueset_id is null and position is null) or (position is not null and position_code is not null and position_system is not null and position_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
`position_valueset_id, position_code, position_system, position`	`valueset_code`	restrict
`device`	`device`	no action

Indexes

height_form_id_idx on form_id
height_device_idx on device

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-OBSERVATION.height.v2/position`	2