schema / migration / 008-snake-case-pricing-benefit-columns

008 - Rename camelCase columns to snake_case

  • Tanggal: 2026-08-10
  • DB: mpcdb (PostgreSQL)
  • Ringkas: Kolom pricing/benefit yang camelCase di Postgres diganti snake_case.

ALTER (jalankan di DB server)

-- time_group_schedules
ALTER TABLE time_group_schedules RENAME COLUMN "dayOfWeek" TO day_of_week;
ALTER TABLE time_group_schedules RENAME COLUMN "startTime" TO start_time;
ALTER TABLE time_group_schedules RENAME COLUMN "endTime" TO end_time;

-- item_price_overrides
ALTER TABLE item_price_overrides RENAME COLUMN "targetType" TO target_type;
ALTER TABLE item_price_overrides RENAME COLUMN "dayType" TO day_type;

-- tier_benefits
ALTER TABLE tier_benefits RENAME COLUMN "targetType" TO target_type;
ALTER TABLE tier_benefits RENAME COLUMN "discountType" TO discount_type;
ALTER TABLE tier_benefits RENAME COLUMN "discountValue" TO discount_value;
ALTER TABLE tier_benefits RENAME COLUMN "periodType" TO period_type;

Rollback

ALTER TABLE time_group_schedules RENAME COLUMN day_of_week TO "dayOfWeek";
ALTER TABLE time_group_schedules RENAME COLUMN start_time TO "startTime";
ALTER TABLE time_group_schedules RENAME COLUMN end_time TO "endTime";

ALTER TABLE item_price_overrides RENAME COLUMN target_type TO "targetType";
ALTER TABLE item_price_overrides RENAME COLUMN day_type TO "dayType";

ALTER TABLE tier_benefits RENAME COLUMN target_type TO "targetType";
ALTER TABLE tier_benefits RENAME COLUMN discount_type TO "discountType";
ALTER TABLE tier_benefits RENAME COLUMN discount_value TO "discountValue";
ALTER TABLE tier_benefits RENAME COLUMN period_type TO "periodType";

Catatan

  • Update GORM column tags + raw SQL di mpc-be (pricing, transactions).
  • Prisma: field camelCase + @map("snake_case").