“Create a radiology imaging orders ERD with Patient, Provider, ImagingOrder, Study, Series, and Report tables, the shown keys and attributes, orders for patients and requested by providers, studies fulfilling orders, series in studies, and reports signed by providers.”
Read the decisions behind it.
Orders identify the requesting provider and patient.
Accession number is unique for each performed study.
A study may contain many series.
Report status and signature time support draft and final interpretations.
The signing radiologist is a Provider foreign key.
This schema is a compact RIS/PACS-oriented model. Interoperability, image storage, scheduling, and clinical privacy requirements need additional design.
Other examples in this family.
Common questions
What is an accession number?
It is a unique identifier commonly assigned to an imaging study for tracking and workflow.
Why are Series separate from Study?
A single study can contain multiple acquisitions, sequences, or body regions.
Can a report be unsigned?
Yes. The status and signed_at fields allow draft and final report states.