sxzgd
/
java-insagent-pc


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172
							--  add by hxl   2024-04-27 添加 后线人员关联区域表
DROP TABLE IF EXISTS `sys_user_link_area`;
CREATE TABLE `sys_user_link_area`  (
                                       `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键/自增',
                                       `user_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户id',
                                       `area_code` int(11) NULL DEFAULT NULL COMMENT '区域编码',
                                       `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人ID',
                                       `create_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人名称',
                                       `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
                                       `update_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人ID',
                                       `update_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人名称',
                                       `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
                                       PRIMARY KEY (`id`) USING BTREE,
                                       INDEX `user_id_index`(`user_id`) USING BTREE COMMENT '用户id索引',
                                       INDEX `area_code_index`(`area_code`) USING BTREE COMMENT '部门code索引'
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '后线人员关联区域表' ROW_FORMAT = Dynamic;


--    2024-04-25  wuhp
ALTER TABLE `ins_ply_income`
    MODIFY COLUMN `handling_fees_status` varchar (5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手续费结算状态  1 为已结算 2 已开票' AFTER `contract_file_id`,
    MODIFY COLUMN `documentary_fees_status` varchar (5) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '跟单费结算状态  1 为已结算 2 已开票' AFTER `no_policyno`;


ALTER TABLE `ins_ply_income` ADD COLUMN `invoic_amount` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '开票金额' AFTER `is_not_documentary`;
ALTER TABLE `ins_ply_income` ADD COLUMN `invoic_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '开票号' AFTER `invoic_amount`;
ALTER TABLE `ins_ply_income` ADD COLUMN `tax_premium` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '含税保费' AFTER `invoic_id`;
ALTER TABLE `ins_ply_income` ADD COLUMN `jq_supervise_costs_premiums` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强手续费' AFTER `tax_premium`;
ALTER TABLE `ins_ply_income` ADD COLUMN `jq_supervise_costs_proportion` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强手续费比例' AFTER `jq_supervise_costs_premiums`;
ALTER TABLE `ins_ply_income` ADD COLUMN `sy_supervise_costs_premiums` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业手续费' AFTER `jq_supervise_costs_proportion`;
ALTER TABLE `ins_ply_income` ADD COLUMN `sy_supervise_costs_proportion` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业手续费比例' AFTER `sy_supervise_costs_premiums`;
ALTER TABLE `ins_ply_income` ADD COLUMN `no_supervise_costs_premiums` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车手续费' AFTER `sy_supervise_costs_proportion`;
ALTER TABLE `ins_ply_income` ADD COLUMN `no_supervise_costs_proportion` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车手续费比例' AFTER `no_supervise_costs_premiums`;
ALTER TABLE `ins_ply_income` ADD COLUMN `jq_premium` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强险含税保费' AFTER `no_supervise_costs_proportion`;
ALTER TABLE `ins_ply_income` ADD COLUMN `sy_premium` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业险含保费' AFTER `jq_premium`;
ALTER TABLE `ins_ply_income` ADD COLUMN `no_premium` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车险含保费' AFTER `sy_premium`;
ALTER TABLE `ins_ply_income` ADD COLUMN `jq_no_tax_premium` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强险不含税保费' AFTER `no_premium`;
ALTER TABLE `ins_ply_income` ADD COLUMN `sy_no_tax_premium` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业险不含税保费' AFTER `jq_no_tax_premium`;
ALTER TABLE `ins_ply_income` ADD COLUMN `no_no_tax_premium` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车险不含税保费' AFTER `sy_no_tax_premium`;
ALTER TABLE `ins_ply_income` ADD COLUMN `jq_receivable_proportion` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强应收比例' AFTER `no_no_tax_premium`;
ALTER TABLE `ins_ply_income` ADD COLUMN `sy_receivable_proportion` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业应收比例' AFTER `jq_receivable_proportion`;
ALTER TABLE `ins_ply_income` ADD COLUMN `no_receivable_proportion` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车应收比例' AFTER `sy_receivable_proportion`;

ALTER TABLE `ins_ply_income` ADD COLUMN `jq_other_costs_proportion` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强跟单比例' AFTER `no_receivable_proportion`;
ALTER TABLE `ins_ply_income` ADD COLUMN `sy_other_costs_proportion` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业跟单比例' AFTER `jq_other_costs_proportion`;
ALTER TABLE `ins_ply_income` ADD COLUMN `no_other_costs_proportion` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车跟单比例' AFTER `sy_other_costs_proportion`;
ALTER TABLE `ins_ply_income` ADD COLUMN `settlement_time` datetime NULL DEFAULT NULL COMMENT '结算日期' AFTER `no_other_costs_proportion`;
ALTER TABLE `ins_ply_income` ADD COLUMN `update_time` datetime NULL DEFAULT NULL COMMENT '修改日期' AFTER `settlement_time`;
ALTER TABLE `ins_ply_income` ADD COLUMN `settlement_user_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '结算人id' AFTER `update_time`;
ALTER TABLE `ins_ply_income` ADD COLUMN `update_user_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '修改用户id' AFTER `settlement_user_id`;

ALTER TABLE `ins_ply_income` ADD COLUMN `jq_other_costs_premium` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强跟单金额' AFTER `update_user_id`;
ALTER TABLE `ins_ply_income` ADD COLUMN `sy_other_costs_premium` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业跟单金额' AFTER `jq_other_costs_premium`;
ALTER TABLE `ins_ply_income` ADD COLUMN `no_other_costs_premium` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车跟单金额' AFTER `sy_other_costs_premium`;
ALTER TABLE `ins_ply_income` ADD COLUMN `user_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '被保人' AFTER `no_other_costs_premium`;

ALTER TABLE `ins_ply_income` ADD COLUMN `company_name` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '保险公司名称' AFTER `user_id`;
ALTER TABLE `ins_ply_income` ADD COLUMN `partner_companies_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '合作公司id' AFTER `company_name`;
ALTER TABLE `ins_ply_income` ADD COLUMN `partner_companies_name` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '合作公司名称' AFTER `partner_companies_id`;

ALTER TABLE `settlement_documentary_log` ADD COLUMN `ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '结算ids' AFTER `crud_status`;
ALTER TABLE `settlement_documentary_log` ADD COLUMN `company_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '保险公司id' AFTER `ids`;
ALTER TABLE `ins_ply_income` ADD COLUMN `receivable_amount` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '应收金额' AFTER `partner_companies_name`;

ALTER TABLE `settlement_documentary_fees` ADD COLUMN `year` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '结算年度' AFTER `signing_time`;
ALTER TABLE `settlement_documentary_fees` ADD COLUMN `month` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '结算月份' AFTER `signing_time`;
ALTER TABLE `settlement_documentary_fees` ADD COLUMN `day` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '结算日期' AFTER `signing_time`;
ALTER TABLE `settlement_documentary_fees` ADD COLUMN `agree_ment_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '协议di' AFTER `day`;

ALTER TABLE `ins_ply_income` ADD COLUMN `invoic_time` datetime NULL DEFAULT NULL COMMENT '开票时间' AFTER `receivable_amount`;
ALTER TABLE `settlement_documentary_fees` ADD COLUMN `settlement_status` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '状态  1 开票 2结算' AFTER `year`;
ALTER TABLE `settlement_documentary_fees` ADD COLUMN `ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '结算ids' AFTER `settlement_status`;