body_segment_discrepancy

The difference in length or circumference between paired body segments.

The difference in length or circumference between paired body segments.

Purpose. To record the difference in length or circumference between paired body segments.

Source

Columns

Constraints

check ((body_segment_measurement_code is null and body_segment_measurement_system is null and body_segment_measurement_valueset_id is null) or (body_segment_measurement is not null and body_segment_measurement_code is not null and body_segment_measurement_system is not null and body_segment_measurement_valueset_id is not null))
check ((discrepancy_magnitude is null and discrepancy_units is null) or (discrepancy_magnitude is not null and discrepancy_units is not null))
check (discrepancy_magnitude is null or (discrepancy_units = 'cm' and discrepancy_magnitude >= 0) or (discrepancy_units = '[in_i]' and discrepancy_magnitude >= 0) or (discrepancy_units = 'mm' and discrepancy_magnitude >= 0))
check ((longest_side_code is null and longest_side_system is null and longest_side_valueset_id is null) or (longest_side is not null and longest_side_code is not null and longest_side_system is not null and longest_side_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_discrepancy_measuring_device via body_segment_discrepancy_id
• body_segment_discrepancy_structured_origin via body_segment_discrepancy_id
• body_segment_discrepancy_structured_endpoint via body_segment_discrepancy_id

Indexes

• body_segment_discrepancy_form_id_idx on form_id

Child tables

3 tables hang off body_segment_discrepancy, one row per repetition.

body_segment_discrepancy_measuring_device

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

Unique

• body_segment_discrepancy_id, position
• body_segment_discrepancy_id, device_id

References

Indexes

• body_segment_discrepancy_measuring_device_device_id_idx on device_id

body_segment_discrepancy_structured_origin

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

Unique

• body_segment_discrepancy_id, position
• body_segment_discrepancy_id, anatomical_location_id

References

Indexes

• body_segment_discrepancy_structured_origin_anatomical_lo_c12f44 on anatomical_location_id

body_segment_discrepancy_structured_endpoint

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

Unique

• body_segment_discrepancy_id, position
• body_segment_discrepancy_id, anatomical_location_id

References

Indexes

• body_segment_discrepancy_structured_endpoint_anatomical__3b94cf on anatomical_location_id

Value sets