oa/database/migrations/20260527110001_create_fee_refund.php

<?php

use Phinx\Db\Adapter\MysqlAdapter;
use think\migration\Migrator;

class CreateFeeRefund extends Migrator
{
    public function change(): void {
        $table = $this->table('fee_refund', [
            'id'          => 'id',
            'engine'      => 'InnoDB',
            'collation'   => 'utf8mb4_general_ci',
            'comment'     => '费用返还申请表',
            'auto_id'     => true,
        ]);

        $table
            // 业务字段
            ->addColumn('customer_id', 'string', ['limit' => 100, 'null' => false, 'default' => '', 'comment' => '客户ID'])
            ->addColumn('fee_dimension', 'string', ['limit' => 50, 'null' => false, 'default' => '', 'comment' => '费项维度(多选,逗号分隔value):1账户,2卡'])
            ->addColumn('card_no', 'string', ['limit' => 255, 'null' => false, 'default' => '', 'comment' => '卡号（单张填卡ID，多张填卡BIN）'])
            ->addColumn('refund_item', 'integer', ['limit' => MysqlAdapter::INT_TINY, 'null' => false, 'default' => 0, 'comment' => '退款项:1小额手续费,2失败手续费,3开卡手续费,4充值手续费,5退款手续费,6撤销手续费,7销卡退值金额,9其他'])
            ->addColumn('refund_item_remark', 'text', ['null' => true, 'comment' => '退款项备注（退款项为其他时必填）'])
            ->addColumn('refund_reason', 'integer', ['limit' => MysqlAdapter::INT_TINY, 'null' => false, 'default' => 0, 'comment' => '退款原因:1约定已过审批,2特殊情况'])
            ->addColumn('agreement_no', 'string', ['limit' => 100, 'null' => false, 'default' => '', 'comment' => '约定审批编号'])
            ->addColumn('refund_reason_detail', 'string', ['limit' => 500, 'null' => false, 'default' => '', 'comment' => '具体退款原因'])
            ->addColumn('remark', 'text', ['null' => true, 'comment' => '备注'])
            ->addColumn('file_ids', 'string', ['limit' => 500, 'null' => false, 'default' => '', 'comment' => '附件id,id,id'])
            // 审批必填字段
            ->addColumn('check_status', 'integer', ['limit' => MysqlAdapter::INT_TINY, 'null' => false, 'default' => 0, 'comment' => '审核状态:0待审核,1审核中,2通过,3不通过,4撤销'])
            ->addColumn('check_flow_id', 'integer', ['null' => false, 'default' => 0, 'comment' => '审核流程id'])
            ->addColumn('check_step_sort', 'integer', ['null' => false, 'default' => 0, 'comment' => '当前审批步骤'])
            ->addColumn('check_uids', 'string', ['limit' => 500, 'null' => false, 'default' => '', 'comment' => '当前审批人ID'])
            ->addColumn('check_last_uid', 'string', ['limit' => 500, 'null' => false, 'default' => '', 'comment' => '上一审批人'])
            ->addColumn('check_history_uids', 'string', ['limit' => 500, 'null' => false, 'default' => '', 'comment' => '历史审批人ID'])
            ->addColumn('check_copy_uids', 'string', ['limit' => 500, 'null' => false, 'default' => '', 'comment' => '抄送人ID'])
            ->addColumn('check_time', 'biginteger', ['null' => false, 'default' => 0, 'signed' => false, 'comment' => '审核通过时间'])
            // 用户/部门/时间戳
            ->addColumn('admin_id', 'integer', ['null' => false, 'default' => 0, 'comment' => '创建人ID'])
            ->addColumn('did', 'integer', ['null' => false, 'default' => 0, 'comment' => '创建人部门ID'])
            ->addColumn('create_time', 'biginteger', ['null' => false, 'default' => 0, 'comment' => '创建时间'])
            ->addColumn('update_time', 'biginteger', ['null' => false, 'default' => 0, 'comment' => '更新时间'])
            ->addColumn('delete_time', 'biginteger', ['null' => false, 'default' => 0, 'comment' => '删除时间'])
            ->create();
    }
}