body_segment_circumference

Measurement of the distance around an identified part of the body, usually identified in relation to points of surface anatomy.

Measurement of the distance around an identified part of the body, usually identified in relation to points of surface anatomy.

Purpose. To record the measurement of the distance around a part of the body, usually identified in relation to points of surface anatomy.

Source

Columns

Constraints

check ((body_segment_name_code is null and body_segment_name_system is null and body_segment_name_valueset_id is null) or (body_segment_name is not null and body_segment_name_code is not null and body_segment_name_system is not null and body_segment_name_valueset_id is not null))
check ((laterality_code is null and laterality_system is null and laterality_valueset_id is null and laterality is null) or (laterality is not null and laterality_code is not null and laterality_system is not null and laterality_valueset_id is not null))
check ((circumference_magnitude is null and circumference_units is null) or (circumference_magnitude is not null and circumference_units is not null))
check (circumference_magnitude is null or (circumference_units = 'cm' and circumference_magnitude >= 0) or (circumference_units = '[in_i]' and circumference_magnitude >= 0) or (circumference_units = 'mm' and circumference_magnitude >= 0))
check ((body_position_code is null and body_position_system is null and body_position_valueset_id is null) or (body_position is not null and body_position_code is not null and body_position_system is not null and body_position_valueset_id is not null))
check ((measurement_origin_endpoint_code is null and measurement_origin_endpoint_system is null and measurement_origin_endpoint_valueset_id is null) or (measurement_origin_endpoint is not null and measurement_origin_endpoint_code is not null and measurement_origin_endpoint_system is not null and measurement_origin_endpoint_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• body_segment_circumference_measuring_device via body_segment_circumference_id
• body_segment_circumference_structured_origin_endpoint via body_segment_circumference_id

Indexes

• body_segment_circumference_form_id_idx on form_id

Child tables

2 tables hang off body_segment_circumference, one row per repetition.

body_segment_circumference_measuring_device

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

Unique

• body_segment_circumference_id, position
• body_segment_circumference_id, device_id

References

Indexes

• body_segment_circumference_measuring_device_device_id_idx on device_id

body_segment_circumference_structured_origin_endpoint

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

Unique

• body_segment_circumference_id, position
• body_segment_circumference_id, anatomical_location_id

References

Indexes

• body_segment_circumference_structured_origin_endpoint_an_12c871 on anatomical_location_id

Value sets