body_segment_area

Calculation of the cross-sectional area of an identified part of the body, usually identified in relation to points of surface anatomy.

Calculation of the cross-sectional area of an identified part of the body, usually identified in relation to points of surface anatomy.

Purpose. To record the calculation of the cross-sectional area of an identified 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 ((area_magnitude is null and area_units is null) or (area_magnitude is not null and area_units is not null))
check (area_magnitude is null or (area_units = 'mm2' and area_magnitude >= 0) or (area_units = 'cm2' and area_magnitude >= 0) or (area_units = '[sin_i]' and area_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_area_measuring_device via body_segment_area_id
• body_segment_area_structured_origin_endpoint via body_segment_area_id

Indexes

• body_segment_area_form_id_idx on form_id

Child tables

2 tables hang off body_segment_area, one row per repetition.

body_segment_area_measuring_device

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

Unique

• body_segment_area_id, position
• body_segment_area_id, device_id

References

Indexes

• body_segment_area_measuring_device_device_id_idx on device_id

body_segment_area_structured_origin_endpoint

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

Unique

• body_segment_area_id, position
• body_segment_area_id, anatomical_location_id

References

Indexes

• body_segment_area_structured_origin_endpoint_anatomical__8be18a on anatomical_location_id

Value sets