imaging_exam_foetus

Findings on radiological examination of a single fetus or embryo in utero.

Findings on radiological examination of a single fetus or embryo in utero.

Purpose. To record the findings on radiological examination of a single foetus or embryo, 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 ((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 ((cardiac_activity_code is null and cardiac_activity_system is null and cardiac_activity_valueset_id is null and cardiac_activity is null) or (cardiac_activity is not null and cardiac_activity_code is not null and cardiac_activity_system is not null and cardiac_activity_valueset_id is not null))
check ((heart_rate_magnitude is null and heart_rate_units is null) or (heart_rate_magnitude is not null and heart_rate_units is not null))
check (heart_rate_magnitude is null or (heart_rate_units = '/min' and heart_rate_magnitude >= 0))
check ((estimated_weight_magnitude is null and estimated_weight_units is null) or (estimated_weight_magnitude is not null and estimated_weight_units is not null))
check (estimated_weight_magnitude is null or (estimated_weight_units = 'g' and estimated_weight_magnitude >= 0) or (estimated_weight_units = 'kg' and estimated_weight_magnitude >= 0))

References

Referenced by

• imaging_exam_foetus_structured_body_site via imaging_exam_foetus_id
• imaging_exam_foetus_additional_details via imaging_exam_foetus_id
• imaging_exam_result_structured_imaging_findings via imaging_exam_foetus_id
• investigation_screening_specific_investigation_additiona_45e74e via imaging_exam_foetus_id

Child tables

2 tables hang off imaging_exam_foetus, one row per repetition.

imaging_exam_foetus_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_foetus_id, position

References

Indexes

• imaging_exam_foetus_structured_body_site_anatomical_loca_99d64c on anatomical_location_id
• imaging_exam_foetus_structured_body_site_anatomical_loca_5e6627 on anatomical_location_circle_id
• imaging_exam_foetus_structured_body_site_anatomical_loca_4b4d56 on anatomical_location_relative_id

imaging_exam_foetus_additional_details

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

Unique

• imaging_exam_foetus_id, position
• imaging_exam_foetus_id, imaging_exam_lesion_adnexal_mass_id

References

Indexes

• imaging_exam_foetus_additional_details_imaging_exam_lesi_684c64 on imaging_exam_lesion_adnexal_mass_id

Value sets