상황
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.