inner_console/sql/cso.sql

CREATE TABLE `wm_score_package` (
    `id` int NOT NULL AUTO_INCREMENT,
    `task_rule_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '规则ID',
    `drug_ent_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `score_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `score_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '积分包名称',
    `score` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `agent_type_id` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `level1_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '一级代理商',
    `level2_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '二级代理商',
    `zb_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '众包ID',
    `xxdb_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '销售代表ID',
    `typeid` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分配对象类型',
    `package_status` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '积分包状态',
    `package_finish_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '积分包完成状态',
    `package_audit_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '积分包审核状态',
    `send_package_dept_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '发包方ID',
    `dept_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '组织机构ID',
    `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否删除',
    `enable_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否禁用',
    `tenant_id` int NOT NULL DEFAULT '1' COMMENT '所属租户',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `create_user` int DEFAULT NULL COMMENT '创建人',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    `update_user` int DEFAULT NULL COMMENT '更新人',
    `ytj` int DEFAULT NULL,
    `ysh` int DEFAULT NULL,
    `dsh` int DEFAULT NULL,
    `ytjtt` int DEFAULT NULL,
    `ywctt` int DEFAULT NULL,
    `yshtt` int DEFAULT NULL,
    `receive_date` datetime DEFAULT NULL COMMENT '领取时间',
    `is_conduct` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否进行中',
    `drugs_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `statement_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '结算单号',
    `settle_status` int DEFAULT NULL COMMENT '结算状态',
    `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '结算结果描述',
    `invoice_category` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '发票类目',
    `settle_amount` decimal(30,2) DEFAULT NULL COMMENT '实际结算金额',
    `discount` decimal(11,4) DEFAULT NULL COMMENT '折扣',
    `package_finish_time` datetime DEFAULT NULL COMMENT '完成时间',
    `relation_score_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '关联积分包id',
    `package_type1` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '积分包任务类型1',
    `package_type2` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '积分包任务类型2',
    `user_num` int DEFAULT NULL COMMENT '需求人数',
    `task_num` int DEFAULT NULL COMMENT '任务个数',
    `package_user_scope` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '接单对象范围',
    `kfpjf` int DEFAULT NULL COMMENT '可分配积分',
    `belong_date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属月份',
    `allocation_date` datetime DEFAULT NULL COMMENT '分配日期',
    `pay_rate` decimal(20,2) DEFAULT NULL COMMENT '已支付百分比',
    `finish_rate` decimal(20,2) DEFAULT NULL COMMENT '已完成百分比',
    `pay_score` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '已支付积分值',
    `end_label_date` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '查询结束日期',
    `score_package_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '积分包名称',
    `related_service` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '关联服务企业',
    `package_is_conduct` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '积分包是否进行中',
    `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
    `user_score` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '个人预计包值',
    `enable_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '终止方式',
    `is_receive` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否允许接单',
    `rule_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '规则id',
    `accept_sug` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '接包对象',
    `task_add_flag` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1' COMMENT '是否可以新增任务1-可以  0-不可以',
    `settle_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '结算状态',
    `score_package_status` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '积分包状态',
    `old_package` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '是否为旧数据',
    `settlement_date` datetime DEFAULT NULL COMMENT '结算时间',
    `source_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '数据来源类型（0：手动上传，1：系统对接）',
    `project_num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '项目编号',
    `drug_producer` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '关联药品生产厂商名称',
    `p2p_amount` decimal(11,2) DEFAULT NULL,
    `p2p_time` datetime DEFAULT NULL COMMENT '公对公提交时间',
    `oms_order_sn` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '订单号',
    `sub_type` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '结算渠道',
    `sub_location` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '税源地',
    `p2p_service_amount` decimal(11,2) DEFAULT '0.00' COMMENT '公对公服务费',
    `pkg_sn` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '积分包编号',
    `mah_settle_dept_id` int DEFAULT NULL COMMENT 'MAH结算-药企deptId',
    `mah_settle_step` char(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'MAH结算-步进状态(BUSINESS-业务, FINANCE-财务)',
    `mah_settle_time` datetime DEFAULT NULL COMMENT 'mah结算时间',
    `ent_task_limit` decimal(5,2) DEFAULT '0.00' COMMENT '企业任务上限(单位%)',
    `drugtable` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '推广药品id',
    `invoice_number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '发票号码',
    `invoice_file` json DEFAULT NULL COMMENT '发票文件',
    `audit_management_fee_rates` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '审核管理费比例',
    `end_time` date DEFAULT NULL COMMENT '截止日期',
    `area` json DEFAULT NULL COMMENT '推广区域',
    PRIMARY KEY (`id`),
    KEY `代理商` (`agent_type_id`),
    KEY `代理商类型` (`drug_ent_id`),
    KEY `众包` (`zb_id`),
    KEY `一级代理商1` (`level1_id`),
    KEY `二级代理商2` (`level2_id`),
    KEY `wm_score_package_accept_sug_index` (`accept_sug`),
    KEY `wm_score_package_relation_score_id_index` (`relation_score_id`),
    KEY `wm_score_package_mah_settle_dept_id_index` (`mah_settle_dept_id`)
) ENGINE=InnoDB AUTO_INCREMENT=44417 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='积分包';

CREATE TABLE `sys_dept` (
    `dept_id` int NOT NULL AUTO_INCREMENT,
    `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `sort` int NOT NULL DEFAULT '0' COMMENT '排序',
    `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
    `parent_id` int DEFAULT NULL,
    `tenant_id` int DEFAULT NULL,
    `dept_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `level` int DEFAULT NULL COMMENT '级别',
    `level1_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '药企名称',
    `level1_id` int DEFAULT NULL COMMENT '药企ID',
    `level2_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '一级代理商名称',
    `level2_id` int DEFAULT NULL COMMENT '一级代理商ID',
    `level3_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '二级代理商名称',
    `level3_id` int DEFAULT NULL COMMENT '二级代理商ID',
    `app_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `app_secret` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `rsa_public_key` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `query_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `subject_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '结算主体',
    `subject_type` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `tax_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '税号',
    `dept_permissions` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '部门专用权限限制（字符串逗号分隔:0.导出）',
    `gmv1_rate` int DEFAULT NULL COMMENT 'gmv1收益率（万分之）',
    `gmv2_rate` int DEFAULT NULL COMMENT 'gmv2收益率（万分之）',
    `renlijia_service_charge_rate` int DEFAULT NULL COMMENT '人力家服务费（万分之）',
    `issue_date` date DEFAULT NULL COMMENT '服务起始时间',
    `expiry_date` date DEFAULT NULL COMMENT '服务截止时间',
    `financial_review_type` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '财务复核方式',
    `emails` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '邮箱(多个逗号分隔)',
    PRIMARY KEY (`dept_id`),
    UNIQUE KEY `sys_dept_dept_code_uindex` (`dept_code`)
) ENGINE=InnoDB AUTO_INCREMENT=1611890704 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='部门管理';

CREATE TABLE `sys_dept_relation` (
     `ancestor` int NOT NULL COMMENT '祖先节点',
     `descendant` int NOT NULL COMMENT '后代节点',
     KEY `idx2` (`descendant`),
     KEY `idx1` (`ancestor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='部门关系表';

CREATE TABLE `sys_user` (
    `user_id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `salt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `avatar` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `dept_id` int DEFAULT NULL COMMENT '部门ID',
    `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    `lock_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
    `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
    `wx_openid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '微信登录openId',
    `mini_openid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '小程序openId',
    `qq_openid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'QQ openId',
    `gitee_login` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '码云 标识',
    `osc_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '开源中国 标识',
    `tenant_id` int NOT NULL DEFAULT '0' COMMENT '所属租户',
    `realname` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户姓名',
    `province` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '省',
    `city` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '市',
    `area` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '区',
    `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '地址',
    `temp1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备用字段1',
    `temp2` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备用字段2',
    `temp3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备用字段3',
    `temp4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备用字段4',
    `temp5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备用字段5',
    `plat_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '平台ID',
    `drug_ent_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '药企ID',
    `w1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `id_card_number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '身份证',
    `user_sign` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '签名',
    `cert_status` int DEFAULT NULL COMMENT '认证状态',
    `cert_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '认证结果描述',
    `province_code` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '省份编码',
    `city_code` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '城市编码',
    `user_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '认证方式0-人力家 1-税邦云',
    `bank_card_number` varchar(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '银行卡号',
    `rlj_cert_status` int DEFAULT NULL COMMENT '人力家认证状态',
    `tax_helper_agreement_signature` int DEFAULT '0' COMMENT '税邦云协议签署记录 0 未签署 1 已签署',
    `bank_phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '银行预留手机号',
    `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '开户行',
    `sign_agreement` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '小程序签署协议信息',
    `age_reminder` tinyint DEFAULT '1' COMMENT '年龄超60周岁提醒',
    `re_signed_agreement` int DEFAULT '1' COMMENT '是否已补签协议',
    `gender` char(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '性别，1男，2女',
    `degree` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '学历',
    `qualification_record_number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '医药代表资质备案号',
    `qualifications_url` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '资质证书url',
    `latest_change_pwd_time` datetime DEFAULT NULL COMMENT '上次修改密码时间',
    PRIMARY KEY (`user_id`),
    KEY `user_idx1_username` (`username`),
    KEY `user_qq_openid` (`qq_openid`),
    KEY `user_wx_openid` (`wx_openid`)
) ENGINE=InnoDB AUTO_INCREMENT=11189 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户表';

CREATE TABLE `wm_score_package_settle_note` (
    `id` int NOT NULL AUTO_INCREMENT COMMENT '积分包结算记录主键id',
    `package_status_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '积分包结算状态主键id',
    `package_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '积分包id',
    `settle_amount` decimal(10,2) DEFAULT NULL COMMENT '结算金额',
    `user_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '结算用户id',
    `invoice_type` int DEFAULT NULL COMMENT '发票类型',
    `settle_no` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '结算单号',
    `discount` decimal(10,2) DEFAULT NULL COMMENT '折扣',
    `settle_note_status` int DEFAULT '0' COMMENT '结算记录状态',
    `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT '标记',
    `notify_time` datetime DEFAULT NULL COMMENT '通知时间',
    `task_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '任务ID',
    `category_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '开票类型名称',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `sub_time` datetime DEFAULT NULL COMMENT '提交时间',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    `stream_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '税邦云流水号',
    `id_card_number` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '身份证号',
    `sub_to_gig_time` datetime DEFAULT NULL COMMENT '提交到零工平台时间',
    `sub_type` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '结算类型',
    `subject_location` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '税源地',
    `third_task_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '第三方任务id',
    `finish_task_flag` int DEFAULT '0' COMMENT '是否完成完单操作',
    `actual_amount` decimal(18,2) DEFAULT NULL,
    `settle_dept_id` int DEFAULT NULL COMMENT '实际结算企业id',
    `settle_dept_sub_id` int DEFAULT NULL COMMENT '实际结算企业subId',
    `review_status` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '财务复核状态',
    `review_time` datetime DEFAULT NULL COMMENT '复核时间',
    `review_user` int DEFAULT NULL COMMENT '复核人',
    `use_financial_id` int DEFAULT NULL COMMENT '使用财务配置的主键ID',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27903 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='积分包计算记录';

CREATE TABLE `wm_score_package_status` (
   `id` int NOT NULL AUTO_INCREMENT,
   `user_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户id',
   `package_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '积分包id',
   `status` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '审核状态：1.审核中，2.审核通过，3.审核不通过',
   `dept_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '组织机构ID',
   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否删除',
   `enable_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否禁用',
   `tenant_id` int NOT NULL DEFAULT '1' COMMENT '所属租户',
   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
   `create_user` int DEFAULT NULL COMMENT '创建人',
   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
   `update_user` int DEFAULT NULL COMMENT '更新人',
   `user_score` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '个人预计包值',
   `enable_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '终止方式',
   `task_num` int DEFAULT NULL COMMENT '个人包任务个数',
   `task_add_flag` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1' COMMENT '是否可以新增任务1-可以  0-不可以',
   `quiz_res` json DEFAULT NULL COMMENT '测评结果',
   PRIMARY KEY (`id`),
   KEY `idx_pkg_id` (`package_id` DESC) COMMENT '积分包ID',
   KEY `idx_ctime` (`create_time` DESC) COMMENT '日期索引',
   KEY `idx_df` (`del_flag`),
   KEY `idx_uid` (`user_id` DESC)
) ENGINE=InnoDB AUTO_INCREMENT=55255 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='积分包状态';

CREATE TABLE `wm_da_drug_ent_drugtable` (
    `id` int NOT NULL AUTO_INCREMENT,
    `drugname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '药品名称',
    `drugname_ty` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '通用药品你名称',
    `drug_ent_id` char(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '企业ID',
    `is_yb` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否医保',
    `dose_id` char(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '剂型ID',
    `guige_id` char(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '规格ID',
    `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
    `dept_id` int DEFAULT NULL COMMENT '组织机构ID',
    `del_flag` int NOT NULL DEFAULT '0' COMMENT '是否删除',
    `enable_flag` int NOT NULL DEFAULT '0' COMMENT '是否禁用',
    `tenant_id` int NOT NULL DEFAULT '1' COMMENT '所属租户',
    `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
    `create_user` int DEFAULT NULL COMMENT '创建人',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    `update_user` int DEFAULT NULL COMMENT '更新人',
    `drug_ent_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属药企名称',
    `drug_ent_num` int DEFAULT NULL COMMENT '分配统计',
    `ssxkcyy` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '上市许可持有人',
    `yyfz` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '原验/仿制',
    `dose_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '剂型名称',
    `guige_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '规格名称',
    `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '详情信息(暂手动维护,用于报告)',
    `relate_lit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '关联问卷',
    PRIMARY KEY (`id`),
    KEY `剂型` (`dose_id`),
    KEY `药企外键` (`drug_ent_id`),
    KEY `规格` (`guige_id`)
) ENGINE=InnoDB AUTO_INCREMENT=494 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='档案-药企药品';

CREATE TABLE `sys_dict_item` (
     `id` int NOT NULL AUTO_INCREMENT COMMENT '编号',
     `dict_id` int NOT NULL,
     `value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
     `label` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
     `type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
     `description` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
     `sort` int NOT NULL DEFAULT '0' COMMENT '排序（升序）',
     `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
     `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
     `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
     `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
     `tenant_id` int NOT NULL DEFAULT '0' COMMENT '所属租户',
     PRIMARY KEY (`id`),
     KEY `sys_dict_value` (`value`),
     KEY `sys_dict_label` (`label`),
     KEY `sys_dict_del_flag` (`del_flag`)
) ENGINE=InnoDB AUTO_INCREMENT=1122 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='字典项';

CREATE TABLE `wm_da_drug_ent` (
      `id` int NOT NULL AUTO_INCREMENT,
      `entname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '企业名称',
      `entcode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '组织机构代码',
      `temp1` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `temp2` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `temp3` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `temp4` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `dept_id` int DEFAULT NULL COMMENT '组织机构ID',
      `del_flag` int NOT NULL DEFAULT '0' COMMENT '是否删除',
      `enable_flag` int NOT NULL DEFAULT '0' COMMENT '是否禁用',
      `tenant_id` int NOT NULL DEFAULT '1' COMMENT '所属租户',
      `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
      `create_user` int DEFAULT NULL COMMENT '创建人',
      `update_time` datetime DEFAULT NULL COMMENT '更新时间',
      `update_user` int DEFAULT NULL COMMENT '更新人',
      `pgqx` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '派工权限',
      `management` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '管理模式',
      `subject_type` varchar(1024) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '结算主体类型：0->人力家，1->税邦云',
      PRIMARY KEY (`id`),
      UNIQUE KEY `code` (`entcode`)
) ENGINE=InnoDB AUTO_INCREMENT=10089 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='档案-药企';

CREATE TABLE `wm_task` (
   `id` int NOT NULL AUTO_INCREMENT,
   `task_number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务编号',
   `task_rule_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '积分规则',
   `score` int DEFAULT NULL COMMENT '积分值',
   `score_package_drug_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务提交到的积分包ID',
   `score_package_level1_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务提交到一级经销商的集分宝id',
   `score_package_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '积分包',
   `task_type_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务类型ID',
   `lookinto_date` datetime DEFAULT NULL COMMENT '调研时间',
   `province` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '省',
   `city` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '市',
   `area` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '区',
   `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '地址',
   `lookinto_type_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '调研类型ID',
   `task_content_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务内容ID',
   `task_status` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务状态',
   `task_user_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务用户ID',
   `task_user_type` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户类型ID',
   `drug_ent_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '服务药企',
   `dept_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '组织机构ID',
   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否删除',
   `enable_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否禁用',
   `tenant_id` int NOT NULL DEFAULT '1' COMMENT '所属租户',
   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
   `create_user` int DEFAULT NULL COMMENT '创建人',
   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
   `update_user` int DEFAULT NULL COMMENT '更新人',
   `submit_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '提交状态',
   `share_img_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分享图片地址',
   `plat_audit_status` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '平台审核状态',
   `ext_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备用字段',
   `task_info_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务详情图片',
   `compare_result` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '对比结果',
   `approval_opinion` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '审批意见',
   `approval_info` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '审批说明',
   `real_flag` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '是否真实',
   `report_one_id` int DEFAULT NULL COMMENT '任务提交到一级cso的报告ID',
   `report_one_approval_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '任务提交到一级cso的报告审核状态',
   `report_one_approval_opinion` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务提交到一级cso的报告审批意见',
   `report_one_approval_info` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务提交到一级cso的报告审批说明',
   `report_second_id` int DEFAULT NULL COMMENT '任务提交到二级cso的报告ID',
   `report_second_approval_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '任务提交到二级cso的报告审核状态',
   `report_second_approval_opinion` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务提交到二级cso的报告审批意见',
   `report_second_approval_info` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务提交到二级cso的报告审批说明',
   `report_drug_id` int DEFAULT NULL COMMENT '任务提交到药企的报告ID',
   `report_drug_approval_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '任务提交到药企的报告审核状态',
   `report_drug_approval_opinion` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务提交到药企的报告审批意见',
   `report_drug_approval_info` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务提交到药企的报告审批说明',
   `task_status_info` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'cso审核审核意见',
   `task_from` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1' COMMENT '来源',
   `task_settle_status` int DEFAULT NULL COMMENT '任务结算状态',
   `review_task_count` int NOT NULL DEFAULT '0' COMMENT '复审次数记录',
   `dept_review_task_count` int NOT NULL DEFAULT '0' COMMENT '企业复审次数记录',
   `approval_user_id` int DEFAULT NULL COMMENT '审核人userId',
   `approval_time` datetime DEFAULT NULL COMMENT '审核时间',
   `dept_approval_user_id` int DEFAULT NULL COMMENT '企业审核人userId',
   `dept_approval_time` datetime DEFAULT NULL COMMENT '企业审核时间',
   `remote_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '远端ip',
   `ip2region` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '地址',
   `version` int NOT NULL DEFAULT '0' COMMENT '乐观锁',
   PRIMARY KEY (`id`),
   KEY `wm_task_report_one_id_index` (`report_one_id`),
   KEY `wm_task_report_drug_id_index` (`report_drug_id`),
   KEY `wm_task_score_package_id_index` (`score_package_id`),
   KEY `sp_ts_rf_index` (`score_package_id`,`real_flag`,`task_status`),
   KEY `wm_task_report_second_id_index` (`report_second_id`),
   KEY `idx_did` (`dept_id`),
   KEY `idx_ttid` (`task_type_id` DESC),
   KEY `idx_ctime` (`create_time` DESC),
   KEY `idx_tstatus` (`task_status`),
   KEY `idx_uid` (`task_user_id` DESC),
   KEY `idx_tcid` (`task_content_id` DESC),
   KEY `idx_looking_type_id` (`lookinto_type_id` DESC),
   KEY `idx_enable_flag` (`enable_flag`),
   KEY `idx_real_flag` (`real_flag`)
) ENGINE=InnoDB AUTO_INCREMENT=2191137 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='任务表';

CREATE TABLE `wm_task_type` (
    `id` int unsigned NOT NULL AUTO_INCREMENT,
    `task_type_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务类型名称',
    `task_type_level` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务类型级别',
    `task_score_start` int DEFAULT NULL COMMENT '积分范围开始',
    `task_score_end` int DEFAULT NULL COMMENT '积分范围结束',
    `score` int DEFAULT NULL COMMENT '完成后可获得分',
    `task_ent_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '积分分配代理商',
    `durgent_id` char(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '药企ID',
    `level1_id` char(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '一级代理商ID',
    `dept_id` int DEFAULT NULL COMMENT '组织机构ID',
    `del_flag` int NOT NULL DEFAULT '0' COMMENT '是否删除',
    `enable_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否禁用',
    `tenant_id` int NOT NULL DEFAULT '1' COMMENT '所属租户',
    `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
    `create_user` int DEFAULT NULL COMMENT '创建人',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    `update_user` int DEFAULT NULL COMMENT '更新人',
    `status` int DEFAULT '0' COMMENT '积分规则状态',
    `base_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '父类ID',
    `real_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `rule_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
    `parent_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '父级ID',
    `task_receiver_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1' COMMENT '承接对象(1-个人,2-企业)',
    `task_remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '任务备注',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28391 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='任务类型打分表';

CREATE TABLE `wm_da_agent` (
   `id` int NOT NULL AUTO_INCREMENT,
   `gsmc` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司名称',
   `yyzz` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '营业执照',
   `sbjnzm` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '社保缴纳证明',
   `frsfzzm_zm` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '法人身份证证明-正面',
   `frsfzzm_bm` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '法人身份证证明-背面',
   `frsfzzm_sc` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '法人身份证证明-手持',
   `is_examine` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否审核',
   `zj_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '证件类型',
   `zj_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '证件号码',
   `ext_drug_ent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '扩展可选药企',
   `dept_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '组织机构ID',
   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否删除',
   `enable_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否禁用',
   `tenant_id` int NOT NULL DEFAULT '1' COMMENT '所属租户',
   `create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
   `create_user` int DEFAULT NULL COMMENT '创建人',
   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
   `update_user` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
   `drug_ent_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属药企',
   `temp1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
   `temp2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
   `js_account` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '结算账号 ',
   `management` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '管理模式',
   `pgqx` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '派工权限',
   `qylx` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '企业类型',
   `subject_type` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
   `agent_type` char(2) COLLATE utf8mb4_general_ci NOT NULL COMMENT '代理商类型',
   `mah_settle_dept_id` int DEFAULT NULL COMMENT 'MAH结算-药企deptId',
   PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30420 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='档案-代理商';

CREATE TABLE `sys_financial_gmv_settle_data` (
     `id` int NOT NULL AUTO_INCREMENT,
     `payment_company` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '客户公司名称',
     `company_type` varchar(8) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '公司类型',
     `service_rate` decimal(10,4) NOT NULL COMMENT '要易服务费率',
     `is_channel` tinyint(1) NOT NULL COMMENT '渠道标识',
     `channel_commission_rate` decimal(10,4) NOT NULL COMMENT '渠道税率',
     `tax_land_rate` json NOT NULL COMMENT '底价',
     `in_use_tag` tinyint(1) NOT NULL COMMENT '当前使用标识',
     `gmt_operates` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '操作人员',
     `gmt_modified` datetime NOT NULL COMMENT '修改时间',
     PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=291 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='GMV财务数据配置表';

CREATE TABLE `sys_dept_sub` (
    `sub_id` int NOT NULL AUTO_INCREMENT,
    `dept_id` int NOT NULL,
    `subject_type` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '认证方式0-人力家 1-税邦云',
    `subject_channel` int NOT NULL DEFAULT '0' COMMENT '结算通道',
    `subject_location` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '税源地',
    `app_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
    `app_secret` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `rsa_public_key` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `query_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `subject_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '结算主体',
    `limit_amount` decimal(18,2) DEFAULT NULL,
    `enable_flag` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
    `subject_user_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '税邦云用户类型id',
    `subject_invoice_category` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '税邦云用户类型对应的发票类目',
    `path_no` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '汇企云批次付款渠道编号',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    `service_charge` decimal(4,2) NOT NULL DEFAULT '0.00' COMMENT '费率',
    `cert_enable` tinyint DEFAULT '1' COMMENT '认证是否启用：1：启用，0：停用',
    `settle_enable` tinyint DEFAULT '1' COMMENT '结算是否启用：1：启用，0：停用',
    `eid_enable` tinyint DEFAULT '1' COMMENT 'E证通认证是否启用：1-启用，0-停用',
    PRIMARY KEY (`sub_id`)
) ENGINE=InnoDB AUTO_INCREMENT=331 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='部门结算主体管理';

CREATE TABLE `sys_user_sub` (
    `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    `user_id` int NOT NULL COMMENT '用户ID',
    `dept_id` int DEFAULT NULL COMMENT '部门id',
    `gig_type` int NOT NULL COMMENT '零工平台类型（订单支付方式类型:0-人力家 1-税邦云 2-自由职家 3-易联数科）',
    `gig_channel` int DEFAULT '0' COMMENT '渠道',
    `subject_location` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '税源地',
    `callback_status` int DEFAULT '0' COMMENT '回调状态 0 是未发起，1是进行中，2是已回调',
    `cert_status` int NOT NULL DEFAULT '0' COMMENT '认证状态  0 : 未签约; 1 : 已认证; 2 : 已签约',
    `cert_remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '认证结果描述',
    `fail_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '认证失败原因',
    `user_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '人员类型',
    `bank_card_number` varchar(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '银行卡号',
    `bank_phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '银行预留手机号',
    `bank_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '开户行',
    `id_card_front_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '身份证照片-正面',
    `id_card_back_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '身份证照片-反面',
    `cert_video1_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '认证视频1',
    `cert_video2_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '认证视频1',
    `agreement_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '协议',
    `request_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求流水号',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `create_user` int DEFAULT NULL COMMENT '创建人',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    `update_user` int DEFAULT NULL COMMENT '更新人',
    `callback_time` datetime DEFAULT NULL COMMENT '回调时间',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15132 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户签约认证主体信息表';

CREATE TABLE `sys_user_role` (
     `user_id` int NOT NULL COMMENT '用户ID',
     `role_id` int NOT NULL COMMENT '角色ID',
     PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户角色表';

CREATE TABLE `sys_role` (
    `role_id` int NOT NULL AUTO_INCREMENT,
    `role_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `role_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `role_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ds_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '2',
    `ds_scope` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `update_time` datetime DEFAULT NULL,
    `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
    `tenant_id` int DEFAULT NULL,
    PRIMARY KEY (`role_id`),
    KEY `role_idx1_role_code` (`role_code`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统角色表';

CREATE TABLE `wm_user_plat_quiz_res` (
     `res_id` int NOT NULL AUTO_INCREMENT COMMENT 'Id',
     `user_id` int NOT NULL COMMENT '用户ID',
     `quiz_id` int DEFAULT NULL COMMENT '试卷id',
     `quiz_res` json DEFAULT NULL COMMENT '测试结果',
     `res_expiry` date NOT NULL COMMENT '测评有效期',
     `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
     PRIMARY KEY (`res_id`),
     KEY `idx_qid` (`quiz_id`),
     KEY `idx_uid` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC COMMENT='用户测评的评判结果';

CREATE TABLE `sys_impl_plan` (
     `plan_id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
     `plan_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '计划名称',
     `plan_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '计划类型',
     `plan_state` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '计划类型',
     `disassemble_state` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '拆解状态',
     `plan_score` bigint NOT NULL DEFAULT '0' COMMENT '计划值',
     `avail_score` bigint NOT NULL DEFAULT '0' COMMENT '可用值',
     `plan_issue` date NOT NULL COMMENT '签发时间',
     `plan_expiry` date NOT NULL COMMENT '截止日期',
     `parent_id` bigint NOT NULL COMMENT '父ID',
     `consignor_id` bigint NOT NULL COMMENT '委托人ID',
     `consignee_id` bigint NOT NULL COMMENT '受托人ID',
     `sku_id` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '产品ID',
     `ckt_res` tinyint(1) DEFAULT NULL COMMENT '审核结果',
     `ckt_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '审核意见',
     `ckt_time` datetime DEFAULT NULL COMMENT '审核时间',
     `ckt_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '审核人用户名',
     `loc_flag` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '锁定标记',
     `del_flag` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '删除标记',
     `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人',
     `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '修改人',
     `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
     `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
     PRIMARY KEY (`plan_id`),
     UNIQUE KEY `uk_name` (`plan_name`,`consignor_id`),
     KEY `sys_impl_plan_parent_id_index` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='执行计划';