imaging_exam_gestational_sac
Findings on radiological examination of a single gestational sac.
Findings on radiological examination of a single gestational sac.
Purpose. To record the findings on radiological examination of a gestational sac, and their interpretation.
Source
| Model | Leg | Role |
|---|
openEHR-EHR-CLUSTER.imaging_exam-gestational_sac.v1 | openEHR | defines this table |
Columns
| Column | Type | Null | Description | Source |
|---|
id | uuid primary key | no | Primary key. | — |
body_structure
body_structure_code
body_structure_system
body_structure_valueset_id | coded text
text, text, text, text | yes | Body structure | /items[at0001.1] |
body_site
body_site_code
body_site_system
body_site_valueset_id | coded text
text, text, text, text | yes | Body site | /items[at0002] |
imaging_findings | text | yes | Imaging findings | /items[at0004] |
impression
impression_code
impression_system
impression_valueset_id | coded text
text, text, text, text | yes | Impression | /items[at0006] |
comment | text | yes | Comment | /items[at0007] |
mean_sac_diameter_msd_magnitude
mean_sac_diameter_msd_units | quantity
numeric, text | yes | Mean Sac Diameter (MSD) | /items[at0.2] |
yolk_sac_description | text | yes | Yolk sac description | /items[at0.4] |
amnion_description | text | yes | Amnion description | /items[at0.6] |
number_of_embryos | integer | yes | Number of embryos | /items[at0.15] |
cardiac_activity
cardiac_activity_code
cardiac_activity_system
cardiac_activity_valueset_id | coded text
text, text, text, text | yes | Cardiac activity | /items[at0.16] |
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 ((mean_sac_diameter_msd_magnitude is null and mean_sac_diameter_msd_units is null) or (mean_sac_diameter_msd_magnitude is not null and mean_sac_diameter_msd_units 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))
References
| Columns | Target | On delete |
|---|
body_structure_valueset_id, body_structure_code, body_structure_system, body_structure | valueset_code | restrict |
body_site_valueset_id, body_site_code, body_site_system, body_site | valueset_code | restrict |
impression_valueset_id, impression_code, impression_system, impression | valueset_code | restrict |
cardiac_activity_valueset_id, cardiac_activity_code, cardiac_activity_system, cardiac_activity | valueset_code | restrict |
Referenced by
Child tables
2 tables hang off imaging_exam_gestational_sac, one row per repetition.
imaging_exam_gestational_sac_structured_body_site
Child table — one row per repetition, deleted with its parent.
| Column | Type | Null | Description | Source |
|---|
id | uuid primary key | no | Primary key. | — |
imaging_exam_gestational_sac_id | uuid → imaging_exam_gestational_sac | no | — | — |
position | integer | no | Order of this row within its parent, from zero. | — |
anatomical_location_id | uuid | yes | — | — |
anatomical_location_circle_id | uuid | yes | — | — |
anatomical_location_relative_id | uuid | yes | — | — |
Constraints
check (num_nonnulls(anatomical_location_id, anatomical_location_circle_id, anatomical_location_relative_id) = 1)
Unique
imaging_exam_gestational_sac_id, position
References
Indexes
imaging_exam_gestational_sac_structured_body_site_anatom_afce82 on anatomical_location_idimaging_exam_gestational_sac_structured_body_site_anatom_af4641 on anatomical_location_circle_idimaging_exam_gestational_sac_structured_body_site_anatom_1ceacd on anatomical_location_relative_id
imaging_exam_gestational_sac_additional_details
Child table — one row per repetition, deleted with its parent.
| Column | Type | Null | Description | Source |
|---|
id | uuid primary key | no | Primary key. | — |
imaging_exam_gestational_sac_id | uuid → imaging_exam_gestational_sac | no | — | — |
position | integer | no | Order of this row within its parent, from zero. | — |
imaging_exam_lesion_adnexal_mass_id | uuid | no | Additional details | /items[at0005] |
Unique
imaging_exam_gestational_sac_id, positionimaging_exam_gestational_sac_id, imaging_exam_lesion_adnexal_mass_id
References
Indexes
imaging_exam_gestational_sac_additional_details_imaging__bcaf75 on imaging_exam_lesion_adnexal_mass_id
Value sets
| Value set | Codes |
|---|
org.openehr::openEHR-EHR-CLUSTER.imaging_exam-gestational_sac.v1/body_structure | 1 |
org.openehr::openEHR-EHR-CLUSTER.imaging_exam-gestational_sac.v1/cardiac_activity | 3 |