anatomical_location_relative

A physical site on or within the human body that is described in terms of its relationship to other body parts.

A physical site on or within the human body that is described in terms of its relationship to other body parts.

Purpose. To identify and record structured details about a single physical site on, or within, the human body in terms of its relationship to other macroscopic anatomical landmarks.

Source

Columns

Referenced by

23 tables reference anatomical_location_relative, via anatomical_location_relative_id. The first 15 alphabetically:

• adverse_reaction_event_reaction_details via anatomical_location_relative_id
• anatomical_location_alternative_structure via anatomical_location_relative_id
• anatomical_location_relative_relative_location via anatomical_location_relative_id
• anatomical_location_relative_multimedia_representation via anatomical_location_relative_id
• capillary_refill via structured_measurement_location_anatomical_location_relative
• exposure_screening_specific_exposure_additional_details via anatomical_location_relative_id
• imaging_exam_structured_body_site via anatomical_location_relative_id
• imaging_exam_cervix_structured_body_site via anatomical_location_relative_id
• imaging_exam_fallopian_tube_structured_body_site via anatomical_location_relative_id
• imaging_exam_foetus_structured_body_site via anatomical_location_relative_id
• imaging_exam_gestational_sac_structured_body_site via anatomical_location_relative_id
• imaging_exam_hip_joint_structured_body_site via anatomical_location_relative_id
• imaging_exam_lesion_adnexal_mass_structured_body_site via anatomical_location_relative_id
• imaging_exam_ovary_structured_body_site via anatomical_location_relative_id
• imaging_exam_rectouterine_pouch_structured_body_site via anatomical_location_relative_id

Child tables

2 tables hang off anatomical_location_relative, one row per repetition.

anatomical_location_relative_relative_location

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

Constraints

check ((landmark_name_code is null and landmark_name_system is null and landmark_name_valueset_id is null) or (landmark_name is not null and landmark_name_code is not null and landmark_name_system is not null and landmark_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 ((distance_from_landmark_magnitude is null and distance_from_landmark_units is null) or (distance_from_landmark_magnitude is not null and distance_from_landmark_units is not null))
check (distance_from_landmark_magnitude is null or (distance_from_landmark_units = 'cm' and distance_from_landmark_magnitude >= 0) or (distance_from_landmark_units = '[in_i]' and distance_from_landmark_magnitude >= 0) or (distance_from_landmark_units = 'mm' and distance_from_landmark_magnitude >= 0))
check ((direction_code is null and direction_system is null and direction_valueset_id is null) or (direction is not null and direction_code is not null and direction_system is not null and direction_valueset_id is not null))

Unique

• anatomical_location_relative_id, position

References

anatomical_location_relative_multimedia_representation

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

Unique

• anatomical_location_relative_id, position
• anatomical_location_relative_id, attachment_id

References

Indexes

• anatomical_location_relative_multimedia_representation_a_c5ef86 on attachment_id

Value sets