imaging_exam_hip_joint

Findings on radiological examination of a hip joint.

Findings on radiological examination of a hip joint.

Purpose. To record the findings on radiological examination of a hip joint.

Source

Columns

Constraints

check ((body_structure_code is null and body_structure_system is null and body_structure_valueset_id is null and body_structure is null) or (body_structure is not null and body_structure_code is not null and body_structure_system is not null and body_structure_valueset_id is not null))
check ((body_site_code is null and body_site_system is null and body_site_valueset_id is null) or (body_site is not null and body_site_code is not null and body_site_system is not null and body_site_valueset_id is not null))
check ((impression_code is null and impression_system is null and impression_valueset_id is null) or (impression is not null and impression_code is not null and impression_system is not null and impression_valueset_id is not null))
check ((acetabular_roof_angle_magnitude is null and acetabular_roof_angle_units is null) or (acetabular_roof_angle_magnitude is not null and acetabular_roof_angle_units is not null))
check (acetabular_roof_angle_magnitude is null or (acetabular_roof_angle_units = 'deg' and acetabular_roof_angle_magnitude between -360 and 360))
check ((alpha_angle_ddh_magnitude is null and alpha_angle_ddh_units is null) or (alpha_angle_ddh_magnitude is not null and alpha_angle_ddh_units is not null))
check (alpha_angle_ddh_magnitude is null or (alpha_angle_ddh_units = 'deg' and alpha_angle_ddh_magnitude between -360 and 360))
check ((alpha_angle_cam_morphology_magnitude is null and alpha_angle_cam_morphology_units is null) or (alpha_angle_cam_morphology_magnitude is not null and alpha_angle_cam_morphology_units is not null))
check (alpha_angle_cam_morphology_magnitude is null or (alpha_angle_cam_morphology_units = 'deg' and alpha_angle_cam_morphology_magnitude between -360 and 360))
check ((beta_angle_magnitude is null and beta_angle_units is null) or (beta_angle_magnitude is not null and beta_angle_units is not null))
check (beta_angle_magnitude is null or (beta_angle_units = 'deg' and beta_angle_magnitude between -360 and 360))

References

Referenced by

• imaging_exam_hip_joint_structured_body_site via imaging_exam_hip_joint_id
• imaging_exam_hip_joint_additional_details via imaging_exam_hip_joint_id
• imaging_exam_result_structured_imaging_findings via imaging_exam_hip_joint_id
• investigation_screening_specific_investigation_additiona_45e74e via imaging_exam_hip_joint_id

Child tables

2 tables hang off imaging_exam_hip_joint, one row per repetition.

imaging_exam_hip_joint_structured_body_site

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

Constraints

check (num_nonnulls(anatomical_location_id, anatomical_location_circle_id, anatomical_location_relative_id) = 1)

Unique

• imaging_exam_hip_joint_id, position

References

Indexes

• imaging_exam_hip_joint_structured_body_site_anatomical_l_b0d291 on anatomical_location_id
• imaging_exam_hip_joint_structured_body_site_anatomical_l_d9c738 on anatomical_location_circle_id
• imaging_exam_hip_joint_structured_body_site_anatomical_l_e9e766 on anatomical_location_relative_id

imaging_exam_hip_joint_additional_details

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

Unique

• imaging_exam_hip_joint_id, position
• imaging_exam_hip_joint_id, imaging_exam_lesion_adnexal_mass_id

References

Indexes

• imaging_exam_hip_joint_additional_details_imaging_exam_l_901829 on imaging_exam_lesion_adnexal_mass_id

Value sets