car-wash-java/car-wash-entity/src/main/resources/sql/v19_add_settlement_withdrawal_fee.sql

-- ====================================================
-- V19 — t_settlement_record 新增提现手续费列
-- 微信提现手续费，费率固定 0.6%（千分之六）
-- 结算金额 = 可结算总额（扣除平台费后） - 提现手续费
-- ====================================================

ALTER TABLE `t_settlement_record`
    ADD COLUMN `withdrawal_fee` INT NOT NULL DEFAULT 0 COMMENT '提现手续费（分），微信提现费率0.6%'
    AFTER `platform_fee`;