Schema reference / Tables / view MDX source

fluid_balance

The difference between fluid input and output during a specified interval of time.

Purpose. To record the cumulative or total amounts of fluid input and output, plus an estimation of the fluid balance status of an individual over specified intervals of time. To record the estimation of the difference between fluid input and output during a specified interval of time.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.fluid_balance.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.	—
`event_type`	`text`	yes	null represents any_event	—
`total_input_magnitude` `total_input_units`	quantity `numeric`, `text`	yes	Total input	`/data[at0001]/events[at0002]/data[at0003]/items[at0005]`
`total_output_magnitude` `total_output_units`	quantity `numeric`, `text`	yes	Total output	`/data[at0001]/events[at0002]/data[at0003]/items[at0006]`
`insensible_loss_magnitude` `insensible_loss_units`	quantity `numeric`, `text`	yes	Insensible loss	`/data[at0001]/events[at0002]/data[at0003]/items[at0004]`
`fluid_balance_magnitude` `fluid_balance_units`	quantity `numeric`, `text`	yes	Fluid balance	`/data[at0001]/events[at0002]/data[at0003]/items[at0007]`
`insensible_loss_formula`	`text`	yes	Insensible loss formula	`/protocol[at0009]/items[at0010]`

Constraints

check ((total_input_magnitude is null and total_input_units is null) or (total_input_magnitude is not null and total_input_units is not null))
check (total_input_magnitude is null or (total_input_units = 'ml' and total_input_magnitude >= 0) or (total_input_units = 'l' and total_input_magnitude >= 0) or (total_input_units = '[foz_us]' and total_input_magnitude >= 0))
check ((total_output_magnitude is null and total_output_units is null) or (total_output_magnitude is not null and total_output_units is not null))
check (total_output_magnitude is null or (total_output_units = 'ml' and total_output_magnitude >= 0) or (total_output_units = 'l' and total_output_magnitude >= 0) or (total_output_units = '[foz_us]' and total_output_magnitude >= 0))
check ((insensible_loss_magnitude is null and insensible_loss_units is null) or (insensible_loss_magnitude is not null and insensible_loss_units is not null))
check (insensible_loss_magnitude is null or (insensible_loss_units = 'ml' and insensible_loss_magnitude >= 0) or (insensible_loss_units = 'l' and insensible_loss_magnitude >= 0) or (insensible_loss_units = '[foz_us]' and insensible_loss_magnitude >= 0))
check ((fluid_balance_magnitude is null and fluid_balance_units is null) or (fluid_balance_magnitude is not null and fluid_balance_units is not null))

Unique

form_block_id

References

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

Indexes

fluid_balance_form_id_idx on form_id