Stream: tooling
Topic: FHIR - ERD - Model
karim jessani (May 27 2020 at 16:09):
Hi all, just wanted to ask if anyone has a link to an ERD FHIR model. Perhaps leveraging a tool like PowerDesigner or ERStudio would be even better...This way its a different visual representation of it...
Lloyd McKenzie (May 27 2020 at 16:19):
It's been tried and it's super hard to read. If you include extensions, everything can point to everything. Even without extensions, there are a number of places where Reference<Any> is used (which means pointing to everything). And if you ignore those, you'll still find almost all resources pointing to Patient, Practitioner, PractitionerRole, Organization, etc. Thus, we don't bother publishing an official one - just not very helpful to the reader.
karim jessani (May 27 2020 at 17:04):
Ugh, so what if go at it in another direction. Is there an xls file or something that has all entities (tables) in one place (Patient / Organization / Address) and with it the corresponding fields like city / province / state ...
Lloyd McKenzie (May 27 2020 at 17:10):
FHIR isn't a database model - its focus is exchange. There are no simple types in FHIR - even something like a boolean can have extensions, id, etc. If you want to generate a FHIR-based database model, you should look here: http://build.fhir.org/storage.html and then check out the discussions here: #storage for FHIR
Lloyd McKenzie (May 27 2020 at 17:11):
There are lots of different approaches, driven by how you expect to be querying the data and your performance needs.
Last updated: Apr 12 2022 at 19:14 UTC
