情境
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.
這張圖裡有什麼
看懂背後的決策。
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.