Database Design (FULL)
Halaman ini jadi sumber utama design database. Diagram dipisah per domain untuk mencegah render patah/terlalu padat.
- Viewer visual cepat: /docs/database-viewer
- Katalog kolom lengkap: /docs/database-full-catalog
1) Context Map Antar Domain
2) Detail Domain: Procurement
3) Detail Domain: Payment PO
4) Detail Domain: SPK
Ringkasan Domain
| Domain | Tabel utama | Catatan |
|---|---|---|
| Project | projects, pivot_project_spvs, pivot_project_logistic_admins | owner project + relasi personel |
| Procurement | spbs, items, pre_orders, po_items, suppliers | flow request → PO |
| Payment PO | payments, payment_terms, payment_splits, payment_split_price_change_requests, taxes | approval, split, perubahan nominal |
| SPK | spks, spk_payments, spk_payment_accountings, spk_payment_receipts | lifecycle kontrak SPK |
Validitas & Batasan
- Ringkasan di atas berbasis pembacaan migration file pada repo source.
- Untuk konfirmasi final produksi (termasuk data existing), tetap perlu cek schema DB live.
- Beberapa detail relasi lama masih perlu verifikasi jika tidak dipaksa FK pada migration awal.