Schema reference / Tables / view MDX source

body_weight

Measurement of the body weight of an individual.

Purpose. To record the body weight of an individual - both actual and approximate.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.body_weight.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	—
`weight_magnitude` `weight_units`	quantity `numeric`, `text`	yes	Weight	`/data[at0002]/events[at0003]/data[at0001]/items[at0004]`
`comment`	`text`	yes	Comment	`/data[at0002]/events[at0003]/data[at0001]/items[at0024]`
`state_of_dress` `state_of_dress_code` `state_of_dress_system` `state_of_dress_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	State of dress	`/data[at0002]/events[at0003]/state[at0008]/items[at0009]`
`confounding_factors`	`text`	yes	Confounding factors	`/data[at0002]/events[at0003]/state[at0008]/items[at0025]`
`device`	`uuid`	yes	Device	`/protocol[at0015]/items[at0020]`

Constraints

check ((weight_magnitude is null and weight_units is null) or (weight_magnitude is not null and weight_units is not null))
check (weight_magnitude is null or (weight_units = 'kg' and weight_magnitude between 0 and 1000) or (weight_units = '[lb_av]' and weight_magnitude between 0 and 2000) or (weight_units = 'g' and weight_magnitude between 0 and 1000000))
check ((state_of_dress_code is null and state_of_dress_system is null and state_of_dress_valueset_id is null and state_of_dress is null) or (state_of_dress is not null and state_of_dress_code is not null and state_of_dress_system is not null and state_of_dress_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
`state_of_dress_valueset_id, state_of_dress_code, state_of_dress_system, state_of_dress`	`valueset_code`	restrict
`device`	`device`	no action

Indexes

body_weight_form_id_idx on form_id
body_weight_device_idx on device

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-OBSERVATION.body_weight.v2/state_of_dress`	5