003 - ksrdb datamart (owner analytics)

• Tanggal: 2026-08-08
• DB: ksrdb (baru — bukan mpcdb)
• Ringkas: Provision database datamart untuk owner dashboard; schema dikelola Prisma di ksr-sync / mpc-owner.

ALTER (jalankan di DB server)

-- Create database (as superuser), then apply Prisma schema:
--   createdb ksrdb
--   cd ksr-sync && KSR_DATABASE_URL=... npx prisma db push
-- or from mpc-owner:
--   DATABASE_URL=... npx prisma db push

-- Tables created by Prisma (see ksr-sync/prisma/schema.prisma):
-- dim_business, dim_branch, dim_customer,
-- fact_transaction, fact_visit, fact_review, sync_watermark

Rollback

DROP DATABASE IF EXISTS ksrdb;

Catatan

• Populate via ksr-sync (read-only dari mpcdb).
• mpc-owner reads ksrdb only.