CREATE TABLE IF NOT EXISTS claim_settings (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  tenant_id BIGINT UNSIGNED NOT NULL,
  location_id BIGINT UNSIGNED NOT NULL,

  -- limit
  max_txn_per_month INT NULL,              -- contoh: 3
  max_amount_per_order DECIMAL(14,2) NULL, -- contoh: 50000
  max_amount_per_month DECIMAL(14,2) NULL, -- contoh: 150000
  max_percent_of_subtotal DECIMAL(6,2) NULL, -- optional (misal 5.00 untuk 5%)

  -- template text (halus)
  tpl_approved TEXT NULL,
  tpl_adjusted TEXT NULL,
  tpl_rejected TEXT NULL,
  tpl_override TEXT NULL,

  created_at DATETIME NULL,
  updated_at DATETIME NULL,

  UNIQUE KEY uniq_claim_settings (tenant_id, location_id)
);