imaging_exam_fallopian_tube

Findings on radiological examination of a single fallopian tube.

Findings on radiological examination of a single fallopian tube.

Purpose. To record the findings on radiological examination of a single fallopian tube, and their interpretation.

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 ((patency_code is null and patency_system is null and patency_valueset_id is null and patency is null) or (patency is not null and patency_code is not null and patency_system is not null and patency_valueset_id is not null))
check ((gestational_sac_presence_code is null and gestational_sac_presence_system is null and gestational_sac_presence_valueset_id is null and gestational_sac_presence is null) or (gestational_sac_presence is not null and gestational_sac_presence_code is not null and gestational_sac_presence_system is not null and gestational_sac_presence_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))

References

Referenced by

• imaging_exam_fallopian_tube_structured_body_site via imaging_exam_fallopian_tube_id
• imaging_exam_fallopian_tube_additional_details via imaging_exam_fallopian_tube_id
• imaging_exam_result_structured_imaging_findings via imaging_exam_fallopian_tube_id
• investigation_screening_specific_investigation_additiona_45e74e via imaging_exam_fallopian_tube_id

Child tables

2 tables hang off imaging_exam_fallopian_tube, one row per repetition.

imaging_exam_fallopian_tube_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_fallopian_tube_id, position

References

Indexes

• imaging_exam_fallopian_tube_structured_body_site_anatomi_c4c9d9 on anatomical_location_id
• imaging_exam_fallopian_tube_structured_body_site_anatomi_c064a4 on anatomical_location_circle_id
• imaging_exam_fallopian_tube_structured_body_site_anatomi_1f2ea2 on anatomical_location_relative_id

imaging_exam_fallopian_tube_additional_details

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

Unique

• imaging_exam_fallopian_tube_id, position
• imaging_exam_fallopian_tube_id, imaging_exam_lesion_adnexal_mass_id

References

Indexes

• imaging_exam_fallopian_tube_additional_details_imaging_e_edef52 on imaging_exam_lesion_adnexal_mass_id

Value sets