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;