Lewati ke isi

PostgreSQL Documentation — TODO

Last Updated: 2026-05-26
Status: 61 fungsi logika.* terimplementasi

  • [x] Indeks trigger per tabel tenant (trg_*, fn_*) ✅
  • ✅ database/ddl/10_template_tenant/40_trigger.sql — Template trigger per tenant
  • ✅ database/ddl/11_logika_fungsi.sql — 61 fungsi trigger (fn_transaksi_*, fn_jurnal_*, dll)
  • ✅ Trigger otomatis dibuat saat provision tenant via buat_tenant.sql
  • [x] Diagram ER ringkas transaksi ↔ jurnal ↔ stok ✅
  • ✅ See: database/docs/03-DESAIN-DATABASE-BARU.md
  • ✅ Entity relationships documented dengan cardinality
  • [x] Daftar fungsi logika.* dengan kontrak input/output ✅
  • ✅ Trigger Catalog: database/docs/06-TRIGGER-CATALOG.md
  • ✅ 39 objects documented (6 trigger functions, 12 business functions, 6 dashboard functions, dll)
  • ✅ Includes: function signature, purpose, source file, usage examples
  • [x] Runbook search_path / pool tenant untuk debugging ✅
  • ✅ database/docs/04-ARSITEKTUR-MULTI-TENANT.md §3 — search_path behavior
  • ✅ AGENTS.md — Runtime pool tenant configuration
  • ✅ database/cdc/RUNBOOK.md — CDC consumer pool setup

Implementation References

Category Files Count
Schema database/ddl/02_schema_logika.sql 1 schema (logika)
Trigger Functions database/ddl/11_logika_fungsi.sql 61 functions
Tenant Triggers database/ddl/10_template_tenant/40_trigger.sql ~10 triggers/tenant
Migrations database/migrations/tenant/V*.sql 40+ migrations

Rujuk implementasi