Data Modeling for Healthcare Vertical

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:

  • Doctors
  • Hospitals
  • Urgent Care
  • Offices
  • Conditions Treated
  • Top Procedures Performed
  • Jobs

What Entity Types do we need and how should they be related?

1 Like

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:

  • Healthcare Professionals
  • Healthcare Facilities for the Hospitals, Urgent Cares, Offices
  • Conditions
  • Procedures
  • Jobs
  • FAQs (which are always important to have)

Additionally you’ll want to build the following relationships:

  • Healthcare Professional <–works at–>Healthcare Facility
  • Healthcare Professional<–treats–>Condition
  • Healthcare Professional<–performs–>Procedure
  • Healthcare Facility<–treats–>Condition
  • Healthcare Facility<–performs–>Procedure
  • Condition<–treated by–>Procedure
  • FAQ<–about–>Condition
  • FAQ<–about–>Procedure
  • FAQ<–about–>Facility

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:

  • Healthcare Professionals
  • Healthcare Facilities for the Hospitals, Urgent Cares, Offices
  • Jobs
  • FAQs (which are always important to have)

Additionally you’ll want to build the following relationships:

  • Healthcare Professional <–works at–>Healthcare Facility
  • FAQ<–about–>Facility

Hope that helps!

2 Likes