# 子订单 alter table ins_area_company add leader_id varchar(64) null comment '维护人工号'; alter table ins_area_company add leader_name varchar(64) null comment '维护人'; -- 2024-10-15 BY dongxin statr ALTER TABLE `agent`.`ins_fee_telemarketing` ADD COLUMN `jq_total_proportion` decimal(10, 2) NULL DEFAULT NULL COMMENT '交强优惠比例' AFTER `create_time`, ADD COLUMN `sy_total_proportion` decimal(10, 2) NULL DEFAULT NULL COMMENT '商业优惠比例' AFTER `jq_total_proportion`, ADD COLUMN `no_total_proportion` decimal(10, 2) NULL DEFAULT NULL COMMENT '非车优惠比例' AFTER `sy_total_proportion`, ADD COLUMN `first_jq_total_proportion` decimal(10, 2) NULL DEFAULT NULL COMMENT '初始交强优惠比例' AFTER `no_total_proportion`, ADD COLUMN `first_sy_total_proportion` decimal(10, 2) NULL DEFAULT NULL COMMENT '初始商业优惠比例' AFTER `first_jq_total_proportion`, ADD COLUMN `first_no_total_proportion` decimal(10, 2) NULL DEFAULT NULL COMMENT '初始非车优惠比例' AFTER `first_sy_total_proportion`; -- 2024-10-15 BY dongxin end -- 2024-10-16 BY helixiao CREATE TABLE `sys_premium_details` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id', `orderno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '订单号', `company_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '子订单id', `user_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户id', `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户名称', `issuer_id` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '代理人 id', `issuer_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '代理人name', `jqpremium` decimal(10,5) unsigned DEFAULT NULL COMMENT '交强险费用', `sypremium` decimal(10,5) unsigned DEFAULT NULL COMMENT '商业险费用', `jypremium` decimal(10,5) unsigned DEFAULT NULL COMMENT '驾意险费用', `sumpremium` decimal(10,5) unsigned DEFAULT NULL COMMENT '总保费', `proportional` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '抽成比例（总保费抽成）', `extract_fee` decimal(10,5) unsigned DEFAULT NULL COMMENT '抽成费用', `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态(0:未审核 1：审核通过)', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `type` tinyint DEFAULT NULL COMMENT '类型：1前线人员 2后线人员', `industry_sector` tinyint DEFAULT NULL COMMENT '行业领域 1：汽车-车险', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='合伙人、工作室管理员保费抽成明细表'; CREATE TABLE `sys_partner_account` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id', `user_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户id', `sum_Premium` decimal(10,5) unsigned DEFAULT NULL COMMENT '总保费', `extract_fee` decimal(10,5) unsigned DEFAULT NULL COMMENT '抽成费用', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `history_fee` decimal(10,5) DEFAULT NULL COMMENT '已提现费用', `cash_fee` decimal(10,5) DEFAULT NULL COMMENT '可提现抽成费用', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='合伙人、工作室管理人员抽层账户表'; CREATE TABLE `sys_partner_config` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id', `logo` mediumblob COMMENT '图标', `image` mediumblob COMMENT '背景', `level` tinyint DEFAULT NULL COMMENT '等级', `del_flag` tinyint NOT NULL DEFAULT '1' COMMENT '状态（ 0：删除 1：正常）', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='合伙人APP等级背景配置表'; CREATE TABLE `sys_partner_time` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id', `user_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户id', `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户name', `old_proportional` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '旧比例', `new_proportional` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '新比例', `create_time` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '月份', `type` tinyint DEFAULT NULL COMMENT '类型1合伙人 2工作室管理员', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='抽成比例修改表'; -- 2024-10-18 BY WeiRuiJie ALTER TABLE `sys_qy_wechat` ADD COLUMN `support_staff_url` varchar(500) NULL COMMENT '客服URL'; ALTER TABLE `agent`.`sys_user` ADD COLUMN `dept_type` varchar(30) NULL COMMENT '机构类型（股份，直营，加盟）', ADD COLUMN `referrer_id` varchar(30) NULL COMMENT '推荐人id'; -- 2024.11.1 -- ALTER TABLE `agent`.`sys_user` ADD COLUMN `identity_time` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证有效期' AFTER `identity`; CREATE TABLE `pay_payment_notice` ( `id` bigint NOT NULL, `type` varchar(255) DEFAULT NULL COMMENT '通知类型', `mch_order_no` varchar(255) DEFAULT NULL COMMENT '商户订单号', `order_no` varchar(255) DEFAULT NULL COMMENT '天天企赋业务订单号', `amount` decimal(15,2) DEFAULT NULL COMMENT '打款金额', `fee_amount` decimal(15,2) DEFAULT NULL COMMENT '服务费', `status` tinyint NOT NULL DEFAULT '0' COMMENT '订单状态', `message` varchar(255) DEFAULT NULL COMMENT '状态描述', `pay_time` datetime DEFAULT NULL COMMENT '打款时间', `create_time` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `pay_sign_callback` ( `id` int NOT NULL, `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '默认值：PRESIGN', `org_req_id` bigint DEFAULT NULL COMMENT '最后一次请求', `name` varchar(255) DEFAULT NULL, `mobile` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `id_card_no` varchar(255) DEFAULT NULL, `bank_card_no` varchar(255) DEFAULT NULL, `bank_name` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `auth_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '认证状态:0-未实名1-已实名', `sign_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '签约状态:0-未签约1-已签约', `bind_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT ' 绑卡状态:0-未绑定1-已绑定', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户签约回调'; CREATE TABLE `pay_ttqf_confirm` ( `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户ID', `biz_msg` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '返回信息', `biz_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务响应码', `batch_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '天天企赋业务批次号', `mch_batch_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '商户批次号', `total_mount` decimal(10,2) DEFAULT NULL COMMENT '计划打款总金额', `total_fee_amount` decimal(10,2) DEFAULT NULL COMMENT '总服务费服务费', `create_time` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `pay_ttqf_log` ( `id` varchar(255) NOT NULL, `user_id` varchar(255) DEFAULT NULL COMMENT '用户ID', `sed_status` tinyint NOT NULL DEFAULT '0' COMMENT '是否发送成功0-失败', `api_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '请求url', `request_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '请求数据', `response_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '响应数据', `mch_batch_no` varchar(255) DEFAULT NULL COMMENT '商户批次号', `mch_order_no` varchar(255) DEFAULT NULL COMMENT '商户订单号', `amount` decimal(10,2) DEFAULT NULL COMMENT '打款金额', `fee_amount` decimal(10,2) DEFAULT NULL COMMENT '服务费', `batch_no` varchar(255) DEFAULT NULL COMMENT '天天企赋业务批次号', `order_no` varchar(255) DEFAULT NULL COMMENT '天天企赋业务订单号', `payment_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '打款方式', `biz_msg` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '返回信息', `biz_code` varchar(255) DEFAULT NULL, `confirm` tinyint(1) NOT NULL DEFAULT '0' COMMENT '确认打款1-已确认', `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `pay_user_sign` ( `id` bigint NOT NULL, `user_id` varchar(255) DEFAULT NULL COMMENT '用户ID', `sign` tinyint NOT NULL DEFAULT '0' COMMENT '签约1-是', `online_payment` tinyint NOT NULL DEFAULT '0' COMMENT '线上支付1-是', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2024.11.1 xuqiang -- -- 2024.11.4 helixiao -- ALTER TABLE `agent`.`sys_premium_details` ADD COLUMN `licenseno` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '车牌号'; ALTER TABLE `agent`.`sys_premium_details` ADD COLUMN `source` tinyint DEFAULT NULL COMMENT '费用来源(1，2,3,4,5级)'; -- 2024.11.11 dongxin -- CREATE TABLE `sys_user_agent_track` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id', `user_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户id', `status` tinyint NULL DEFAULT NULL COMMENT '状态 0.注册 1.认证成功 2.认证失败 3.审核成功 4.审核失败', `approve_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核人Id', `approve_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核人', `approve_mess` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核认证信息', `create_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_sys_user_track_user_id`(`user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 571 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '个代用户认证审核轨迹表' ROW_FORMAT = DYNAMIC; -- 20241114 huihui -- CREATE TABLE `send_collect_history` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `bank_number` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '银行卡号', `amount` decimal(10,2) DEFAULT NULL COMMENT '提现金额', `user_info` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '提现用户信息', `collect_id` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '提现单号', `collect_time` datetime DEFAULT NULL COMMENT '提现时间', `send_state` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '推送状态 0-失败 1-成功 2-推送中', `fail_num` int DEFAULT NULL COMMENT '失败次数', `tran_type` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '交易类型 0-提现 1-退款', `http_post` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'post请求', `http_response` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求响应', `send_uuid` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '推送uuid', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='推送提现记录历史表'; CREATE TABLE `send_project_history` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `http_post` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'post请求', `total_amount` decimal(10,2) DEFAULT NULL COMMENT '出口费用总金额/发放预算', `user_name` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户姓名', `user_car_num` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户车牌号', `user_phone` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户手机号', `http_response` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求响应', `send_state` varchar(1) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '推送状态 0-推送失败 1-推送成功 2-推送中 9-未知', `send_uuid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '唯一编码', `fail_num` int DEFAULT NULL COMMENT '失败次数', `referrer_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '推荐人工号', `user_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '归属人工号', `state` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1' COMMENT '数据是否有效 0-否 1-是', `is_delete` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '数据是否删除 0-否 1-是', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改者', `update_time` datetime DEFAULT NULL COMMENT '修改时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='推送用工平台服务历史记录表'; -- 2024-11-15 协议修改时间格式-- ALTER TABLE `agent`.`ptl_agreement` MODIFY COLUMN `start_date` datetime NOT NULL COMMENT '协议起期' AFTER `insurance_company_id`, MODIFY COLUMN `end_date` datetime NOT NULL COMMENT '协议止期' AFTER `start_date`;