body_segment_length

Measurement of the distance between two points of surface anatomy.

Measurement of the distance between two points of surface anatomy.

Purpose. To record the measurement of the distance between two 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 ((length_magnitude is null and length_units is null) or (length_magnitude is not null and length_units is not null))
check (length_magnitude is null or (length_units = 'cm' and length_magnitude >= 0) or (length_units = '[in_i]' and length_magnitude >= 0) or (length_units = 'mm' and length_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_code is null and measurement_origin_system is null and measurement_origin_valueset_id is null) or (measurement_origin is not null and measurement_origin_code is not null and measurement_origin_system is not null and measurement_origin_valueset_id is not null))
check ((measurement_endpoint_code is null and measurement_endpoint_system is null and measurement_endpoint_valueset_id is null) or (measurement_endpoint is not null and measurement_endpoint_code is not null and measurement_endpoint_system is not null and measurement_endpoint_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• body_segment_length_measuring_device via body_segment_length_id
• body_segment_length_structured_origin via body_segment_length_id
• body_segment_length_structured_endpoint via body_segment_length_id

Indexes

• body_segment_length_form_id_idx on form_id

Child tables

3 tables hang off body_segment_length, one row per repetition.

body_segment_length_measuring_device

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

Unique

• body_segment_length_id, position
• body_segment_length_id, device_id

References

Indexes

• body_segment_length_measuring_device_device_id_idx on device_id

body_segment_length_structured_origin

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

Unique

• body_segment_length_id, position
• body_segment_length_id, anatomical_location_id

References

Indexes

• body_segment_length_structured_origin_anatomical_locatio_620ef3 on anatomical_location_id

body_segment_length_structured_endpoint

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

Unique

• body_segment_length_id, position
• body_segment_length_id, anatomical_location_id

References

Indexes

• body_segment_length_structured_endpoint_anatomical_locat_2708d2 on anatomical_location_id

Value sets