zhijiayun/database/schema/mysql-schema.dump

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `jd_provider_tmp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jd_provider_tmp` (
  `name` varchar(64) NOT NULL DEFAULT '',
  `company_name` varchar(64) NOT NULL DEFAULT '' COMMENT '公司名',
  `province_name` varchar(64) NOT NULL DEFAULT '',
  `city_name` varchar(64) NOT NULL DEFAULT '',
  `addr` varchar(128) NOT NULL DEFAULT '',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `mt_shop_info_middle`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt_shop_info_middle` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `shop` varchar(255) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `contact_address` varchar(255) NOT NULL DEFAULT '' COMMENT '联系地址',
  `qualification_number` varchar(255) NOT NULL DEFAULT '' COMMENT '资质编号',
  `business_license_company` varchar(255) NOT NULL DEFAULT '' COMMENT '营业执照公司名称',
  `business_license_address` varchar(255) NOT NULL DEFAULT '' COMMENT '营业执照地址',
  `scrape_date` date DEFAULT NULL COMMENT '爬取日期',
  `platform` varchar(255) NOT NULL DEFAULT '' COMMENT '平台',
  `province` varchar(255) NOT NULL DEFAULT '' COMMENT '省',
  `city` varchar(255) NOT NULL DEFAULT '' COMMENT '市',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '写入时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `shop_index` (`shop`) USING BTREE COMMENT '店铺名称唯一'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='美团店铺信息';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `pdd_shop_info_middle`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pdd_shop_info_middle` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `shop` varchar(255) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `contact_address` varchar(255) NOT NULL DEFAULT '' COMMENT '联系地址',
  `qualification_number` varchar(255) NOT NULL DEFAULT '' COMMENT '资质编号',
  `business_license_company` varchar(255) NOT NULL DEFAULT '' COMMENT '营业执照公司名称',
  `business_license_address` varchar(255) NOT NULL DEFAULT '' COMMENT '营业执照地址',
  `store_url` varchar(255) NOT NULL DEFAULT '' COMMENT '商品链接',
  `scrape_date` date DEFAULT NULL COMMENT '爬取日期',
  `platform` varchar(255) NOT NULL DEFAULT '' COMMENT '平台',
  `province` varchar(255) NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(255) NOT NULL DEFAULT '' COMMENT '城市',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '写入时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `shop_indx` (`shop`) USING BTREE COMMENT '店铺名称唯一'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='拼多多店铺信息';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_admin` (
  `uid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '用户名',
  `phone` varchar(11) NOT NULL DEFAULT '' COMMENT '手机号',
  `password` char(32) NOT NULL DEFAULT '' COMMENT '密码',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态，0启用，1禁用',
  `is_super` tinyint(3) NOT NULL DEFAULT '0' COMMENT '是否超管',
  `insert_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`uid`) USING BTREE,
  UNIQUE KEY `username_UNIQUE` (`username`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_admin_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_admin_history` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `company_name` varchar(100) NOT NULL DEFAULT '' COMMENT '品牌方公司名称',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `user_name` varchar(50) NOT NULL DEFAULT '' COMMENT '用户名称',
  `employee_id` int(11) NOT NULL DEFAULT '0' COMMENT '员工ID',
  `is_admin` tinyint(3) NOT NULL DEFAULT '1' COMMENT '是否为管理员账号1=是0=否',
  `admin_uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作管理员',
  `module_menu_name` varchar(100) NOT NULL DEFAULT '' COMMENT '模块菜单名称',
  `notes_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '操作类型，1添加，2修改，3=删除',
  `general_description` varchar(255) NOT NULL DEFAULT '' COMMENT '概况描述',
  `table_name` varchar(255) NOT NULL DEFAULT '' COMMENT '表名',
  `before_value` text COMMENT '更改前',
  `after_value` text COMMENT '更改后',
  `insert_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '写入时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='操作历史';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_attachment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_attachment` (
  `id` int(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `category` varchar(50) DEFAULT '' COMMENT '类别:image=图片,voice=音频,video=视频,file=文件',
  `url` varchar(255) DEFAULT '' COMMENT '物理路径',
  `imagewidth` int(10) unsigned DEFAULT '0' COMMENT '宽度',
  `imageheight` int(10) unsigned DEFAULT '0' COMMENT '高度',
  `imagetype` varchar(30) DEFAULT '' COMMENT '图片类型',
  `filename` varchar(100) DEFAULT '' COMMENT '文件名称',
  `filesize` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `mimetype` varchar(100) DEFAULT '' COMMENT 'mime类型',
  `createtime` bigint(16) DEFAULT NULL COMMENT '创建日期',
  `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
  `storage` varchar(100) NOT NULL DEFAULT 'local' COMMENT '存储位置',
  `sha1` varchar(128) DEFAULT '' COMMENT '文件 sha1编码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='附件表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_auth_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_auth_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户组id,自增主键',
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '权限组名称',
  `description` varchar(80) NOT NULL DEFAULT '' COMMENT '描述信息',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  `insert_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '写入时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限组';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_auth_group_access`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_auth_group_access` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '权限组ID',
  `admin_uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '管理员id',
  `insert_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '写入时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `fk_auth_group_access_group_id_idx` (`group_id`) USING BTREE,
  KEY `fk_auth_group_access_user_uid_idx` (`admin_uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户权限组';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_auth_rule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_auth_rule` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '规则id,自增主键',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '路径',
  `group_id` mediumint(8) unsigned NOT NULL,
  `menu_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `fk_auth_rule_edu_auth_group1_idx` (`group_id`) USING BTREE,
  KEY `fk_auth_rule_edu_menu1_idx` (`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限组权限规则表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_city`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_city` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '名称',
  `pid` int(11) NOT NULL DEFAULT '0' COMMENT '父ID',
  `code` varchar(50) NOT NULL DEFAULT '' COMMENT '地区编码',
  `level` tinyint(3) NOT NULL DEFAULT '1' COMMENT '地区等级',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态0=启用1=停用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='地区表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_city_zoning`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_city_zoning` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `zoning_name` varchar(100) NOT NULL DEFAULT '' COMMENT '分区名称',
  `province_ids` text COMMENT '省份ID集合',
  `insert_time` int(11) NOT NULL DEFAULT '0' COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态0=开启1=关闭',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='地理大区表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_collect_equipment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_collect_equipment` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '设备名称',
  `device_id` varchar(30) NOT NULL DEFAULT '' COMMENT '设备终端ID',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态，0启用，1禁用',
  `task_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态，0未占用，1已占用',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='采集设备表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_collect_equipment_account`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_collect_equipment_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `collect_equipment_id` int(10) NOT NULL COMMENT '设备id',
  `collect_region_id` int(10) NOT NULL COMMENT '区域id',
  `platform` tinyint(3) NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `username` varchar(100) NOT NULL DEFAULT '' COMMENT '账号名',
  `password` varchar(255) NOT NULL DEFAULT '' COMMENT '账号密码',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态，0启用，1禁用',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='采集设备账号';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_collect_platform_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_collect_platform_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `platform` tinyint(3) NOT NULL DEFAULT '0' COMMENT '平台',
  `duration` int(10) NOT NULL COMMENT '设备每次运行时长（分钟）',
  `rest_duration` int(10) NOT NULL DEFAULT '0' COMMENT '运行后休息时长',
  `day_number` int(10) NOT NULL DEFAULT '0' COMMENT '每天运行次数',
  `minute_size` int(10) NOT NULL DEFAULT '0' COMMENT '每分钟采集数量',
  `page_size` int(10) NOT NULL DEFAULT '0' COMMENT '每页数量',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态，0启用，1禁用',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='采集平台配置表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_collect_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_collect_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `platform` varchar(100) NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `enable_full_quantity` tinyint(3) DEFAULT '1' COMMENT '全量，0启用，1禁用',
  `product_brand` varchar(150) NOT NULL DEFAULT '' COMMENT '商品品牌',
  `product_name` varchar(100) NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` text COMMENT '产品规格集合',
  `product_specs_number` int(11) NOT NULL DEFAULT '1' COMMENT '规格数量',
  `minimum_order_quantity` int(11) NOT NULL DEFAULT '1' COMMENT '最小起购量',
  `sampling_cycle` tinyint(3) NOT NULL DEFAULT '1' COMMENT '采集周期天数',
  `round_number` tinyint(11) NOT NULL DEFAULT '1' COMMENT '轮次数量',
  `sampling_start_time` int(11) NOT NULL DEFAULT '0' COMMENT '采集开始时间',
  `sampling_end_time` int(11) NOT NULL DEFAULT '0' COMMENT '采集结束时间',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态，0启用，1禁用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='采集商品配置表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_collect_product_keyword`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_collect_product_keyword` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `keyword` varchar(150) NOT NULL DEFAULT '' COMMENT '关键字',
  `collect_product_id` int(11) NOT NULL DEFAULT '0' COMMENT '采集商品ID',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='采集商品关键字表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_collect_region`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_collect_region` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '区域名称',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态，0启用，1禁用',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='采集区域表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_collect_task`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_collect_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(10) NOT NULL DEFAULT '0' COMMENT '商户ID',
  `collect_product_id` int(10) NOT NULL DEFAULT '0' COMMENT '采集中心任务id',
  `platform` int(10) NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `product_name` varchar(100) NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) NOT NULL DEFAULT '' COMMENT '产品规格',
  `product_brand` varchar(100) NOT NULL DEFAULT '' COMMENT '产品品牌',
  `product_keyword` varchar(255) NOT NULL COMMENT '产品关键词',
  `minimum_order_quantity` int(11) NOT NULL DEFAULT '1' COMMENT '最小起购量',
  `sampling_start_time` int(11) NOT NULL DEFAULT '0' COMMENT '采集开始时间',
  `sampling_end_time` int(11) NOT NULL DEFAULT '0' COMMENT '采集结束时间',
  `max_equipment_number` int(10) NOT NULL DEFAULT '0' COMMENT '最多分配设备数量',
  `equipment_number` int(10) NOT NULL DEFAULT '0' COMMENT '已分配设备数量',
  `sampling_cycle` int(3) NOT NULL DEFAULT '1' COMMENT '采集周期天数',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态，0未开始，1进行中，2已完成',
  `allocate_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态，0未分配，1未分配完，2已分配完',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='采集任务执行表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_collect_task_allocate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_collect_task_allocate` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `collect_task_id` int(10) NOT NULL DEFAULT '0' COMMENT '采集任务id',
  `collect_equipment_id` int(10) NOT NULL DEFAULT '0' COMMENT '设备ID',
  `company_id` int(10) NOT NULL DEFAULT '0' COMMENT '企业ID',
  `platform` varchar(100) NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `product_name` varchar(100) NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) NOT NULL DEFAULT '' COMMENT '产品规格',
  `product_brand` varchar(100) NOT NULL DEFAULT '' COMMENT '品牌',
  `product_keyword` varchar(255) NOT NULL COMMENT '产品关键词',
  `minimum_order_quantity` int(11) NOT NULL DEFAULT '1' COMMENT '最小起购量',
  `sampling_cycle` int(3) NOT NULL DEFAULT '1' COMMENT '采集周期天数',
  `sampling_start_time` int(10) NOT NULL DEFAULT '0' COMMENT '采集开始时间',
  `sampling_end_time` int(10) NOT NULL DEFAULT '0' COMMENT '采集结束时间',
  `start_page` int(10) NOT NULL DEFAULT '0' COMMENT '开始页',
  `end_page` int(10) NOT NULL DEFAULT '0' COMMENT '结束页',
  `count` int(10) NOT NULL DEFAULT '0' COMMENT '应采集数量',
  `real_count` int(10) NOT NULL DEFAULT '0' COMMENT '实际采集数量',
  `duration` int(10) NOT NULL DEFAULT '0' COMMENT '执行时长（分钟）',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态，1未开始、2进行中、3已完成、4失败、5失败后已重新分配设备、6弃用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='采集任务分配设备表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_collect_task_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_collect_task_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `collect_task_id` int(10) NOT NULL DEFAULT '0' COMMENT '采集任务id',
  `collect_equipment_id` int(10) NOT NULL DEFAULT '0' COMMENT '设备ID',
  `platform` varchar(100) NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `product_name` varchar(100) NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) NOT NULL DEFAULT '' COMMENT '产品规格',
  `minimum_order_quantity` int(11) NOT NULL DEFAULT '1' COMMENT '最小起购量',
  `start_time` int(10) NOT NULL DEFAULT '0' COMMENT '执行开始时间',
  `end_time` int(10) NOT NULL DEFAULT '0' COMMENT '执行结束时间',
  `start_page` int(10) NOT NULL DEFAULT '0' COMMENT '开始页',
  `end_page` int(10) NOT NULL DEFAULT '0' COMMENT '结束页',
  `count` int(10) NOT NULL DEFAULT '0' COMMENT '应采集数量',
  `real_count` int(10) NOT NULL DEFAULT '0' COMMENT '实际采集数量',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态，0执行中、1失败、2完成',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '失败备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='采集任务执行记录表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_external_company`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_external_company` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `logo_url` varchar(500) NOT NULL DEFAULT '' COMMENT '品牌公司logo',
  `company_name` varchar(100) NOT NULL DEFAULT '' COMMENT '品牌公司名称',
  `social_credit_code` varchar(100) NOT NULL DEFAULT '' COMMENT '营业执照号码',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `cleaning_priority` int(11) NOT NULL DEFAULT '0' COMMENT '清洗优先级，值越高越优先',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态:0=启用1=禁用',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='公司表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
  `url` varchar(255) NOT NULL DEFAULT '/manager/' COMMENT '链接地址',
  `icon` varchar(64) NOT NULL DEFAULT '' COMMENT '图标',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序（同级有效）',
  `type` varchar(40) NOT NULL DEFAULT '' COMMENT 'nav,auth',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态0=开启1=关闭',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级分类ID',
  `module` varchar(20) NOT NULL DEFAULT '' COMMENT '模块名',
  `is_open` tinyint(3) NOT NULL DEFAULT '0' COMMENT '是否开放0=是1=否',
  `insert_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `fk_edu_menu_edu_menu1_idx` (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='后台菜单表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_other_download_task`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_other_download_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` varchar(32) NOT NULL DEFAULT '' COMMENT '公司ID',
  `file_id` varchar(200) NOT NULL DEFAULT '' COMMENT '文件ID',
  `file_name` varchar(200) NOT NULL DEFAULT '' COMMENT '文件名称',
  `url` varchar(200) NOT NULL DEFAULT '' COMMENT '文件下载地址',
  `operator_userid` varchar(50) NOT NULL DEFAULT '' COMMENT '操作人用户ID',
  `insert_time` int(11) NOT NULL DEFAULT '0' COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `file_dir_name` varchar(255) NOT NULL DEFAULT '' COMMENT '系统文件名',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态0=进行中1=已完成2=失败',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='下载任务记录';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_pdd_shop_info_middle`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_pdd_shop_info_middle` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `shop` varchar(255) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `contact_address` varchar(255) NOT NULL DEFAULT '' COMMENT '联系地址',
  `qualification_number` varchar(255) NOT NULL DEFAULT '' COMMENT '资质编号',
  `business_license_company` varchar(255) NOT NULL DEFAULT '' COMMENT '营业执照公司名称',
  `business_license_address` varchar(255) NOT NULL DEFAULT '' COMMENT '营业执照地址',
  `scrape_date` date DEFAULT NULL COMMENT '爬取日期',
  `platform` varchar(255) NOT NULL DEFAULT '' COMMENT '平台',
  `province` varchar(255) NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(255) NOT NULL DEFAULT '' COMMENT '城市',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '写入时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `shop_indx` (`shop`) USING BTREE COMMENT '店铺名称唯一'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='拼多多店铺信息';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_personal_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_personnel_department`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_personnel_department` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `name` varchar(60) NOT NULL DEFAULT '' COMMENT '部门名称',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态；0=启用1=停用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='部门表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_personnel_employee`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_personnel_employee` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `employee_code` varchar(60) NOT NULL DEFAULT '' COMMENT '员工编码',
  `openid` varchar(255) NOT NULL DEFAULT '' COMMENT '微信openid',
  `band_wechat` tinyint(3) NOT NULL DEFAULT '0' COMMENT '绑定微信0=未绑定1=已绑定',
  `name` varchar(60) NOT NULL DEFAULT '' COMMENT '姓名',
  `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号码',
  `email` varchar(60) NOT NULL DEFAULT '' COMMENT '邮箱',
  `password` varchar(128) NOT NULL DEFAULT '' COMMENT '密码',
  `department_ids` varchar(255) NOT NULL DEFAULT '' COMMENT '部门ID集合',
  `role_id` int(11) NOT NULL DEFAULT '0' COMMENT '角色ID',
  `duty_type` varchar(50) NOT NULL DEFAULT '' COMMENT '责任类型1=第一责任人，2=责任人',
  `open_notice` tinyint(3) NOT NULL DEFAULT '1' COMMENT '是否通知0=启用1=停用',
  `open_subscribe` tinyint(3) NOT NULL DEFAULT '1' COMMENT '订阅推送0=启用1=停用',
  `is_super` tinyint(3) NOT NULL DEFAULT '0' COMMENT '是否超管1=是0=否',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态0=启用1=停用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='员工表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_personnel_employee_area`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_personnel_employee_area` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '品牌方公司ID',
  `employee_id` int(11) NOT NULL DEFAULT '0' COMMENT '员工ID',
  `province_id` int(11) NOT NULL DEFAULT '0' COMMENT '省份ID',
  `city_id` int(10) NOT NULL DEFAULT '0' COMMENT '城市ID',
  `city_name` varchar(100) NOT NULL DEFAULT '' COMMENT '城市名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='员工地区关系表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_personnel_employee_department`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_personnel_employee_department` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '品牌方公司ID',
  `employee_id` int(11) NOT NULL DEFAULT '0' COMMENT '员工ID',
  `department_id` varchar(60) NOT NULL DEFAULT '' COMMENT '部门ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='员工部门关系表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_personnel_employee_notice_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_personnel_employee_notice_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `employee_id` int(11) NOT NULL DEFAULT '0' COMMENT '员工ID',
  `open_day` int(11) NOT NULL DEFAULT '0' COMMENT '开启天数',
  `notice_week_config` text COMMENT '周推送配置',
  `push_time` varchar(100) NOT NULL DEFAULT '' COMMENT '推送时间',
  `insert_time` int(11) NOT NULL DEFAULT '0' COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='员工通知设置表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_personnel_employee_openid`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_personnel_employee_openid` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '品牌方公司ID',
  `employee_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `unionid` varchar(255) NOT NULL DEFAULT '' COMMENT '用户微信unionid',
  `openid` varchar(255) NOT NULL DEFAULT '' COMMENT '开放平台openid',
  `official_openid` varchar(255) NOT NULL DEFAULT '' COMMENT '公众平台openid',
  `mini_openid` varchar(255) NOT NULL DEFAULT '' COMMENT '小程序openid',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0：小程序；1：公众号，3网页端',
  `insert_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '写入时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `fk_custom_openid_employee_id_idx1` (`employee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='客户open_id';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_personnel_employee_platform`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_personnel_employee_platform` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '品牌方公司ID',
  `employee_id` int(11) NOT NULL DEFAULT '0' COMMENT '员工ID',
  `platform_id` varchar(60) NOT NULL DEFAULT '' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='员工平台关系表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_personnel_employee_province`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_personnel_employee_province` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '品牌方公司ID',
  `employee_id` int(11) NOT NULL DEFAULT '0' COMMENT '员工ID',
  `zoning_id` int(11) NOT NULL DEFAULT '0' COMMENT '大区ID',
  `province_id` varchar(60) NOT NULL DEFAULT '' COMMENT '省份ID',
  `province_name` varchar(100) NOT NULL DEFAULT '' COMMENT '省份名称',
  `is_city_all` tinyint(3) NOT NULL DEFAULT '0' COMMENT '是否完整地区0=否1=是',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='员工省份关系表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_personnel_employee_zoning`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_personnel_employee_zoning` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '品牌方公司ID',
  `employee_id` int(11) NOT NULL DEFAULT '0' COMMENT '员工ID',
  `zoning_id` int(11) NOT NULL DEFAULT '0' COMMENT '大区id',
  `zoning_name` varchar(100) NOT NULL DEFAULT '' COMMENT '大区名称',
  `is_province_all` tinyint(3) NOT NULL DEFAULT '0' COMMENT '是否完整大区0=否1=是',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='员工大区关系表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_personnel_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_personnel_roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `name` varchar(60) NOT NULL DEFAULT '' COMMENT '名称',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `identity` tinyint(3) NOT NULL DEFAULT '1' COMMENT '角色身份1=普通2=管理员',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态:0=启用1=停用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_personnel_roles_auth_rule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_personnel_roles_auth_rule` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '路径',
  `role_id` mediumint(8) NOT NULL COMMENT '角色ID',
  `menu_id` int(10) NOT NULL COMMENT '菜单ID',
  `insert_time` int(11) NOT NULL DEFAULT '0' COMMENT '写入时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色组权限规则表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_platform`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_platform` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(60) NOT NULL DEFAULT '' COMMENT '平台名称',
  `employee_ids` varchar(50) NOT NULL DEFAULT '' COMMENT '责任跟进人',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态:0=启用1=禁用',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='平台配置表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_platform_member`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_platform_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `platform_id` int(11) NOT NULL COMMENT '平台ID',
  `employee_id` int(11) NOT NULL COMMENT '员工ID',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='平台责任人表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_process_control_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_process_control_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `first_responsible_person` text COMMENT '第一责任人',
  `responsible_person` text COMMENT '责任人',
  `platform` varchar(50) NOT NULL DEFAULT '' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `category_name` varchar(60) NOT NULL DEFAULT '' COMMENT '分类名称',
  `product_name` varchar(100) NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) NOT NULL DEFAULT '' COMMENT '产品规格',
  `suggested_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '指导价格',
  `online_posting_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '挂网价格',
  `online_posting_count` int(10) NOT NULL DEFAULT '1' COMMENT '累计挂网次数',
  `continuous_listing_count` int(10) NOT NULL DEFAULT '1' COMMENT '连续挂网次数',
  `link_url` varchar(255) NOT NULL DEFAULT '' COMMENT '链接地址',
  `store_name` varchar(100) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `company_name` varchar(50) NOT NULL DEFAULT '' COMMENT '公司名称',
  `company_category_name` varchar(60) NOT NULL DEFAULT '' COMMENT '公司分类名称',
  `social_credit_code` varchar(50) NOT NULL DEFAULT '' COMMENT '信用代码',
  `province_name` varchar(50) NOT NULL DEFAULT '' COMMENT '省份名称',
  `city_name` varchar(50) NOT NULL DEFAULT '' COMMENT '城市名称',
  `area_info` varchar(255) NOT NULL DEFAULT '' COMMENT '详细地址',
  `source_responsible_person` text COMMENT '溯源责任人',
  `source_id` bigint(20) NOT NULL COMMENT '原始数据ID',
  `processing_status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '处理状态1=待处理',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态0=有效=无效',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='管控商品处理';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_process_control_product_member`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_process_control_product_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `control_product_logid` int(11) NOT NULL COMMENT '管控商品处理记录ID',
  `employee_id` int(11) NOT NULL COMMENT '员工ID',
  `duty_type` tinyint(3) NOT NULL COMMENT '责任类型1=第一责任人,2=责任人,3=溯源责任人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='管控商品处理员工关系表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_process_execute_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_process_execute_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '清洗名称',
  `code` varchar(100) NOT NULL DEFAULT '' COMMENT '清洗编码',
  `admin_id` int(11) NOT NULL COMMENT '管理员ID',
  `is_admin` tinyint(3) NOT NULL DEFAULT '1' COMMENT '是否为管理员1=是0=否',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态:0=完成1=进行中',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='清洗执行日志';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_process_lowprice_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_process_lowprice_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `first_responsible_person` text COMMENT '第一责任人',
  `responsible_person` text COMMENT '责任人',
  `platform` varchar(50) NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `category_name` varchar(60) NOT NULL DEFAULT '' COMMENT '分类名称',
  `product_brand` varchar(150) NOT NULL DEFAULT '' COMMENT '商品品牌',
  `product_name` varchar(100) NOT NULL DEFAULT '' COMMENT '产品名称',
  `inventory` varchar(100) NOT NULL DEFAULT '' COMMENT '库存',
  `sales` varchar(100) NOT NULL DEFAULT '' COMMENT '销量',
  `snapshot_url` text COMMENT '快照地址',
  `product_specs` varchar(100) NOT NULL DEFAULT '' COMMENT '产品规格',
  `suggested_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '指导价格',
  `online_posting_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '挂网价格',
  `online_posting_count` int(10) NOT NULL DEFAULT '1' COMMENT '累计挂网次数',
  `continuous_listing_count` int(10) NOT NULL DEFAULT '1' COMMENT '连续挂网次数',
  `link_url` text COMMENT '链接地址',
  `store_name` varchar(100) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `anonymous_store_name` varchar(100) NOT NULL DEFAULT '' COMMENT '匿名店铺名称',
  `shipment_province_id` int(11) NOT NULL DEFAULT '0' COMMENT '发货省份ID',
  `shipment_province_name` varchar(100) NOT NULL DEFAULT '' COMMENT '发货省份名称',
  `shipment_city_id` int(11) NOT NULL DEFAULT '0' COMMENT '发货城市ID',
  `shipment_city_name` varchar(100) NOT NULL DEFAULT '' COMMENT '发货城市名称',
  `company_name` varchar(50) NOT NULL DEFAULT '' COMMENT '公司名称',
  `company_category_name` varchar(60) NOT NULL DEFAULT '' COMMENT '公司分类名称',
  `social_credit_code` varchar(50) NOT NULL DEFAULT '' COMMENT '信用代码',
  `province_id` int(11) NOT NULL DEFAULT '0' COMMENT '省份',
  `province_name` varchar(50) NOT NULL DEFAULT '' COMMENT '省份名称',
  `city_id` int(11) NOT NULL DEFAULT '0' COMMENT '城市',
  `city_name` varchar(50) NOT NULL DEFAULT '' COMMENT '地区名称',
  `area_info` varchar(255) NOT NULL DEFAULT '' COMMENT '详细地址',
  `source_responsible_person` text COMMENT '溯源责任人',
  `source_id` bigint(20) NOT NULL COMMENT '原始数据ID',
  `processing_status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '处理状态1=待处理2=购买中3=已溯源4=回收凭据已上传5=已回收6=拒绝回收7=已下架8=无法处理',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态0=有效=无效',
  `scrape_date` date DEFAULT NULL COMMENT '检索采集日期',
  `collection_time` int(11) NOT NULL DEFAULT '0' COMMENT '检索采集时间',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='低价商品处理';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_process_lowprice_product_member`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_process_lowprice_product_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `lowprice_product_logid` int(11) NOT NULL COMMENT '低价商品处理记录ID',
  `employee_id` int(11) NOT NULL COMMENT '员工ID',
  `employee_name` varchar(60) NOT NULL DEFAULT '' COMMENT '员工姓名',
  `duty_type` tinyint(3) NOT NULL COMMENT '责任类型1=第一责任人,2=责任人,3=溯源责任人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='低价商品处理员工关系表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_process_lowprice_product_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_process_lowprice_product_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `lowprice_product_logid` int(11) NOT NULL COMMENT '低价商品处理记录ID',
  `processing_status` tinyint(3) NOT NULL DEFAULT '2' COMMENT '处理状态1=待处理2=购买中3=已溯源4=回收凭据已上传5=已回收6=拒绝回收7=已下架8=无法处理',
  `employee_id` int(11) NOT NULL COMMENT '操作员工ID',
  `admin_id` int(11) NOT NULL COMMENT '管理员ID',
  `record_content` text COMMENT '记录内容',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='低价商品处理记录表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_process_notices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_process_notices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `msg_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '消息类型0=系统通知',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '消息标题',
  `content` varchar(255) NOT NULL DEFAULT '' COMMENT '消息内容',
  `content_type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '内容类型1=低价挂网2=禁止挂网3=违规店铺',
  `data_logid` int(11) unsigned DEFAULT '0' COMMENT '数据记录ID',
  `custom_uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '接收消息的用户ID',
  `sender_uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发送者ID，0表示系统',
  `insert_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '写入时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态，0未读1=已读',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='通知消息';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_process_statistics_notices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_process_statistics_notices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `msg_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '消息类型0=系统通知',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '消息标题',
  `content` varchar(255) NOT NULL DEFAULT '' COMMENT '消息内容',
  `ext_data` text COMMENT '其它参数',
  `employee_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '接收消息的用户ID',
  `sender_uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发送者ID，0表示系统',
  `insert_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '写入时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态，0未读1=已读',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='通知消息';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_process_violation_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_process_violation_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `first_responsible_person` text COMMENT '第一责任人',
  `responsible_person` text COMMENT '责任人',
  `platform` varchar(50) NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `category_name` varchar(60) NOT NULL DEFAULT '' COMMENT '分类名称',
  `product_brand` varchar(150) NOT NULL DEFAULT '' COMMENT '商品品牌',
  `product_name` varchar(100) NOT NULL DEFAULT '' COMMENT '产品名称',
  `inventory` varchar(100) NOT NULL DEFAULT '' COMMENT '库存',
  `sales` varchar(100) NOT NULL DEFAULT '' COMMENT '销量',
  `snapshot_url` text COMMENT '快照地址',
  `product_specs` varchar(100) NOT NULL DEFAULT '' COMMENT '产品规格',
  `online_posting_count` int(10) NOT NULL DEFAULT '1' COMMENT '累计挂网次数',
  `continuous_listing_count` int(10) NOT NULL DEFAULT '1' COMMENT '连续挂网次数',
  `link_url` text COMMENT '链接地址',
  `store_name` varchar(100) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `anonymous_store_name` varchar(100) NOT NULL DEFAULT '' COMMENT '匿名店铺名称',
  `shipment_province_id` int(11) NOT NULL DEFAULT '0' COMMENT '发货省份ID',
  `shipment_province_name` varchar(100) NOT NULL DEFAULT '' COMMENT '发货省份名称',
  `shipment_city_id` int(11) NOT NULL DEFAULT '0' COMMENT '发货城市ID',
  `shipment_city_name` varchar(100) NOT NULL DEFAULT '' COMMENT '发货城市名称',
  `company_name` varchar(50) NOT NULL DEFAULT '' COMMENT '公司名称',
  `company_category_name` varchar(60) NOT NULL DEFAULT '' COMMENT '公司分类名称',
  `social_credit_code` varchar(50) NOT NULL DEFAULT '' COMMENT '信用代码',
  `province_id` int(11) NOT NULL DEFAULT '0' COMMENT '省份ID',
  `province_name` varchar(50) NOT NULL DEFAULT '' COMMENT '省份名称',
  `city_id` int(11) NOT NULL DEFAULT '0' COMMENT '城市ID',
  `city_name` varchar(50) NOT NULL DEFAULT '' COMMENT '城市名称',
  `area_info` varchar(255) NOT NULL DEFAULT '' COMMENT '详细地址',
  `source_responsible_person` text COMMENT '溯源责任人',
  `source_id` int(11) NOT NULL COMMENT '原始数据ID',
  `processing_status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '处理状态1=待处理',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态0=有效=无效',
  `scrape_date` date DEFAULT NULL COMMENT '检索采集日期',
  `collection_time` int(11) NOT NULL DEFAULT '0' COMMENT '检索采集时间',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='违规商品处理';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_process_violation_product_member`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_process_violation_product_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `violation_product_logid` int(11) NOT NULL COMMENT '违规商品处理记录ID',
  `employee_id` int(11) NOT NULL COMMENT '员工ID',
  `duty_type` tinyint(3) NOT NULL COMMENT '责任类型1=第一责任人,2=责任人,3=溯源责任人',
  `employee_name` varchar(60) NOT NULL DEFAULT '' COMMENT '员工姓名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='违规商品处理员工关系表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_process_violation_product_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_process_violation_product_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `violation_product_logid` int(11) NOT NULL COMMENT '违规商品处理记录ID',
  `processing_status` tinyint(3) NOT NULL DEFAULT '2' COMMENT '处理状态1=待处理2=购买中3=已溯源4=回收凭据已上传5=已回收6=拒绝回收7=已下架8=无法处理',
  `employee_id` int(11) NOT NULL COMMENT '操作员工ID',
  `admin_id` int(11) NOT NULL COMMENT '管理员ID',
  `record_content` text COMMENT '记录内容',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='违规商品处理记录表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_process_violation_store`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_process_violation_store` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `first_responsible_person` text COMMENT '第一责任人',
  `responsible_person` text COMMENT '责任人',
  `platform` varchar(50) NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `store_name` varchar(100) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `company_name` varchar(50) NOT NULL DEFAULT '' COMMENT '公司名称',
  `company_category_name` varchar(60) NOT NULL DEFAULT '' COMMENT '公司分类名称',
  `social_credit_code` varchar(50) NOT NULL DEFAULT '' COMMENT '信用代码',
  `province_id` int(11) NOT NULL DEFAULT '0' COMMENT '省份ID',
  `province_name` varchar(50) NOT NULL DEFAULT '' COMMENT '省份名称',
  `city_id` int(11) NOT NULL DEFAULT '0' COMMENT '城市ID',
  `city_name` varchar(50) NOT NULL DEFAULT '' COMMENT '城市名称',
  `area_info` varchar(255) NOT NULL DEFAULT '' COMMENT '详细地址',
  `source_responsible_person` text COMMENT '溯源责任人',
  `link_url` text COMMENT '链接地址',
  `source_id` bigint(20) NOT NULL COMMENT '原始数据ID',
  `processing_status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '处理状态1=待处理',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态0=有效=无效',
  `scrape_date` date DEFAULT NULL COMMENT '检索采集日期',
  `collection_time` int(11) NOT NULL DEFAULT '0' COMMENT '检索采集时间',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='违规店铺处理';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_process_violation_store_member`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_process_violation_store_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `violation_store_logid` int(11) NOT NULL COMMENT '违规店铺处理记录ID',
  `employee_id` int(11) NOT NULL COMMENT '员工ID',
  `employee_name` varchar(60) NOT NULL DEFAULT '' COMMENT '员工姓名',
  `duty_type` tinyint(3) NOT NULL COMMENT '责任类型1=第一责任人,2=责任人,3=溯源责任人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='违规店铺处理员工关系表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_scrape_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_scrape_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `enterprise_id` int(11) NOT NULL DEFAULT '0' COMMENT '企业ID',
  `platform_id` varchar(50) NOT NULL DEFAULT '' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `platform_item_id` varchar(64) NOT NULL DEFAULT '' COMMENT '平台商品ID',
  `province_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '省份id',
  `city_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '城市id',
  `province_name` varchar(255) NOT NULL DEFAULT '' COMMENT '省份名称',
  `city_name` varchar(255) NOT NULL DEFAULT '' COMMENT '城市名称',
  `area_info` varchar(255) NOT NULL DEFAULT '' COMMENT '详细地址',
  `product_brand` varchar(150) NOT NULL DEFAULT '' COMMENT '商品品牌',
  `product_name` varchar(100) NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) NOT NULL DEFAULT '' COMMENT '产品规格',
  `search_name` varchar(255) DEFAULT NULL COMMENT '搜索名称',
  `one_box_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '单盒价格',
  `manufacture_date` varchar(64) NOT NULL DEFAULT '' COMMENT '生产日期',
  `expiry_date` varchar(64) NOT NULL DEFAULT '' COMMENT '有效期',
  `manufacturer` varchar(255) NOT NULL DEFAULT '' COMMENT '生产企业',
  `approval_number` varchar(64) NOT NULL DEFAULT '' COMMENT '批准文号',
  `is_sold_out` tinyint(3) NOT NULL DEFAULT '0' COMMENT '是否售罄0=否1=是',
  `online_posting_count` int(10) NOT NULL DEFAULT '1' COMMENT '累计挂网次数',
  `continuous_listing_count` int(10) NOT NULL DEFAULT '1' COMMENT '连续挂网次数',
  `link_url` text NOT NULL COMMENT '链接地址',
  `store_name` varchar(100) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `anonymous_store_name` varchar(100) NOT NULL DEFAULT '' COMMENT '匿名店铺名称',
  `store_url` text COMMENT '店铺链接',
  `shipment_province_id` int(11) NOT NULL DEFAULT '0' COMMENT '发货省份ID',
  `shipment_province_name` varchar(100) NOT NULL DEFAULT '' COMMENT '发货省份名称',
  `shipment_city_id` int(11) NOT NULL DEFAULT '0' COMMENT '发货城市ID',
  `shipment_city_name` varchar(100) NOT NULL DEFAULT '' COMMENT '发货城市名称',
  `company_name` varchar(50) NOT NULL DEFAULT '' COMMENT '公司名称',
  `qualification_number` varchar(255) NOT NULL DEFAULT '' COMMENT '营业执照编号',
  `scrape_date` date DEFAULT NULL COMMENT '采集日期',
  `min_price` decimal(10,2) DEFAULT '0.00' COMMENT '价格',
  `number` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '盒数',
  `sales` varchar(255) DEFAULT '' COMMENT '销量',
  `inventory` varchar(255) DEFAULT '' COMMENT '库存',
  `task_id` int(10) DEFAULT NULL COMMENT '任务id',
  `snapshot_url` text COMMENT '快照url',
  `collect_config_info` text COMMENT '采集配置信息',
  `insert_time` timestamp NOT NULL DEFAULT '2025-12-10 16:00:00' COMMENT '写入时间',
  `update_time` timestamp NOT NULL DEFAULT '2025-12-10 16:00:00' COMMENT '更新时间',
  `account_id` int(10) DEFAULT NULL COMMENT '用户id',
  `collect_region_id` int(10) DEFAULT NULL COMMENT '区域id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='采集原始数据表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_scrape_data_999`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_scrape_data_999` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `enterprise_id` int(11) NOT NULL DEFAULT '0' COMMENT '企业ID',
  `platform_id` varchar(50) NOT NULL DEFAULT '' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `platform_item_id` varchar(64) NOT NULL DEFAULT '' COMMENT '平台商品ID',
  `province_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '省份id',
  `city_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '城市id',
  `province_name` varchar(255) NOT NULL DEFAULT '' COMMENT '省份名称',
  `city_name` varchar(255) NOT NULL DEFAULT '' COMMENT '城市名称',
  `area_info` varchar(255) NOT NULL DEFAULT '' COMMENT '详细地址',
  `product_brand` varchar(150) NOT NULL DEFAULT '' COMMENT '商品品牌',
  `product_name` varchar(100) NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) NOT NULL DEFAULT '' COMMENT '产品规格',
  `one_box_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '单盒价格',
  `manufacture_date` varchar(64) NOT NULL DEFAULT '' COMMENT '生产日期',
  `expiry_date` varchar(64) NOT NULL DEFAULT '' COMMENT '有效期',
  `manufacturer` varchar(255) NOT NULL DEFAULT '' COMMENT '生产企业',
  `approval_number` varchar(64) NOT NULL DEFAULT '' COMMENT '批准文号',
  `is_sold_out` tinyint(3) NOT NULL DEFAULT '0' COMMENT '是否售罄0=否1=是',
  `online_posting_count` int(10) NOT NULL DEFAULT '1' COMMENT '累计挂网次数',
  `continuous_listing_count` int(10) NOT NULL DEFAULT '1' COMMENT '连续挂网次数',
  `link_url` text NOT NULL COMMENT '链接地址',
  `store_name` varchar(100) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `anonymous_store_name` varchar(100) NOT NULL DEFAULT '' COMMENT '匿名店铺名称',
  `store_url` text COMMENT '店铺链接',
  `shipment_province_id` int(11) NOT NULL DEFAULT '0' COMMENT '发货省份ID',
  `shipment_province_name` varchar(100) NOT NULL DEFAULT '' COMMENT '发货省份名称',
  `shipment_city_id` int(11) NOT NULL DEFAULT '0' COMMENT '发货城市ID',
  `shipment_city_name` varchar(100) NOT NULL DEFAULT '' COMMENT '发货城市名称',
  `company_name` varchar(50) NOT NULL DEFAULT '' COMMENT '公司名称',
  `qualification_number` varchar(255) NOT NULL DEFAULT '' COMMENT '营业执照编号',
  `scrape_date` date DEFAULT NULL COMMENT '采集日期',
  `min_price` decimal(10,2) DEFAULT '0.00' COMMENT '价格',
  `number` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '盒数',
  `sales` varchar(255) DEFAULT '' COMMENT '销量',
  `inventory` varchar(255) DEFAULT '' COMMENT '库存',
  `task_id` int(10) DEFAULT NULL COMMENT '任务id',
  `snapshot_url` text COMMENT '快照url',
  `collect_config_info` text COMMENT '采集配置信息',
  `insert_time` timestamp NOT NULL DEFAULT '2025-12-10 16:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT '写入时间',
  `update_time` timestamp NOT NULL DEFAULT '2025-12-10 16:00:00' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='采集原始数据表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_scrape_shop_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_scrape_shop_info` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `shop_url` varchar(255) DEFAULT NULL COMMENT '店铺链接',
  `shop` varchar(255) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `contact_address` varchar(255) NOT NULL DEFAULT '' COMMENT '联系地址',
  `qualification_number` varchar(255) NOT NULL DEFAULT '' COMMENT '资质编号',
  `business_license_company` varchar(255) NOT NULL DEFAULT '' COMMENT '营业执照公司名称',
  `business_license_address` varchar(255) NOT NULL DEFAULT '' COMMENT '营业执照地址',
  `scrape_date` date DEFAULT NULL COMMENT '爬取日期',
  `platform` varchar(255) NOT NULL DEFAULT '' COMMENT '平台',
  `province` varchar(255) NOT NULL DEFAULT '' COMMENT '省',
  `city` varchar(255) NOT NULL DEFAULT '' COMMENT '市',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '写入时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `shop_index` (`shop`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='店铺信息';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_scrape_tmp_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_scrape_tmp_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `enterprise_id` int(11) NOT NULL DEFAULT '0' COMMENT '企业ID',
  `platform_id` varchar(50) NOT NULL DEFAULT '' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `platform_item_id` varchar(64) NOT NULL DEFAULT '' COMMENT '平台商品ID',
  `province_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '省份id',
  `city_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '城市id',
  `province_name` varchar(255) NOT NULL DEFAULT '' COMMENT '省份名称',
  `city_name` varchar(255) NOT NULL DEFAULT '' COMMENT '城市名称',
  `area_info` varchar(255) NOT NULL DEFAULT '' COMMENT '详细地址',
  `product_brand` varchar(150) NOT NULL DEFAULT '' COMMENT '商品品牌',
  `product_name` varchar(100) NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) NOT NULL DEFAULT '' COMMENT '产品规格',
  `one_box_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '单盒价格',
  `manufacture_date` varchar(64) NOT NULL DEFAULT '' COMMENT '生产日期',
  `expiry_date` varchar(64) NOT NULL DEFAULT '' COMMENT '有效期',
  `manufacturer` varchar(255) NOT NULL DEFAULT '' COMMENT '生产企业',
  `approval_number` varchar(64) NOT NULL DEFAULT '' COMMENT '批准文号',
  `is_sold_out` tinyint(3) NOT NULL DEFAULT '0' COMMENT '是否售罄0=否1=是',
  `online_posting_count` int(10) NOT NULL DEFAULT '1' COMMENT '累计挂网次数',
  `continuous_listing_count` int(10) NOT NULL DEFAULT '1' COMMENT '连续挂网次数',
  `link_url` text NOT NULL COMMENT '链接地址',
  `store_name` varchar(100) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `anonymous_store_name` varchar(100) NOT NULL DEFAULT '' COMMENT '匿名店铺名称',
  `store_url` text COMMENT '店铺链接',
  `shipment_province_id` int(11) NOT NULL DEFAULT '0' COMMENT '发货省份ID',
  `shipment_province_name` varchar(100) NOT NULL DEFAULT '' COMMENT '发货省份名称',
  `shipment_city_id` int(11) NOT NULL DEFAULT '0' COMMENT '发货城市ID',
  `shipment_city_name` varchar(100) NOT NULL DEFAULT '' COMMENT '发货城市名称',
  `company_name` varchar(50) NOT NULL DEFAULT '' COMMENT '公司名称',
  `qualification_number` varchar(255) NOT NULL DEFAULT '' COMMENT '营业执照编号',
  `scrape_date` date DEFAULT NULL COMMENT '采集日期',
  `min_price` decimal(10,2) DEFAULT '0.00' COMMENT '价格',
  `number` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '盒数',
  `sales` varchar(255) DEFAULT '' COMMENT '销量',
  `inventory` varchar(255) DEFAULT '' COMMENT '库存',
  `snapshot_url` text COMMENT '快照url',
  `collect_config_info` text COMMENT '采集配置信息',
  `insert_time` timestamp NOT NULL DEFAULT '2025-12-10 16:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT '写入时间',
  `update_time` timestamp NOT NULL DEFAULT '2025-12-10 16:00:00' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='采集数据临时表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_sub_notice_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_sub_notice_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `employee_id` int(11) NOT NULL DEFAULT '0' COMMENT '员工ID',
  `internal_notice_content` text NOT NULL COMMENT '站内信通知',
  `email` varchar(150) NOT NULL DEFAULT '' COMMENT '邮箱号码',
  `mobile` varchar(20) DEFAULT '' COMMENT '手机号码',
  `email_content` text COMMENT '邮箱内容',
  `mobile_content` text COMMENT '手机内容',
  `ext_data` text COMMENT '其它参数',
  `push_time` int(11) NOT NULL DEFAULT '0' COMMENT '设置推送时间',
  `insert_time` int(11) NOT NULL DEFAULT '0' COMMENT '写入时间',
  `sms_status` tinyint(3) DEFAULT '1' COMMENT '短信状态0=已推送1=未推送',
  `internal_notice_status` tinyint(3) DEFAULT '1' COMMENT '站内信状态0=已推送1=未推送',
  `email_status` tinyint(3) DEFAULT '1' COMMENT '邮箱发送状态0=已推送1=未推送',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '全部状态0=已推送1=未推送',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订阅推送记录';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_user_subscription_tmp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_user_subscription_tmp` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `tmplate_id` varchar(100) NOT NULL DEFAULT '' COMMENT '模板ID',
  `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID',
  `open_subscribe` tinyint(3) NOT NULL DEFAULT '1' COMMENT '开启订阅0=是1否',
  `insert_time` int(11) NOT NULL DEFAULT '0' COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='消息模板订阅';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_user_table_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_user_table_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '员工ID',
  `is_admin` tinyint(3) NOT NULL DEFAULT '0' COMMENT '是否为管理员1=是0=否',
  `table_name` varchar(200) NOT NULL DEFAULT '' COMMENT '表格名称',
  `data_config` text COMMENT '配置参数',
  `insert_time` int(11) NOT NULL DEFAULT '0' COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='用户展示表格配置';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_washconfig_company_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_washconfig_company_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `name` varchar(60) NOT NULL DEFAULT '' COMMENT '公司分类名称',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态；0=启用1=停用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='公司分类表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_washconfig_control_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_washconfig_control_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `platform` varchar(100) NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `category_id` int(11) NOT NULL DEFAULT '0' COMMENT '产品分类ID',
  `product_name` varchar(100) NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) NOT NULL DEFAULT '' COMMENT '产品规格',
  `suggested_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '指导价格',
  `store_scope` tinyint(3) NOT NULL DEFAULT '1' COMMENT '店铺范围1=全部店铺2=指定店铺',
  `company_scope` tinyint(3) NOT NULL DEFAULT '1' COMMENT '公司范围1=全部公司2=指定公司',
  `specify_responsible_person` tinyint(3) NOT NULL DEFAULT '0' COMMENT '指派责任人 0=开启 1=关闭',
  `sampling_cycle` tinyint(3) NOT NULL DEFAULT '1' COMMENT '采集周期天数',
  `sampling_start_time` int(11) NOT NULL DEFAULT '0' COMMENT '采集开始时间',
  `sampling_end_time` int(11) NOT NULL DEFAULT '0' COMMENT '采集结束时间',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态，0启用，1禁用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='管控商品配置表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_washconfig_control_product_company`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_washconfig_control_product_company` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `control_product_logid` int(100) NOT NULL COMMENT '强管控记录ID',
  `company_id` int(100) NOT NULL COMMENT '公司ID',
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='管控商品公司关系';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_washconfig_lowprice_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_washconfig_lowprice_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `platform` varchar(100) NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `enable_full_quantity` tinyint(3) NOT NULL DEFAULT '1' COMMENT '全量，0启用，1禁用',
  `category_id` int(11) NOT NULL DEFAULT '0' COMMENT '产品分类ID',
  `product_brand` varchar(150) NOT NULL DEFAULT '' COMMENT '商品品牌',
  `product_name` varchar(100) NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) NOT NULL DEFAULT '' COMMENT '产品规格',
  `suggested_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '指导价格',
  `store_scope` tinyint(3) NOT NULL DEFAULT '1' COMMENT '店铺范围1=全部店铺2=指定店铺',
  `company_scope` tinyint(3) NOT NULL DEFAULT '1' COMMENT '公司范围1=全部公司2=指定公司',
  `specify_responsible_person` tinyint(3) DEFAULT '0' COMMENT '指派责任人 0=开启 1=关闭',
  `sampling_cycle` tinyint(3) NOT NULL DEFAULT '1' COMMENT '采集周期天数',
  `sampling_start_time` int(11) NOT NULL DEFAULT '0' COMMENT '采集开始时间',
  `sampling_end_time` int(11) NOT NULL DEFAULT '0' COMMENT '采集结束时间',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态，0启用，1禁用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='低价商品配置表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_washconfig_lowprice_product_company`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_washconfig_lowprice_product_company` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `lowprice_product_logid` int(100) NOT NULL COMMENT '低价商品记录ID',
  `company_id` int(100) NOT NULL COMMENT '公司ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='低价商品公司关系表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_washconfig_lowprice_product_keyword`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_washconfig_lowprice_product_keyword` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `keyword` varchar(150) NOT NULL DEFAULT '' COMMENT '关键字',
  `lowprice_product_id` int(11) NOT NULL DEFAULT '0' COMMENT '采集商品ID',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='低价商品关键字表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_washconfig_lowprice_product_platform`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_washconfig_lowprice_product_platform` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '品牌方公司ID',
  `product_id` int(11) NOT NULL DEFAULT '0' COMMENT '产品ID',
  `platform_id` varchar(60) NOT NULL DEFAULT '' COMMENT '1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='低价商品平台关系表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_washconfig_product_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_washconfig_product_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `name` varchar(60) NOT NULL DEFAULT '' COMMENT '商品分类名称',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态；0=启用1=停用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='产品分类表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_washconfig_violation_company`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_washconfig_violation_company` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `platform` varchar(100) NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `category_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司分类ID',
  `company_name` varchar(100) NOT NULL DEFAULT '' COMMENT '公司名称',
  `social_credit_code` varchar(100) NOT NULL DEFAULT '' COMMENT '信用代码',
  `province_id` int(11) NOT NULL DEFAULT '0' COMMENT '省份ID',
  `city_id` int(11) NOT NULL DEFAULT '0' COMMENT '城市ID',
  `area_info` varchar(255) NOT NULL DEFAULT '' COMMENT '详细地址',
  `company_type` tinyint(3) NOT NULL DEFAULT '1' COMMENT '公司类型:1=黑名单2=白名单',
  `specify_responsible_person` tinyint(3) NOT NULL DEFAULT '0' COMMENT '指派责任人 0=开启 1=关闭',
  `employee_ids` varchar(50) NOT NULL DEFAULT '' COMMENT '责任跟进人',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态:0=启用1=禁用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='违规公司配置表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_washconfig_violation_company_member`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_washconfig_violation_company_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_logid` int(11) NOT NULL COMMENT '违规公司记录ID',
  `employee_id` int(11) NOT NULL COMMENT '员工ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='公司跟进员工关系表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_washconfig_violation_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_washconfig_violation_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `platform` varchar(100) NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `enable_full_quantity` tinyint(3) NOT NULL DEFAULT '1' COMMENT '全量，0启用，1禁用',
  `category_id` int(11) NOT NULL DEFAULT '0' COMMENT '产品分类ID',
  `product_brand` varchar(150) NOT NULL DEFAULT '' COMMENT '商品品牌',
  `product_name` varchar(100) NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) NOT NULL DEFAULT '' COMMENT '产品规格',
  `suggested_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '指导价格',
  `store_scope` tinyint(3) NOT NULL DEFAULT '1' COMMENT '店铺范围1=全部店铺2=指定店铺',
  `company_scope` tinyint(3) DEFAULT '1' COMMENT '公司范围1=全部公司2=指定公司',
  `specify_responsible_person` tinyint(3) NOT NULL DEFAULT '0' COMMENT '指派责任人 0=开启 1=关闭',
  `sampling_cycle` tinyint(3) NOT NULL DEFAULT '1' COMMENT '采集周期天数',
  `sampling_start_time` int(11) NOT NULL DEFAULT '0' COMMENT '采集开始时间',
  `sampling_end_time` int(11) NOT NULL DEFAULT '0' COMMENT '采集结束时间',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态，0启用，1禁用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='违规商品配置表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_washconfig_violation_product_company`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_washconfig_violation_product_company` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `violation_product_logid` int(100) NOT NULL COMMENT '违规商品记录ID',
  `company_id` int(100) NOT NULL COMMENT '公司ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='违规商品公司关系表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_washconfig_violation_product_keyword`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_washconfig_violation_product_keyword` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `keyword` varchar(150) NOT NULL DEFAULT '' COMMENT '关键字',
  `violation_product_id` int(11) NOT NULL DEFAULT '0' COMMENT '违规商品ID',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='违规商品关键字表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_washconfig_violation_product_platform`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_washconfig_violation_product_platform` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '品牌方公司ID',
  `product_id` int(11) NOT NULL DEFAULT '0' COMMENT '产品ID',
  `platform_id` varchar(60) NOT NULL DEFAULT '' COMMENT '1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='违规商品平台关系表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_washconfig_violation_store`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_washconfig_violation_store` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司ID',
  `platform` varchar(100) NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `store_name` varchar(100) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `store_type` tinyint(3) NOT NULL DEFAULT '1' COMMENT '店铺类型:1=黑名单2=白名单',
  `specify_responsible_person` tinyint(3) NOT NULL DEFAULT '0' COMMENT '指派责任人 0=开启 1=关闭',
  `employee_ids` varchar(50) NOT NULL DEFAULT '' COMMENT '责任跟进人',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态:0=启用1=禁用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='违规店铺公司配置表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_washconfig_violation_store_member`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_washconfig_violation_store_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `store_logid` int(11) NOT NULL COMMENT '违规公司记录ID',
  `employee_id` int(11) NOT NULL COMMENT '员工ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='店铺跟进员工关系表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_website_lead_message`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_website_lead_message` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_name` varchar(200) NOT NULL DEFAULT '' COMMENT '称呼姓名',
  `position` varchar(32) NOT NULL DEFAULT '' COMMENT '职位',
  `phone` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号',
  `company_name` varchar(128) NOT NULL DEFAULT '' COMMENT '公司名称',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态0=待跟进1=已跟进',
  `remarks` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `insert_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '写入时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `fk_potential_phone_UNIQUE` (`phone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='潜在客户留言';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_website_lead_notice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_website_lead_notice` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号',
  `email` varchar(100) NOT NULL DEFAULT '' COMMENT '邮箱号码',
  `remark` varchar(32) NOT NULL DEFAULT '' COMMENT '备注',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态0=启用1=禁用',
  `insert_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '写入时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `fk_potential_phone_UNIQUE` (`phone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='留言短信接收人员';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_ybm_shop_info_middle`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_ybm_shop_info_middle` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `shop` varchar(255) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `store_url` varchar(255) NOT NULL COMMENT '店铺网页链接',
  `qualification_number` varchar(255) NOT NULL DEFAULT '' COMMENT '资质编号',
  `business_license_company` varchar(255) NOT NULL DEFAULT '' COMMENT '营业执照公司名称',
  `business_license_address` varchar(255) NOT NULL DEFAULT '' COMMENT '营业执照地址',
  `scrape_date` date DEFAULT NULL COMMENT '爬取日期',
  `platform` varchar(255) NOT NULL DEFAULT '' COMMENT '平台',
  `province` varchar(255) NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(255) NOT NULL DEFAULT '' COMMENT '城市',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '写入时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `shop_indx` (`shop`) USING BTREE COMMENT '店铺名称唯一'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='药久久店铺信息';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `retrieve_yjj_shop_info_middle`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrieve_yjj_shop_info_middle` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `shop` varchar(255) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `contact_address` varchar(255) NOT NULL DEFAULT '' COMMENT '联系地址',
  `qualification_number` varchar(255) NOT NULL DEFAULT '' COMMENT '资质编号',
  `business_license_company` varchar(255) NOT NULL DEFAULT '' COMMENT '营业执照公司名称',
  `business_license_address` varchar(255) NOT NULL DEFAULT '' COMMENT '营业执照地址',
  `scrape_date` date DEFAULT NULL COMMENT '爬取日期',
  `platform` varchar(255) NOT NULL DEFAULT '' COMMENT '平台',
  `province` varchar(255) NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(255) NOT NULL DEFAULT '' COMMENT '城市',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '写入时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `shop_indx` (`shop`) USING BTREE COMMENT '店铺名称唯一'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='药久久店铺信息';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `tb_provider_tmp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_provider_tmp` (
  `name` varchar(64) NOT NULL DEFAULT '',
  `company_name` varchar(64) NOT NULL DEFAULT '' COMMENT '公司名',
  `province_name` varchar(64) NOT NULL DEFAULT '',
  `city_name` varchar(64) NOT NULL DEFAULT '',
  `addr` varchar(128) NOT NULL DEFAULT '',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `yaoex_provider_tmp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yaoex_provider_tmp` (
  `name` varchar(64) NOT NULL DEFAULT '' COMMENT '商店名',
  `company_name` varchar(64) NOT NULL DEFAULT '' COMMENT '公司名',
  `province_name` varchar(64) NOT NULL DEFAULT '',
  `city_name` varchar(64) NOT NULL DEFAULT '',
  `addr` varchar(128) NOT NULL DEFAULT '',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ysbang_provider_tmp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ysbang_provider_tmp` (
  `name` varchar(64) NOT NULL DEFAULT '',
  `company_name` varchar(64) NOT NULL DEFAULT '' COMMENT '公司名',
  `province_name` varchar(64) NOT NULL DEFAULT '',
  `city_name` varchar(64) NOT NULL DEFAULT '',
  `addr` varchar(128) NOT NULL DEFAULT '',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

INSERT INTO `retrieve_migrations` VALUES (1,'2014_10_12_000000_create_users_table',1);
INSERT INTO `retrieve_migrations` VALUES (2,'2014_10_12_100000_create_password_resets_table',1);
INSERT INTO `retrieve_migrations` VALUES (3,'2019_08_19_000000_create_failed_jobs_table',1);
INSERT INTO `retrieve_migrations` VALUES (4,'2019_12_14_000001_create_personal_access_tokens_table',1);