collect_schedule/drug_retrieve.sql

/*
 Navicat Premium Dump SQL

 Source Server         : drug_retrieve
 Source Server Type    : MySQL
 Source Server Version : 50744 (5.7.44-log)
 Source Host           : 120.24.49.2:3306
 Source Schema         : drug_retrieve

 Target Server Type    : MySQL
 Target Server Version : 50744 (5.7.44-log)
 File Encoding         : 65001

 Date: 28/04/2026 11:47:06
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for mt_shop_info_middle
-- ----------------------------
DROP TABLE IF EXISTS `mt_shop_info_middle`;
CREATE TABLE `mt_shop_info_middle`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `shop` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店铺名称',
  `contact_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '联系地址',
  `qualification_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '资质编号',
  `business_license_company` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '营业执照公司名称',
  `business_license_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '营业执照地址',
  `scrape_date` date NULL DEFAULT NULL COMMENT '爬取日期',
  `platform` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '平台',
  `province` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省',
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci 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 INDEX `shop_index`(`shop`) USING BTREE COMMENT '店铺名称唯一'
) ENGINE = MyISAM AUTO_INCREMENT = 4820 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '美团店铺信息' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for pdd_shop_info_middle
-- ----------------------------
DROP TABLE IF EXISTS `pdd_shop_info_middle`;
CREATE TABLE `pdd_shop_info_middle`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `shop` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店铺名称',
  `contact_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '联系地址',
  `qualification_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '资质编号',
  `business_license_company` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '营业执照公司名称',
  `business_license_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '营业执照地址',
  `store_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品链接',
  `scrape_date` date NULL DEFAULT NULL COMMENT '爬取日期',
  `platform` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '平台',
  `province` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci 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 INDEX `shop_indx`(`shop`) USING BTREE COMMENT '店铺名称唯一'
) ENGINE = MyISAM AUTO_INCREMENT = 9610 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '拼多多店铺信息' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_admin
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_admin`;
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) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手机号',
  `password` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci 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 INDEX `username_UNIQUE`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_admin_history
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_admin_history`;
CREATE TABLE `retrieve_admin_history`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
  `company_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '品牌方公司名称',
  `company_id` int(11) NOT NULL DEFAULT 0 COMMENT '公司ID',
  `user_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci 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) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模块菜单名称',
  `notes_type` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '操作类型，1添加，2修改，3=删除',
  `general_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '概况描述',
  `table_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '表名',
  `before_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '更改前',
  `after_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL 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 AUTO_INCREMENT = 1323 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '操作历史' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_attachment
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_attachment`;
CREATE TABLE `retrieve_attachment`  (
  `id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `category` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '类别:image=图片,voice=音频,video=视频,file=文件',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '物理路径',
  `imagewidth` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '宽度',
  `imageheight` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '高度',
  `imagetype` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '图片类型',
  `filename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '文件名称',
  `filesize` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '文件大小',
  `mimetype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'mime类型',
  `createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建日期',
  `updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
  `storage` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'local' COMMENT '存储位置',
  `sha1` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '文件 sha1编码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '附件表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_auth_group`;
CREATE TABLE `retrieve_auth_group`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户组id,自增主键',
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '权限组名称',
  `description` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci 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 AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限组' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_auth_group_access`;
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,
  INDEX `fk_auth_group_access_group_id_idx`(`group_id`) USING BTREE,
  INDEX `fk_auth_group_access_user_uid_idx`(`admin_uid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户权限组' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_auth_rule`;
CREATE TABLE `retrieve_auth_rule`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '规则id,自增主键',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '路径',
  `group_id` mediumint(8) UNSIGNED NOT NULL,
  `menu_id` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `fk_auth_rule_edu_auth_group1_idx`(`group_id`) USING BTREE,
  INDEX `fk_auth_rule_edu_menu1_idx`(`menu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限组权限规则表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_city
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_city`;
CREATE TABLE `retrieve_city`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
  `pid` int(11) NOT NULL DEFAULT 0 COMMENT '父ID',
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 44704 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '地区表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_city_zoning
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_city_zoning`;
CREATE TABLE `retrieve_city_zoning`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `zoning_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分区名称',
  `province_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL 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 AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '地理大区表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_collect_equipment
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_collect_equipment`;
CREATE TABLE `retrieve_collect_equipment`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '设备名称',
  `device_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 AUTO_INCREMENT = 29 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '采集设备表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_collect_equipment_account
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_collect_equipment_account`;
CREATE TABLE `retrieve_collect_equipment_account`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `collect_equipment_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '账号名',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '采集设备账号' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_collect_platform_config
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_collect_platform_config`;
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 AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '采集平台配置表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_collect_product
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_collect_product`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `enable_full_quantity` tinyint(3) NULL DEFAULT 1 COMMENT '全量，0启用，1禁用',
  `product_brand` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品品牌',
  `product_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL 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 '采集周期天数',
  `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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 270 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '采集商品配置表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_collect_product_keyword
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_collect_product_keyword`;
CREATE TABLE `retrieve_collect_product_keyword`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `keyword` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关键字',
  `collect_product_id` int(11) NOT NULL DEFAULT 0 COMMENT '采集商品ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 38 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '采集商品关键字表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_collect_task
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_collect_task`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品规格',
  `product_brand` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品品牌',
  `product_keyword` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 AUTO_INCREMENT = 3027 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '采集任务执行表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_collect_task_allocate
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_collect_task_allocate`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `product_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品规格',
  `product_brand` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '品牌',
  `product_keyword` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '产品关键词',
  `minimum_order_quantity` int(11) NOT NULL DEFAULT 1 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 AUTO_INCREMENT = 1240 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '采集任务分配设备表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_collect_task_record
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_collect_task_record`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `product_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '失败备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 808 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '采集任务执行记录表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_external_company
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_external_company`;
CREATE TABLE `retrieve_external_company`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `logo_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '品牌公司logo',
  `company_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '品牌公司名称',
  `social_credit_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '公司表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_failed_jobs
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_failed_jobs`;
CREATE TABLE `retrieve_failed_jobs`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `failed_jobs_uuid_unique`(`uuid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_jobs
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_jobs`;
CREATE TABLE `retrieve_jobs`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED NULL DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `jobs_queue_index`(`queue`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 128415 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_menu
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_menu`;
CREATE TABLE `retrieve_menu`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标题',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '/manager/' COMMENT '链接地址',
  `icon` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图标',
  `sort_order` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序（同级有效）',
  `type` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci 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) CHARACTER SET utf8 COLLATE utf8_general_ci 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,
  INDEX `fk_edu_menu_edu_menu1_idx`(`pid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 201 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台菜单表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_migrations
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_migrations`;
CREATE TABLE `retrieve_migrations`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_other_download_task
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_other_download_task`;
CREATE TABLE `retrieve_other_download_task`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `company_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司ID',
  `file_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件ID',
  `file_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件名称',
  `url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件下载地址',
  `operator_userid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '系统文件名',
  `status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '状态0=进行中1=已完成2=失败',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '下载任务记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_password_resets
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_password_resets`;
CREATE TABLE `retrieve_password_resets`  (
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  INDEX `password_resets_email_index`(`email`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_personal_access_tokens
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_personal_access_tokens`;
CREATE TABLE `retrieve_personal_access_tokens`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `personal_access_tokens_token_unique`(`token`) USING BTREE,
  INDEX `personal_access_tokens_tokenable_type_tokenable_id_index`(`tokenable_type`, `tokenable_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_personnel_department
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_personnel_department`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_personnel_employee
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_personnel_employee`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '员工编码',
  `openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '微信openid',
  `band_wechat` tinyint(3) NOT NULL DEFAULT 0 COMMENT '绑定微信0=未绑定1=已绑定',
  `name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '姓名',
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手机号码',
  `email` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '邮箱',
  `password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '密码',
  `department_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '部门ID集合',
  `role_id` int(11) NOT NULL DEFAULT 0 COMMENT '角色ID',
  `duty_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '员工表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_personnel_employee_area
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_personnel_employee_area`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12984 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '员工地区关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_personnel_employee_department
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_personnel_employee_department`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '部门ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 63 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '员工部门关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_personnel_employee_notice_config
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_personnel_employee_notice_config`;
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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '周推送配置',
  `push_time` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '员工通知设置表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_personnel_employee_openid
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_personnel_employee_openid`;
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) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户微信unionid',
  `openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '开放平台openid',
  `official_openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '公众平台openid',
  `mini_openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci 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,
  INDEX `fk_custom_openid_employee_id_idx1`(`employee_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户open_id' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_personnel_employee_platform
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_personnel_employee_platform`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 283 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '员工平台关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_personnel_employee_province
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_personnel_employee_province`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份ID',
  `province_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称',
  `is_city_all` tinyint(3) NOT NULL DEFAULT 0 COMMENT '是否完整地区0=否1=是',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1188 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '员工省份关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_personnel_employee_zoning
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_personnel_employee_zoning`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '大区名称',
  `is_province_all` tinyint(3) NOT NULL DEFAULT 0 COMMENT '是否完整大区0=否1=是',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 277 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '员工大区关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_personnel_roles
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_personnel_roles`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_personnel_roles_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_personnel_roles_auth_rule`;
CREATE TABLE `retrieve_personnel_roles_auth_rule`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci 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 AUTO_INCREMENT = 2162 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色组权限规则表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_platform
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_platform`;
CREATE TABLE `retrieve_platform`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '平台名称',
  `employee_ids` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '平台配置表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_platform_member
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_platform_member`;
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`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '平台责任人表' ROW_FORMAT = FIXED;

-- ----------------------------
-- Table structure for retrieve_process_control_product
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_process_control_product`;
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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '第一责任人',
  `responsible_person` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '责任人',
  `platform` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `category_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类名称',
  `product_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '链接地址',
  `store_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '店铺名称',
  `company_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
  `company_category_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司分类名称',
  `social_credit_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '信用代码',
  `province_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称',
  `city_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市名称',
  `area_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '详细地址',
  `source_responsible_person` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL 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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管控商品处理' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_process_control_product_member
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_process_control_product_member`;
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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管控商品处理员工关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_process_execute_log
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_process_execute_log`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '清洗名称',
  `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 215 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '清洗执行日志' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_process_lowprice_product
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_process_lowprice_product`;
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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '第一责任人',
  `responsible_person` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '责任人',
  `platform` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `category_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类名称',
  `product_brand` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品品牌',
  `product_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品名称',
  `inventory` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '库存',
  `sales` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '销量',
  `snapshot_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '快照地址',
  `product_specs` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '链接地址',
  `store_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '店铺名称',
  `anonymous_store_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '匿名店铺名称',
  `shipment_province_id` int(11) NOT NULL DEFAULT 0 COMMENT '发货省份ID',
  `shipment_province_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发货省份名称',
  `shipment_city_id` int(11) NOT NULL DEFAULT 0 COMMENT '发货城市ID',
  `shipment_city_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发货城市名称',
  `company_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
  `company_category_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司分类名称',
  `social_credit_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '信用代码',
  `province_id` int(11) NOT NULL DEFAULT 0 COMMENT '省份',
  `province_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称',
  `city_id` int(11) NOT NULL DEFAULT 0 COMMENT '城市',
  `city_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '地区名称',
  `area_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '详细地址',
  `source_responsible_person` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL 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 NULL 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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18873 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '低价商品处理' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_process_lowprice_product_member
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_process_lowprice_product_member`;
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',
  `duty_type` tinyint(3) NOT NULL COMMENT '责任类型1=第一责任人,2=责任人,3=溯源责任人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28240 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '低价商品处理员工关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_process_lowprice_product_record
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_process_lowprice_product_record`;
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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '记录内容',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '低价商品处理记录表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_process_notices
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_process_notices`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '消息标题',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '消息内容',
  `content_type` tinyint(3) NOT NULL DEFAULT 0 COMMENT '内容类型1=低价挂网2=禁止挂网3=违规店铺',
  `data_logid` int(11) UNSIGNED NULL 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 AUTO_INCREMENT = 11294 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知消息' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_process_statistics_notices
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_process_statistics_notices`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '消息标题',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '消息内容',
  `ext_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL 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 AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知消息' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_process_violation_product
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_process_violation_product`;
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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '第一责任人',
  `responsible_person` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '责任人',
  `platform` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `category_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类名称',
  `product_brand` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品品牌',
  `product_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品名称',
  `inventory` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '库存',
  `sales` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '销量',
  `snapshot_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '快照地址',
  `product_specs` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '链接地址',
  `store_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '店铺名称',
  `anonymous_store_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '匿名店铺名称',
  `shipment_province_id` int(11) NOT NULL DEFAULT 0 COMMENT '发货省份ID',
  `shipment_province_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发货省份名称',
  `shipment_city_id` int(11) NOT NULL DEFAULT 0 COMMENT '发货城市ID',
  `shipment_city_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发货城市名称',
  `company_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
  `company_category_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司分类名称',
  `social_credit_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '信用代码',
  `province_id` int(11) NOT NULL DEFAULT 0 COMMENT '省份ID',
  `province_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称',
  `city_id` int(11) NOT NULL DEFAULT 0 COMMENT '城市ID',
  `city_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市名称',
  `area_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '详细地址',
  `source_responsible_person` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL 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 NULL 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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29614 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '违规商品处理' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_process_violation_product_member
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_process_violation_product_member`;
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=溯源责任人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 35325 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '违规商品处理员工关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_process_violation_product_record
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_process_violation_product_record`;
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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '记录内容',
  `insert_time` int(11) NOT NULL COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '违规商品处理记录表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_process_violation_store
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_process_violation_store`;
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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '第一责任人',
  `responsible_person` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '责任人',
  `platform` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `store_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '店铺名称',
  `company_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
  `company_category_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司分类名称',
  `social_credit_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '信用代码',
  `province_id` int(11) NOT NULL DEFAULT 0 COMMENT '省份ID',
  `province_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称',
  `city_id` int(11) NOT NULL DEFAULT 0 COMMENT '城市ID',
  `city_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市名称',
  `area_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '详细地址',
  `source_responsible_person` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '溯源责任人',
  `link_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL 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 NULL 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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '违规店铺处理' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_process_violation_store_member
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_process_violation_store_member`;
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',
  `duty_type` tinyint(3) NOT NULL COMMENT '责任类型1=第一责任人,2=责任人,3=溯源责任人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '违规店铺处理员工关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_scrape_data
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_scrape_data`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `platform_item_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称',
  `city_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市名称',
  `area_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '详细地址',
  `product_brand` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品品牌',
  `product_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品规格',
  `search_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '搜索名称',
  `one_box_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '单盒价格',
  `manufacture_date` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '生产日期',
  `expiry_date` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '有效期',
  `manufacturer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '生产企业',
  `approval_number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '链接地址',
  `store_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '店铺名称',
  `anonymous_store_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '匿名店铺名称',
  `store_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '店铺链接',
  `shipment_province_id` int(11) NOT NULL DEFAULT 0 COMMENT '发货省份ID',
  `shipment_province_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发货省份名称',
  `shipment_city_id` int(11) NOT NULL DEFAULT 0 COMMENT '发货城市ID',
  `shipment_city_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发货城市名称',
  `company_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
  `qualification_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '营业执照编号',
  `scrape_date` date NULL DEFAULT NULL COMMENT '采集日期',
  `min_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '价格',
  `number` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '盒数',
  `sales` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '销量',
  `inventory` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '库存',
  `task_id` int(10) NULL DEFAULT NULL COMMENT '任务id',
  `snapshot_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '快照url',
  `collect_config_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '采集配置信息',
  `insert_time` timestamp NOT NULL DEFAULT '2025-12-11 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT '写入时间',
  `update_time` timestamp NOT NULL DEFAULT '2025-12-11 00:00:00' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1403054 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '采集原始数据表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_scrape_data_999
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_scrape_data_999`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `platform_item_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称',
  `city_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市名称',
  `area_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '详细地址',
  `product_brand` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品品牌',
  `product_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品规格',
  `one_box_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '单盒价格',
  `manufacture_date` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '生产日期',
  `expiry_date` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '有效期',
  `manufacturer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '生产企业',
  `approval_number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '链接地址',
  `store_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '店铺名称',
  `anonymous_store_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '匿名店铺名称',
  `store_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '店铺链接',
  `shipment_province_id` int(11) NOT NULL DEFAULT 0 COMMENT '发货省份ID',
  `shipment_province_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发货省份名称',
  `shipment_city_id` int(11) NOT NULL DEFAULT 0 COMMENT '发货城市ID',
  `shipment_city_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发货城市名称',
  `company_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
  `qualification_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '营业执照编号',
  `scrape_date` date NULL DEFAULT NULL COMMENT '采集日期',
  `min_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '价格',
  `number` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '盒数',
  `sales` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '销量',
  `inventory` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '库存',
  `task_id` int(10) NULL DEFAULT NULL COMMENT '任务id',
  `search_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '搜索名称',
  `snapshot_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '快照url',
  `collect_config_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '采集配置信息',
  `insert_time` timestamp NOT NULL DEFAULT '2025-12-11 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT '写入时间',
  `update_time` timestamp NOT NULL DEFAULT '2025-12-11 00:00:00' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1413026 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '采集原始数据表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_scrape_shop_info
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_scrape_shop_info`;
CREATE TABLE `retrieve_scrape_shop_info`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `shop_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '店铺链接',
  `shop` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店铺名称',
  `contact_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '联系地址',
  `qualification_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '资质编号',
  `business_license_company` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '营业执照公司名称',
  `business_license_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '营业执照地址',
  `scrape_date` date NULL DEFAULT NULL COMMENT '爬取日期',
  `platform` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '平台',
  `province` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省',
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci 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 INDEX `shop_index`(`shop`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 4728 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '店铺信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for retrieve_scrape_tmp_data
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_scrape_tmp_data`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '平台0=全部，1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  `platform_item_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称',
  `city_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市名称',
  `area_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '详细地址',
  `product_brand` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品品牌',
  `product_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品规格',
  `one_box_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '单盒价格',
  `manufacture_date` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '生产日期',
  `expiry_date` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '有效期',
  `manufacturer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '生产企业',
  `approval_number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '链接地址',
  `store_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '店铺名称',
  `anonymous_store_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '匿名店铺名称',
  `store_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '店铺链接',
  `shipment_province_id` int(11) NOT NULL DEFAULT 0 COMMENT '发货省份ID',
  `shipment_province_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发货省份名称',
  `shipment_city_id` int(11) NOT NULL DEFAULT 0 COMMENT '发货城市ID',
  `shipment_city_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发货城市名称',
  `company_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
  `qualification_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '营业执照编号',
  `scrape_date` date NULL DEFAULT NULL COMMENT '采集日期',
  `min_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '价格',
  `number` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '盒数',
  `sales` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '销量',
  `inventory` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '库存',
  `snapshot_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '快照url',
  `collect_config_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '采集配置信息',
  `insert_time` timestamp NOT NULL DEFAULT '2025-12-11 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT '写入时间',
  `update_time` timestamp NOT NULL DEFAULT '2025-12-11 00:00:00' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '采集数据临时表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_sub_notice_log
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_sub_notice_log`;
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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '站内信通知',
  `email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '邮箱号码',
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手机号码',
  `email_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '邮箱内容',
  `mobile_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '手机内容',
  `ext_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '其它参数',
  `push_time` int(11) NOT NULL DEFAULT 0 COMMENT '设置推送时间',
  `insert_time` int(11) NOT NULL DEFAULT 0 COMMENT '写入时间',
  `sms_status` tinyint(3) NULL DEFAULT 1 COMMENT '短信状态0=已推送1=未推送',
  `internal_notice_status` tinyint(3) NULL DEFAULT 1 COMMENT '站内信状态0=已推送1=未推送',
  `email_status` tinyint(3) NULL DEFAULT 1 COMMENT '邮箱发送状态0=已推送1=未推送',
  `status` tinyint(3) NOT NULL DEFAULT 1 COMMENT '全部状态0=已推送1=未推送',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订阅推送记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_user_subscription_tmp
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_user_subscription_tmp`;
CREATE TABLE `retrieve_user_subscription_tmp`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `tmplate_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '消息模板订阅' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_user_table_config
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_user_table_config`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '表格名称',
  `data_config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '配置参数',
  `insert_time` int(11) NOT NULL DEFAULT 0 COMMENT '写入时间',
  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户展示表格配置' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_washconfig_company_category
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_washconfig_company_category`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '公司分类表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_washconfig_control_product
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_washconfig_control_product`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管控商品配置表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_washconfig_control_product_company
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_washconfig_control_product_company`;
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',
  INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管控商品公司关系' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_washconfig_lowprice_product
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_washconfig_lowprice_product`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品品牌',
  `product_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) 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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 40 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '低价商品配置表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_washconfig_lowprice_product_company
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_washconfig_lowprice_product_company`;
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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '低价商品公司关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_washconfig_lowprice_product_keyword
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_washconfig_lowprice_product_keyword`;
CREATE TABLE `retrieve_washconfig_lowprice_product_keyword`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `keyword` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关键字',
  `lowprice_product_id` int(11) NOT NULL DEFAULT 0 COMMENT '采集商品ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '低价商品关键字表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_washconfig_lowprice_product_platform
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_washconfig_lowprice_product_platform`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 169 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '低价商品平台关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_washconfig_product_category
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_washconfig_product_category`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '产品分类表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_washconfig_violation_company_member
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_washconfig_violation_company_member`;
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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '公司跟进员工关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_washconfig_violation_product
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_washconfig_violation_product`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品品牌',
  `product_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_specs` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) 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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 101 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '违规商品配置表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_washconfig_violation_product_company
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_washconfig_violation_product_company`;
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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '违规商品公司关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_washconfig_violation_product_keyword
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_washconfig_violation_product_keyword`;
CREATE TABLE `retrieve_washconfig_violation_product_keyword`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `keyword` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关键字',
  `violation_product_id` int(11) NOT NULL DEFAULT 0 COMMENT '违规商品ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '违规商品关键字表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_washconfig_violation_product_platform
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_washconfig_violation_product_platform`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '1=淘宝，2=京东，3=拼多多，4=美团，5=药师帮，6=1药城，7=药久久,8=药易购，9=药帮忙，10=熊猫药药11=药房网',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 292 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '违规商品平台关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_washconfig_violation_store
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_washconfig_violation_store`;
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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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',
  `store_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '店铺名称',
  `company_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
  `social_credit_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '违规店铺公司配置表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_website_lead_message
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_website_lead_message`;
CREATE TABLE `retrieve_website_lead_message`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '称呼姓名',
  `position` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '职位',
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手机号',
  `company_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态0=待跟进1=已跟进',
  `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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`) USING BTREE,
  INDEX `fk_potential_phone_UNIQUE`(`phone`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 157 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '潜在客户留言' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_website_lead_notice
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_website_lead_notice`;
CREATE TABLE `retrieve_website_lead_notice`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手机号',
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '邮箱号码',
  `remark` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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`) USING BTREE,
  INDEX `fk_potential_phone_UNIQUE`(`phone`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '留言短信接收人员' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_ybm_shop_info_middle
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_ybm_shop_info_middle`;
CREATE TABLE `retrieve_ybm_shop_info_middle`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `shop` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店铺名称',
  `store_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '店铺网页链接',
  `qualification_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '资质编号',
  `business_license_company` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '营业执照公司名称',
  `business_license_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '营业执照地址',
  `scrape_date` date NULL DEFAULT NULL COMMENT '爬取日期',
  `platform` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '平台',
  `province` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci 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 INDEX `shop_indx`(`shop`) USING BTREE COMMENT '店铺名称唯一'
) ENGINE = MyISAM AUTO_INCREMENT = 930 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '药久久店铺信息' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for retrieve_yjj_shop_info_middle
-- ----------------------------
DROP TABLE IF EXISTS `retrieve_yjj_shop_info_middle`;
CREATE TABLE `retrieve_yjj_shop_info_middle`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `shop` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店铺名称',
  `contact_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '联系地址',
  `qualification_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '资质编号',
  `business_license_company` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '营业执照公司名称',
  `business_license_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '营业执照地址',
  `scrape_date` date NULL DEFAULT NULL COMMENT '爬取日期',
  `platform` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '平台',
  `province` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci 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 INDEX `shop_indx`(`shop`) USING BTREE COMMENT '店铺名称唯一'
) ENGINE = MyISAM AUTO_INCREMENT = 276 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '药久久店铺信息' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `users_email_unique`(`email`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;