シナリオ
A dental clinic specializing in orthodontics needs a physical data model to store patients, orthodontists, procedure catalog, treatment plans with itemized procedures per tooth, appointments, and payments.
この図に含まれるもの
図の背後にある意思決定を読み解く。
01
Separate ProcedureCatalog from TreatmentPlanItem to normalize procedure codes and default costs.
02
Model many-to-many between TreatmentPlan and ProcedureCatalog through TreatmentPlanItem with tooth_number and sequence_no.
03
Link Payment directly to TreatmentPlan to track plan-level billing.
Use this schema when building a dental or orthodontic practice management system that requires treatment plan versioning, itemized procedures, appointment tracking, and payment recording.