anatomical_location_circle

A physical site on or within the human body that is described in terms of the direction, and optionally the distance, of the site from a central landmark.

A physical site on or within the human body that is described in terms of the direction, and optionally the distance, of the site from a central landmark.

Purpose. To record structured details about a physical site on or within the human body that is described in terms of the direction, and optionally the distance, of the site from a central landmark.

Source

Columns

Constraints

check ((centre_landmark_code is null and centre_landmark_system is null and centre_landmark_valueset_id is null) or (centre_landmark is not null and centre_landmark_code is not null and centre_landmark_system is not null and centre_landmark_valueset_id is not null))
check ((circular_direction_code is null and circular_direction_system is null and circular_direction_valueset_id is null and circular_direction is null) or (circular_direction is not null and circular_direction_code is not null and circular_direction_system is not null and circular_direction_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))

References

Referenced by

19 tables reference anatomical_location_circle, via anatomical_location_circle_id. The first 15 alphabetically:

• anatomical_location_alternative_structure via anatomical_location_circle_id
• anatomical_location_circle_multimedia_representation via anatomical_location_circle_id
• exposure_screening_specific_exposure_additional_details via anatomical_location_circle_id
• imaging_exam_structured_body_site via anatomical_location_circle_id
• imaging_exam_cervix_structured_body_site via anatomical_location_circle_id
• imaging_exam_fallopian_tube_structured_body_site via anatomical_location_circle_id
• imaging_exam_foetus_structured_body_site via anatomical_location_circle_id
• imaging_exam_gestational_sac_structured_body_site via anatomical_location_circle_id
• imaging_exam_hip_joint_structured_body_site via anatomical_location_circle_id
• imaging_exam_lesion_adnexal_mass_structured_body_site via anatomical_location_circle_id
• imaging_exam_ovary_structured_body_site via anatomical_location_circle_id
• imaging_exam_rectouterine_pouch_structured_body_site via anatomical_location_circle_id
• medication via administration_details_structured_body_site_anatomical_l_afc7f9
• medication_order via structured_body_site_anatomical_location_circle
• problem_diagnosis_structured_body_site via anatomical_location_circle_id

Child tables

1 table hang off anatomical_location_circle, one row per repetition.

anatomical_location_circle_multimedia_representation

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

Unique

• anatomical_location_circle_id, position
• anatomical_location_circle_id, attachment_id

References

Indexes

• anatomical_location_circle_multimedia_representation_att_f3a774 on attachment_id

Value sets