/* 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;