The scenario
A dental chain operates multiple clinics and needs a shared database where patient records are accessible across locations while appointments, treatments, dentists, and billing are tracked per clinic.
What is in this drawing
Read the decisions behind it.
01
Centralized Patient entity with an insurance foreign key to support shared records across clinics.
02
Separate Clinic and Address entities to model multiple locations.
03
Invoice and InvoiceLine entities link treatments to billing, preserving auditability.
Use this model when designing a multi-site healthcare or service business that requires centralized customer or patient records with location-specific operational details.
More like this