O cenário
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.
O que há neste desenho
Entenda as decisões por trás dele.
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.