imaging_exam_cervix

Findings on radiological examination of the cervix.

Findings on radiological examination of the cervix.

Purpose. To record the findings on radiological examination of the cervix, 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 ((length_magnitude is null and length_units is null) or (length_magnitude is not null and length_units is not null))
check (length_magnitude is null or (length_units = 'mm' and length_magnitude >= 0) or (length_units = 'cm' and length_magnitude >= 0))
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_cervix_structured_body_site via imaging_exam_cervix_id
• imaging_exam_cervix_additional_details via imaging_exam_cervix_id
• imaging_exam_result_structured_imaging_findings via imaging_exam_cervix_id
• investigation_screening_specific_investigation_additiona_45e74e via imaging_exam_cervix_id

Child tables

2 tables hang off imaging_exam_cervix, one row per repetition.

imaging_exam_cervix_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_cervix_id, position

References

Indexes

• imaging_exam_cervix_structured_body_site_anatomical_loca_63d66b on anatomical_location_id
• imaging_exam_cervix_structured_body_site_anatomical_loca_413d81 on anatomical_location_circle_id
• imaging_exam_cervix_structured_body_site_anatomical_loca_9e43e5 on anatomical_location_relative_id

imaging_exam_cervix_additional_details

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

Unique

• imaging_exam_cervix_id, position
• imaging_exam_cervix_id, imaging_exam_lesion_adnexal_mass_id

References

Indexes

• imaging_exam_cervix_additional_details_imaging_exam_lesi_36c164 on imaging_exam_lesion_adnexal_mass_id

Value sets