El escenario
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.
Qué hay en este dibujo
Lee las decisiones que hay detrás.
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.