alter table sys_dept
    add financial_review_type char(10) default 'AUTO' null comment '财务复核方式';

create table wm_score_package_settle_financial_review
(
    id             int auto_increment
        primary key,
    package_id     varchar(1024)                      not null comment '积分包id',
    username       varchar(64)                        not null comment '结算人员手机号',
    realname       varchar(64)                        not null comment '结算人员姓名',
    id_card_number varchar(20)                        not null comment '身份证号',
    package_number int                                not null comment '积分包个数',
    settle_amount  decimal(11, 2)                     not null comment '实际结算金额(不带服务费)',
    actual_amount  decimal(11, 2)                     not null comment '实际支付金额(带服务费)',
    remark         varchar(256)                       null comment '备注',
    review_time    datetime                           null comment '复核时间',
    review_user    int                                null comment '复核人',
    review_status  char(10)                           null comment '复核状态',
    create_time    datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time    datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '修改时间'
)
    comment '积分包结算财务复核功能' charset = utf8mb4;