| 12345678910111213141516171819202122 |
- 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;
|
