java-insagent-pc/sql/Online.sql

--  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='抽成比例修改表';