body_temperature

A measurement of the body temperature, which is a surrogate for the core body temperature of the individual.

A measurement of the body temperature, which is a surrogate for the core body temperature of the individual.

Purpose. To record the measured temperature of a person - as a surrogate for the core body temperature.

Source

Columns

Constraints

check ((temperature_magnitude is null and temperature_units is null) or (temperature_magnitude is not null and temperature_units is not null))
check (temperature_magnitude is null or (temperature_units = 'Cel' and temperature_magnitude between 0 and 100) or (temperature_units = '[degF]' and temperature_magnitude between 30 and 200))
check ((body_exposure_code is null and body_exposure_system is null and body_exposure_valueset_id is null) or (body_exposure is not null and body_exposure_code is not null and body_exposure_system is not null and body_exposure_valueset_id is not null))
check (day_of_menstrual_cycle is null or day_of_menstrual_cycle >= 1)
check ((location_of_measurement_code is null and location_of_measurement_system is null and location_of_measurement_valueset_id is null) or (location_of_measurement is not null and location_of_measurement_code is not null and location_of_measurement_system is not null and location_of_measurement_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• body_temperature_structured_measurement_location via body_temperature_id

Indexes

• body_temperature_form_id_idx on form_id
• body_temperature_device_idx on device

Child tables

1 table hang off body_temperature, one row per repetition.

body_temperature_structured_measurement_location

Child table — one row per repetition, deleted with its parent.

Unique

• body_temperature_id, position
• body_temperature_id, anatomical_location_id

References

Indexes

• body_temperature_structured_measurement_location_anatomi_55ef2f on anatomical_location_id

Value sets