Alur Bisnis End-to-End

Berikut flow utama klinik dari akuisisi pasien sampai revenue:

1. AKUISISI — SEO & Online Booking

Google Search
   ↓ (8 SEO route patterns)
Landing /best-dentist/{city} atau /
   ↓
Click "Book Appointment"
   ↓
Booking Wizard /book (5 step)
   ↓
Patient & Appointment created
   ↓
WA Reminder H-7 / H-2 / H-1

KPI:

• Organic traffic ke SEO pages
• Conversion booking dari landing
• Booking confirmation rate

2. KEDATANGAN — Front Office Flow

Pasien datang
   ↓
FO check-in (status: waiting)
   ↓
Triage assignment
   ↓
Dokter dipanggil
   ↓
Visit dibuka

Tabel terlibat:

• appointments (status: scheduled → confirmed → waiting → in_treatment → done)
• visits (visit_number, check_in_at, check_out_at)

3. KLINIS — Doctor Workflow

Visit start
   ↓
Anamnesis (chief complaint, riwayat)
   ↓
Pemeriksaan klinis
   ↓
Odontogram update (per visit, kompare history)
   ↓
[Optional: BPE, CRA, Pediatric eruption]
   ↓
Diagnosis (ICD-10 dental code)
   ↓
Treatment Plan dibuat
   ↓
Pasien approve (tanda tangan / verbal)
   ↓
Eksekusi treatment:
   - Anesthesia log
   - Tindakan (Endo/Ortho/Implant/Bleaching/dll)
   - Material usage (auto-deduct stock)
   ↓
Clinical Notes SOAP
   ↓
Prescription (jika perlu)
   ↓
Recall schedule otomatis

Tabel terlibat:

• examinations, odontograms, tooth_conditions
• caries_risk_assessments, oral_hygiene_indices
• treatment_plans + treatment_plan_items
• anesthesia_logs, endodontic_treatments, orthodontic_cases + orthodontic_adjustments
• implant_records + implant_stages, bleaching_records
• clinical_notes, prescriptions + prescription_items
• stock_transactions (auto deduct)
• recall_schedules

4. BILLING — Revenue Ops

Treatment selesai
   ↓
FO generate invoice (auto dari completed treatment_plan_items)
   ↓
Apply discount/promo
   ↓
PPN 11% (jika applicable)
   ↓
Invoice issued
   ↓
Patient bayar:
   ├─ Cash/Debit/Credit/QRIS/Transfer → Payment record
   ├─ Deposit (DP) → Installment schedule
   └─ Asuransi → Insurance Claim
        ↓
        submitted → approved → paid
   ↓
Invoice status: paid / partial_paid
   ↓
Receipt PDF
   ↓
Doctor fee splitting (komisi)

Tabel terlibat:

• invoices + invoice_items
• payments, deposits, installments + installment_schedules
• discounts, packages + package_items
• insurance_providers + insurance_plans + patient_insurance + insurance_claims

5. RETENSI — Recall & Communication

Recall date due
   ↓
Cron job: reminders:dispatch (daily 09:00)
   ↓
WA reminder sent (status: reminder_sent)
   ↓
Patient confirm via portal / WA
   ↓
New appointment created
   ↓
[BACK TO STEP 2]

Tabel terlibat:

• recall_schedules
• reminders, notifications, message_templates
• messaging_providers (WATI/Wablas/Fonnte/Twilio/Generic)

6. ANALYTICS — Owner Dashboard

Daily summary
   ├─ Revenue (today, MTD, YTD)
   ├─ Patient acquisition
   ├─ Doctor performance (completion rate, no-show)
   ├─ Top treatments (volume, revenue)
   └─ Insurance claim status
   ↓
Export Excel/PDF
   ↓
Decision: marketing budget, doctor scheduling, inventory restock

Tabel terlibat:

• Aggregated dari invoices, payments, appointments, visits
• Cache di Redis untuk performance

Data Integrity & FK Chain

Clinic ──┬─→ Users (staff, doctor, patient-as-user)
         ├─→ Doctors (1 user ↔ 1 doctor profile)
         ├─→ Dental Chairs
         ├─→ Patients
         ├─→ Working Hours
         ├─→ Appointments ──→ Visit (1:1)
         │                       ├─→ Examination
         │                       ├─→ Odontograms ──→ Tooth Conditions (cascade)
         │                       ├─→ Clinical Notes
         │                       ├─→ Prescriptions ──→ Items
         │                       ├─→ Radiographs, Intraoral Images
         │                       └─→ [Specialty: Endo, Anesthesia, Bleaching, CRA, BPE]
         ├─→ Treatment Plans ──→ Items ──→ Treatments
         ├─→ Orthodontic Cases ──→ Adjustments (cascade)
         ├─→ Implant Records ──→ Stages (cascade)
         ├─→ Invoices ──→ Items ──→ Treatments
         │       ├─→ Payments
         │       ├─→ Installments ──→ Schedules
         │       └─→ Insurance Claims
         ├─→ Materials ──→ Stock Transactions, Purchase Orders
         ├─→ Dental Labs ──→ Lab Cases ──→ Tracking
         └─→ Recall Schedules ──→ Linked Appointment

Semua FK punya cascade behavior yang sesuai:

• Specialty records → preserve history via nullOnDelete (visit_id, radiograph_id)
• Master cases (ortho, implant) → CASCADE ke child records
• Patient data → soft delete (audit trail tetap)