| 123456789101112131415161718192021222324 |
- -- add by hxl 2024-07-05 部门提现表添加审核时间
- ALTER TABLE `sys_dept_account_withdraw` ADD COLUMN `auditing_time` datetime DEFAULT NULL COMMENT '部门提现审核时间';
- -- add by hxl 机构账户表添加
- ALTER TABLE `sys_dept_account` ADD COLUMN `sum_amount_withdrawal` decimal(10,2) DEFAULT 0 COMMENT '提现总金额';
- ALTER TABLE `sys_dept_account` ADD COLUMN `sum_amount_account` decimal(10,2) DEFAULT 0 COMMENT '已到账总金额';
- ALTER TABLE `sys_dept_account` ADD COLUMN `sum_amount_payment` decimal(10,2) DEFAULT 0 COMMENT '支付中总金额';
- -- add by hxl 部门账户历史表添加部门提现审核id
- ALTER TABLE `sys_dept_account_history` ADD COLUMN `auditing_id` varchar(30) DEFAULT NULL COMMENT '部门提现审核Id';
- ALTER TABLE `sys_dept_account_history` ADD COLUMN `business_eegments_type` int DEFAULT NULL COMMENT '业务版块';
- ALTER TABLE `sys_dept_account_history` ADD COLUMN `property` int DEFAULT NULL COMMENT '金钱属性 5退款 6 提现';
- -- add by hxl 部门审核轨迹表
- DROP TABLE IF EXISTS `sys_amount_auditing_dept_history`;
- CREATE TABLE `sys_amount_auditing_dept_history` (
- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
- `amount_auding_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核表id',
- `amount` decimal(10, 2) NOT NULL COMMENT '提现金额',
- `dept_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '机构Id',
- `create_time` datetime NOT NULL COMMENT '创建时间',
- `auditing_status` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '审核状态 1 提现申请 2.处理中 3.驳回 4.提现成功',
- `amount_status` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '金额类型 1 提现',
- `history_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '历史记录表id',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门审核轨迹表' ROW_FORMAT = Dynamic;
|
