What is the best way to model the data for a customer in the healthcare vertical?
They want to be able to answer questions around:
What Entity Types do we need and how should they be related?
Hi Liz,
There are a few different ways you can model the data depending on what you’re trying to do. I’ll lay out some options below.
Option 1:
If you want to have pages and answer questions around conditions and procedures outside of the context of who treats or performs those, then you’ll want to consider the following data model:
Additionally you’ll want to build the following relationships:
Option 2:
If you only want to answer questions about who treats conditions / performs procedures as they relate to doctors or facilities, without any standalone information about either, then you can make Conditions Treated and Procedures Performed an attribute about an entity instead of an Entity Type. We can then display that information on a doctor or facility page profile or answer questions like “who treats heart murmurs?” or “who performs appendectomy?” but we would not be able to answer “what procedures treat appendicitis?” or “conditions related to heart problems”. In this case, the entities would be:
Additionally you’ll want to build the following relationships:
Hope that helps!