Schema reference / Tables / view MDX source

imaging_exam

Findings on radiological examination of a specified body structure or region.

Purpose. To record the findings on radiological examination of a specified body structure or region, and their interpretation.

Source

Model	Leg	Role
`openEHR-EHR-CLUSTER.imaging_exam.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]`
`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]`

Constraints

check ((body_structure_code is null and body_structure_system is null and body_structure_valueset_id 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))

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

Referenced by

imaging_exam_structured_body_site via imaging_exam_id
imaging_exam_additional_details via imaging_exam_id
imaging_exam_result_structured_imaging_findings via imaging_exam_id
investigation_screening_specific_investigation_additiona_45e74e via imaging_exam_id

Child tables

2 tables hang off imaging_exam, one row per repetition.

`imaging_exam_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_id`	`uuid` → `imaging_exam`	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_id, position

References

Columns	Target	On delete
`imaging_exam_id`	`imaging_exam`	cascade
`anatomical_location_id`	`anatomical_location`	no action
`anatomical_location_circle_id`	`anatomical_location_circle`	no action
`anatomical_location_relative_id`	`anatomical_location_relative`	no action

Indexes

imaging_exam_structured_body_site_anatomical_location_id_idx on anatomical_location_id
imaging_exam_structured_body_site_anatomical_location_ci_338c7c on anatomical_location_circle_id
imaging_exam_structured_body_site_anatomical_location_re_5ed322 on anatomical_location_relative_id

`imaging_exam_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_id`	`uuid` → `imaging_exam`	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_id, position
imaging_exam_id, imaging_exam_lesion_adnexal_mass_id

References

Columns	Target	On delete
`imaging_exam_id`	`imaging_exam`	cascade
`imaging_exam_lesion_adnexal_mass_id`	`imaging_exam_lesion_adnexal_mass`	no action

Indexes

imaging_exam_additional_details_imaging_exam_lesion_adne_baf94b on imaging_exam_lesion_adnexal_mass_id