shengyudong/ai_wht_B
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
ai_wht_B/ai_wht_all.sql
“shengyudong” 5a384b694e 2026-1-6
2026-01-06 14:18:39 +08:00

833 lines
75 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

/*
Navicat Premium Dump SQL
Source Server : mixue
Source Server Type : MySQL
Source Server Version : 90001 (9.0.1)
Source Host : localhost:3306
Source Schema : ai_wht
Target Server Type : MySQL
Target Server Version : 90001 (9.0.1)
File Encoding : 65001
Date: 12/12/2025 21:01:35
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for ai_article_images
-- ----------------------------
DROP TABLE IF EXISTS `ai_article_images`;
CREATE TABLE `ai_article_images` (
`id` int NOT NULL AUTO_INCREMENT,
`article_id` int NOT NULL DEFAULT 0 COMMENT '文章ID',
`image_id` int NOT NULL DEFAULT 0 COMMENT '图片ID',
`image_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片URL',
`image_thumb_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '缩略图URL',
`image_tag_id` int NOT NULL DEFAULT 0 COMMENT '图片标签ID',
`sort_order` int NULL DEFAULT 0 COMMENT '排序',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`keywords_id` int NOT NULL DEFAULT 0 COMMENT '关键词ID',
`keywords_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关键词名称',
`department_id` int NOT NULL DEFAULT 0 COMMENT '部门ID',
`department_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '部门名称',
`image_source` tinyint(1) NOT NULL DEFAULT 0 COMMENT '图片来源：1=tag|2=change',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_article_image`(`article_id` ASC, `image_id` ASC) USING BTREE,
INDEX `idx_article_id`(`article_id` ASC) USING BTREE,
INDEX `idx_image_id`(`image_id` ASC) USING BTREE,
INDEX `idx_created_at`(`created_at` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_article_images
-- ----------------------------
-- ----------------------------
-- Table structure for ai_article_published_records
-- ----------------------------
DROP TABLE IF EXISTS `ai_article_published_records`;
CREATE TABLE `ai_article_published_records` (
`id` int NOT NULL AUTO_INCREMENT,
`article_id` int NOT NULL DEFAULT 0 COMMENT '文章ID',
`enterprise_id` int NOT NULL DEFAULT 0 COMMENT '所属企业ID',
`product_id` int NOT NULL DEFAULT 0 COMMENT '关联产品ID',
`topic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'topic主题',
`title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标题',
`created_user_id` int NOT NULL DEFAULT 0 COMMENT '创建用户ID',
`review_user_id` int NULL DEFAULT NULL COMMENT '审核用户ID',
`publish_user_id` int NULL DEFAULT NULL COMMENT '发布用户ID',
`status` enum('topic','cover_image','generate','generate_failed','draft','pending_review','approved','rejected','published_review','published','failed') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'draft' COMMENT '状态',
`channel` tinyint(1) NOT NULL DEFAULT 1 COMMENT '渠道：1=baidu|2=toutiao|3=weixin',
`review_comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '审核评论',
`publish_time` timestamp NULL DEFAULT NULL COMMENT '发布时间',
`publish_link` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发布访问链接',
`word_count` int NULL DEFAULT 0 COMMENT '字数统计',
`image_count` int NULL DEFAULT 0 COMMENT '图片数量',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_enterprise_id`(`enterprise_id` ASC) USING BTREE,
INDEX `idx_product_id`(`product_id` ASC) USING BTREE,
INDEX `idx_status`(`status` ASC) USING BTREE,
INDEX `idx_created_user_id`(`created_user_id` ASC) USING BTREE,
INDEX `idx_enterprise_product`(`enterprise_id` ASC, `product_id` ASC) USING BTREE,
INDEX `idx_status_created`(`status` ASC, `created_at` DESC) USING BTREE,
INDEX `idx_created_at`(`created_at` DESC) USING BTREE,
INDEX `idx_updated_at`(`updated_at` DESC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_article_published_records
-- ----------------------------
INSERT INTO `ai_article_published_records` VALUES (1, 0, 3, 3, '春季护理', '🌸防晒霜｜春季护理必备好物分享！', 3, NULL, NULL, 'published', 1, NULL, '2025-12-11 16:58:22', '', 0, 0, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_article_published_records` VALUES (2, 0, 6, 6, '美白淡斑', '👁️眼霜｜美白淡斑必备好物分享！', 6, NULL, NULL, 'published', 1, NULL, '2025-12-09 16:58:22', '', 0, 0, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_article_published_records` VALUES (3, 0, 9, 9, '控油祛痘', '✨精油｜控油祛痘必备好物分享！', 9, NULL, NULL, 'published', 1, NULL, '2025-12-07 16:58:22', '', 0, 0, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
-- ----------------------------
-- Table structure for ai_article_tags
-- ----------------------------
DROP TABLE IF EXISTS `ai_article_tags`;
CREATE TABLE `ai_article_tags` (
`id` int NOT NULL AUTO_INCREMENT,
`article_id` int NOT NULL DEFAULT 0 COMMENT '文章ID',
`coze_tag` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Coze生成的标签',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_article_tag`(`article_id` ASC) USING BTREE,
INDEX `idx_created_at`(`created_at` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_article_tags
-- ----------------------------
-- ----------------------------
-- Table structure for ai_articles
-- ----------------------------
DROP TABLE IF EXISTS `ai_articles`;
CREATE TABLE `ai_articles` (
`id` int NOT NULL AUTO_INCREMENT,
`batch_id` bigint UNSIGNED NOT NULL DEFAULT 0 COMMENT '批次ID',
`enterprise_id` int NOT NULL DEFAULT 0 COMMENT '所属企业ID',
`product_id` int NOT NULL DEFAULT 0 COMMENT '关联产品ID',
`topic_type_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'topic类型ID',
`prompt_workflow_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '提示词工作流ID',
`topic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'topic主题',
`title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标题',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章内容',
`department` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '部门',
`departmentids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '部门IDs',
`author_id` int NULL DEFAULT NULL COMMENT '作者ID',
`author_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '作者名称',
`department_id` int NULL DEFAULT NULL COMMENT '部门ID',
`department_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门名称',
`created_user_id` int NOT NULL DEFAULT 0 COMMENT '创建用户ID',
`review_user_id` int NULL DEFAULT NULL COMMENT '审核用户ID',
`publish_user_id` int NULL DEFAULT NULL COMMENT '发布用户ID',
`status` enum('topic','cover_image','generate','generate_failed','draft','pending_review','approved','rejected','published_review','published','failed') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'draft' COMMENT '状态',
`channel` tinyint(1) NOT NULL DEFAULT 1 COMMENT '渠道：1=baidu|2=toutiao|3=weixin',
`review_comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '审核评论',
`publish_time` timestamp NULL DEFAULT NULL COMMENT '发布时间',
`publish_link` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发布访问链接',
`baijiahao_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '百家号ID',
`baijiahao_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '百家号状态',
`word_count` int NULL DEFAULT 0 COMMENT '字数统计',
`image_count` int NULL DEFAULT 0 COMMENT '图片数量',
`coze_tag` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Coze生成的标签',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_enterprise_id`(`enterprise_id` ASC) USING BTREE,
INDEX `idx_product_id`(`product_id` ASC) USING BTREE,
INDEX `idx_status`(`status` ASC) USING BTREE,
INDEX `idx_created_user_id`(`created_user_id` ASC) USING BTREE,
INDEX `idx_enterprise_product`(`enterprise_id` ASC, `product_id` ASC) USING BTREE,
INDEX `idx_status_created`(`status` ASC, `created_at` DESC) USING BTREE,
INDEX `idx_created_at`(`created_at` DESC) USING BTREE,
INDEX `idx_updated_at`(`updated_at` DESC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_articles
-- ----------------------------
INSERT INTO `ai_articles` VALUES (1, 1, 1, 1, 0, 1, '秋冬补水', '💧美白面膜｜秋冬补水必备好物分享！', '姐妹们！今天必须给你们安利这款美白面膜✨\n\n🌟 产品亮点：\n- 秋冬补水效果超级好\n- 温和不刺激，敏感肌也能用\n- 性价比超高，学生党必入', '', '', NULL, NULL, NULL, NULL, 1, NULL, NULL, 'draft', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_articles` VALUES (2, 2, 2, 2, 0, 2, '夏日防晒', '☀️保湿精华｜夏日防晒必备好物分享！', '夏天到了，防晒很重要...', '', '', NULL, NULL, NULL, NULL, 2, NULL, NULL, 'approved', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_articles` VALUES (3, 3, 3, 3, 0, 3, '春季护理', '🌸防晒霜｜春季护理必备好物分享！', '春天来了，护肤正当时...', '', '', NULL, NULL, NULL, NULL, 3, NULL, NULL, 'published', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_articles` VALUES (4, 4, 4, 4, 0, 4, '日常保养', '💄口红套装｜日常保养必备好物分享！', '日常保养不能少...', '', '', NULL, NULL, NULL, NULL, 4, NULL, NULL, 'draft', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_articles` VALUES (5, 5, 5, 5, 0, 5, '深层清洁', '🧼洗面奶｜深层清洁必备好物分享！', '深层清洁很重要...', '', '', NULL, NULL, NULL, NULL, 5, NULL, NULL, 'approved', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_articles` VALUES (6, 6, 6, 6, 0, 6, '美白淡斑', '👁️眼霜｜美白淡斑必备好物分享！', '美白淡斑用这个...', '', '', NULL, NULL, NULL, NULL, 6, NULL, NULL, 'published', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_articles` VALUES (7, 7, 7, 7, 0, 7, '抗衰老', '💋粉底液｜抗衰老必备好物分享！', '抗衰老从现在开始...', '', '', NULL, NULL, NULL, NULL, 7, NULL, NULL, 'draft', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_articles` VALUES (8, 8, 8, 8, 0, 8, '敏感修复', '🌿卸妆水｜敏感修复必备好物分享！', '敏感肌修复神器...', '', '', NULL, NULL, NULL, NULL, 8, NULL, NULL, 'approved', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_articles` VALUES (9, 9, 9, 9, 0, 9, '控油祛痘', '✨精油｜控油祛痘必备好物分享！', '控油祛痘有妙招...', '', '', NULL, NULL, NULL, NULL, 9, NULL, NULL, 'published', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_articles` VALUES (10, 10, 10, 10, 0, 10, '滋养保湿', '🌹护手霜｜滋养保湿必备好物分享！', '手部护理不能忘...', '', '', NULL, NULL, NULL, NULL, 10, NULL, NULL, 'draft', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_articles` VALUES (12, 0, 1, 13, 0, 14, '测试主题2', '关于测试产品的测试主题2分享', '这是一篇关于测试主题2的精彩内容...', '', '', NULL, NULL, NULL, NULL, 0, NULL, NULL, 'draft', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 17:51:54', '2025-12-12 17:51:54');
INSERT INTO `ai_articles` VALUES (14, 0, 1, 13, 0, 15, '测试主题2', '关于测试产品的测试主题2分享', '这是一篇关于测试主题2的精彩内容...', '', '', NULL, NULL, NULL, NULL, 0, NULL, NULL, 'draft', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 17:57:03', '2025-12-12 17:57:03');
INSERT INTO `ai_articles` VALUES (16, 0, 1, 13, 0, 16, '测试主题2', '关于测试产品的测试主题2分享', '这是一篇关于测试主题2的精彩内容...', '', '', NULL, NULL, NULL, NULL, 0, NULL, NULL, 'draft', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 18:50:34', '2025-12-12 18:50:34');
INSERT INTO `ai_articles` VALUES (18, 0, 1, 13, 0, 16, '测试主题2', '关于测试产品的测试主题2分享', '这是一篇关于测试主题2的精彩内容...', '', '', NULL, NULL, NULL, NULL, 0, NULL, NULL, 'draft', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 18:52:01', '2025-12-12 18:52:01');
INSERT INTO `ai_articles` VALUES (20, 0, 1, 13, 0, 16, '测试主题2', '关于测试产品的测试主题2分享', '这是一篇关于测试主题2的精彩内容...', '', '', NULL, NULL, NULL, NULL, 0, NULL, NULL, 'draft', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 18:52:51', '2025-12-12 18:52:51');
INSERT INTO `ai_articles` VALUES (22, 0, 1, 13, 0, 16, '测试主题2', '关于测试产品的测试主题2分享', '这是一篇关于测试主题2的精彩内容...', '', '', NULL, NULL, NULL, NULL, 0, NULL, NULL, 'draft', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 18:58:42', '2025-12-12 18:58:42');
INSERT INTO `ai_articles` VALUES (24, 0, 1, 13, 0, 16, '测试主题2', '关于测试产品的测试主题2分享', '这是一篇关于测试主题2的精彩内容...', '', '', NULL, NULL, NULL, NULL, 0, NULL, NULL, 'draft', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 18:59:52', '2025-12-12 18:59:52');
INSERT INTO `ai_articles` VALUES (26, 0, 1, 13, 0, 16, '测试主题2', '关于测试产品的测试主题2分享', '这是一篇关于测试主题2的精彩内容...', '', '', NULL, NULL, NULL, NULL, 0, NULL, NULL, 'draft', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 19:00:53', '2025-12-12 19:00:53');
INSERT INTO `ai_articles` VALUES (28, 0, 1, 13, 0, 16, '测试主题2', '关于测试产品的测试主题2分享', '这是一篇关于测试主题2的精彩内容...', '', '', NULL, NULL, NULL, NULL, 0, NULL, NULL, 'draft', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 19:06:20', '2025-12-12 19:06:20');
INSERT INTO `ai_articles` VALUES (30, 0, 1, 13, 0, 16, '测试主题2', '关于测试产品的测试主题2分享', '这是一篇关于测试主题2的精彩内容...', '', '', NULL, NULL, NULL, NULL, 0, NULL, NULL, 'draft', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 19:07:25', '2025-12-12 19:07:25');
INSERT INTO `ai_articles` VALUES (31, 0, 1, 13, 0, 25, 'ffffffffffff', '关于测试产品的ffffffffffff分享', '这是一篇关于ffffffffffff的精彩内容...', '', '', NULL, NULL, NULL, NULL, 0, NULL, NULL, 'draft', 1, NULL, NULL, '', NULL, NULL, 0, 0, NULL, '2025-12-12 20:53:25', '2025-12-12 20:53:25');
-- ----------------------------
-- Table structure for ai_authors
-- ----------------------------
DROP TABLE IF EXISTS `ai_authors`;
CREATE TABLE `ai_authors` (
`id` int NOT NULL AUTO_INCREMENT,
`author_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '作者名称',
`app_id` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '应用ID',
`app_token` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '应用Token',
`department_id` int NOT NULL DEFAULT 0 COMMENT '部门ID',
`department_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '部门名称',
`department` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '部门',
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '职称',
`hospital` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '医院',
`specialty` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '专业',
`toutiao_cookie` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '头条Cookie',
`toutiao_images_cookie` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '头条图片Cookie',
`introduction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '介绍',
`avatar_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像URL',
`status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'active' COMMENT '状态',
`channel` tinyint(1) NOT NULL DEFAULT 1 COMMENT '渠道：1=baidu|2=toutiao|3=weixin',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_status`(`status` ASC) USING BTREE,
INDEX `idx_department_id`(`department_id` ASC) USING BTREE,
INDEX `idx_channel`(`channel` ASC) USING BTREE,
INDEX `idx_created_at`(`created_at` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_authors
-- ----------------------------
-- ----------------------------
-- Table structure for ai_data_statistics
-- ----------------------------
DROP TABLE IF EXISTS `ai_data_statistics`;
CREATE TABLE `ai_data_statistics` (
`id` int NOT NULL AUTO_INCREMENT,
`enterprise_id` int NOT NULL DEFAULT 0 COMMENT '所属企业ID',
`product_id` int NOT NULL DEFAULT 0 COMMENT '关联产品ID',
`cumulative_releases_num` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '累计发布',
`published_today_num` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '今日发布',
`published_week_num` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '本周发布',
`participating_employees_num` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '参与员工',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_enterprise_id`(`enterprise_id` ASC) USING BTREE,
INDEX `idx_product_id`(`product_id` ASC) USING BTREE,
INDEX `idx_enterprise_product`(`enterprise_id` ASC, `product_id` ASC) USING BTREE,
INDEX `idx_created_at`(`created_at` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_data_statistics
-- ----------------------------
INSERT INTO `ai_data_statistics` VALUES (1, 1, 1, 10, 2, 5, 3, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_data_statistics` VALUES (2, 2, 2, 15, 3, 8, 4, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_data_statistics` VALUES (3, 3, 3, 20, 4, 10, 5, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_data_statistics` VALUES (4, 4, 4, 12, 1, 6, 3, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_data_statistics` VALUES (5, 5, 5, 18, 2, 9, 4, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_data_statistics` VALUES (6, 6, 6, 25, 5, 12, 6, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_data_statistics` VALUES (7, 7, 7, 8, 1, 4, 2, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_data_statistics` VALUES (8, 8, 8, 22, 3, 11, 5, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_data_statistics` VALUES (9, 9, 9, 30, 6, 15, 7, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_data_statistics` VALUES (10, 10, 10, 14, 2, 7, 3, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
-- ----------------------------
-- Table structure for ai_departments
-- ----------------------------
DROP TABLE IF EXISTS `ai_departments`;
CREATE TABLE `ai_departments` (
`id` int NOT NULL AUTO_INCREMENT,
`department_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '部门名称',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_ai_departments_created_at`(`created_at` DESC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_departments
-- ----------------------------
-- ----------------------------
-- Table structure for ai_enterprises
-- ----------------------------
DROP TABLE IF EXISTS `ai_enterprises`;
CREATE TABLE `ai_enterprises` (
`id` int NOT NULL AUTO_INCREMENT,
`enterprise_ID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '企业ID',
`name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '企业名称',
`short_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '企业简称',
`icon` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '企业图标URL',
`phone` varchar(20) 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 '登录密码（加密存储）',
`email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '企业邮箱',
`website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '企业网站',
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '企业地址',
`status` enum('active','disabled') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active' COMMENT '状态',
`users_total` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '员工总数',
`products_total` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '产品总数',
`published_total` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '文章发布总数',
`articles_total` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '文章总数',
`released_month_total` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '本月发布数量',
`linked_to_xhs_num` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '绑定小红书',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_phone`(`phone` ASC) USING BTREE,
INDEX `idx_status`(`status` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '企业信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of ai_enterprises
-- ----------------------------
INSERT INTO `ai_enterprises` VALUES (1, 'ENT-2024-0001', '测试企业1号', '企业1222', '', '13800138001', '240be518fabd2724ddb6f04eeb1da5967448d7e831c08c8fa822809f74c720a9', 'raowenlong@vizee.cn', '', '', 'active', 2, 1, 0, 12, 0, 0, '2025-12-12 16:58:22', '2025-12-12 20:53:25');
INSERT INTO `ai_enterprises` VALUES (2, 'ENT-2024-0002', '测试企业2号', '企业2', '', '13800138002', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', 'ent2@test.com', '', '', 'active', 1, 1, 0, 1, 0, 0, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_enterprises` VALUES (3, 'ENT-2024-0003', '测试企业3号', '企业3', '', '13800138003', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', 'ent3@test.com', '', '', 'active', 1, 1, 0, 1, 0, 0, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_enterprises` VALUES (4, 'ENT-2024-0004', '测试企业4号', '企业4', '', '13800138004', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', 'ent4@test.com', '', '', 'active', 1, 1, 0, 1, 0, 0, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_enterprises` VALUES (5, 'ENT-2024-0005', '测试企业5号', '企业5', '', '13800138005', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', 'ent5@test.com', '', '', 'active', 1, 1, 0, 1, 0, 0, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_enterprises` VALUES (6, 'ENT-2024-0006', '测试企业6号', '企业6', '', '13800138006', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', 'ent6@test.com', '', '', 'active', 1, 1, 0, 1, 0, 0, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_enterprises` VALUES (7, 'ENT-2024-0007', '测试企业7号', '企业7', '', '13800138007', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', 'ent7@test.com', '', '', 'active', 1, 1, 0, 1, 0, 0, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_enterprises` VALUES (8, 'ENT-2024-0008', '测试企业8号', '企业8', '', '13800138008', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', 'ent8@test.com', '', '', 'active', 1, 1, 0, 1, 0, 0, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_enterprises` VALUES (9, 'ENT-2024-0009', '测试企业9号', '企业9', '', '13800138009', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', 'ent9@test.com', '', '', 'disabled', 1, 1, 0, 1, 0, 0, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_enterprises` VALUES (10, 'ENT-2024-0010', '测试企业10号', '企业10', '', '13800138010', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', 'ent10@test.com', '', '', 'disabled', 1, 1, 0, 1, 0, 0, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_enterprises` VALUES (11, 'ENT-20251212-D7B17FC2', '测试企业API_1765537579', '更新后的企业', '', '13865537579', '85777f270ad7cf2a790981bbae3c4e484a1dc55e24a77390d692fbf1cffa12fa', 'updated@enterprise.com', '', '', 'disabled', 0, 0, 0, 0, 0, 0, '2025-12-12 19:06:19', '2025-12-12 19:06:19');
-- ----------------------------
-- Table structure for ai_image_tags
-- ----------------------------
DROP TABLE IF EXISTS `ai_image_tags`;
CREATE TABLE `ai_image_tags` (
`id` int NOT NULL AUTO_INCREMENT,
`image_id` int NOT NULL DEFAULT 0 COMMENT '图片ID',
`image_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片名称',
`image_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片URL',
`image_thumb_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '缩略图URL',
`tag_id` int NOT NULL DEFAULT 0 COMMENT '标签ID',
`tag_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标签名称',
`keywords_id` int NOT NULL DEFAULT 0 COMMENT '关键词ID',
`keywords_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关键词名称',
`department_id` int NOT NULL DEFAULT 0 COMMENT '部门ID',
`department_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '部门名称',
`created_user_id` int NOT NULL DEFAULT 0 COMMENT '创建用户ID',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_image_tag`(`image_id` ASC, `tag_id` ASC) USING BTREE,
INDEX `idx_tag_id`(`tag_id` ASC) USING BTREE,
INDEX `idx_department_id`(`department_id` ASC) USING BTREE,
INDEX `idx_keywords_id`(`keywords_id` ASC) USING BTREE,
INDEX `idx_created_at`(`created_at` ASC) USING BTREE,
INDEX `idx_dept_keywords`(`department_id` ASC, `keywords_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_image_tags
-- ----------------------------
-- ----------------------------
-- Table structure for ai_image_tags_name
-- ----------------------------
DROP TABLE IF EXISTS `ai_image_tags_name`;
CREATE TABLE `ai_image_tags_name` (
`id` int NOT NULL AUTO_INCREMENT,
`tag_name` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标签名称',
`tag_category` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标签分类',
`department` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门',
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '描述',
`status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'active' COMMENT '状态',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_tag_name`(`tag_name`(191) ASC) USING BTREE,
INDEX `idx_status`(`status` ASC) USING BTREE,
INDEX `idx_created_at`(`created_at` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_image_tags_name
-- ----------------------------
-- ----------------------------
-- Table structure for ai_image_tags_relation
-- ----------------------------
DROP TABLE IF EXISTS `ai_image_tags_relation`;
CREATE TABLE `ai_image_tags_relation` (
`id` int NOT NULL AUTO_INCREMENT,
`image_id` int NOT NULL DEFAULT 0 COMMENT '图片ID',
`image_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片名称',
`tag_id` int NOT NULL DEFAULT 0 COMMENT '标签ID',
`tag_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标签名称',
`created_user_id` int NOT NULL DEFAULT 0 COMMENT '创建用户ID',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_image_tag`(`image_id` ASC, `tag_id` ASC) USING BTREE,
INDEX `idx_tag_id`(`tag_id` ASC) USING BTREE,
INDEX `idx_created_at`(`created_at` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_image_tags_relation
-- ----------------------------
-- ----------------------------
-- Table structure for ai_image_type
-- ----------------------------
DROP TABLE IF EXISTS `ai_image_type`;
CREATE TABLE `ai_image_type` (
`id` int NOT NULL AUTO_INCREMENT,
`type_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片类型，场景图',
`keywords_id` int NOT NULL DEFAULT 0 COMMENT '关键词ID',
`keywords_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关键词名称',
`department_id` int NOT NULL DEFAULT 0 COMMENT '部门ID',
`department_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '部门名称',
`created_user_id` int NOT NULL DEFAULT 0 COMMENT '创建用户ID',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_department_id`(`department_id` ASC) USING BTREE,
INDEX `idx_keywords_id`(`keywords_id` ASC) USING BTREE,
INDEX `idx_created_at`(`created_at` ASC) USING BTREE,
INDEX `idx_dept_keywords`(`department_id` ASC, `keywords_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_image_type
-- ----------------------------
INSERT INTO `ai_image_type` VALUES (1, '产品图', 0, '', 1, '', 0, '2025-12-12 16:56:24', '2025-12-12 16:56:24');
INSERT INTO `ai_image_type` VALUES (2, '场景图', 0, '', 2, '', 0, '2025-12-12 16:56:24', '2025-12-12 16:56:24');
INSERT INTO `ai_image_type` VALUES (3, '细节图', 0, '', 3, '', 0, '2025-12-12 16:56:24', '2025-12-12 16:56:24');
INSERT INTO `ai_image_type` VALUES (4, '效果图', 0, '', 4, '', 0, '2025-12-12 16:56:24', '2025-12-12 16:56:24');
INSERT INTO `ai_image_type` VALUES (5, '对比图', 0, '', 5, '', 0, '2025-12-12 16:56:24', '2025-12-12 16:56:24');
INSERT INTO `ai_image_type` VALUES (6, '包装图', 0, '', 6, '', 0, '2025-12-12 16:56:24', '2025-12-12 16:56:24');
INSERT INTO `ai_image_type` VALUES (7, '使用图', 0, '', 7, '', 0, '2025-12-12 16:56:24', '2025-12-12 16:56:24');
INSERT INTO `ai_image_type` VALUES (8, '成分图', 0, '', 8, '', 0, '2025-12-12 16:56:24', '2025-12-12 16:56:24');
INSERT INTO `ai_image_type` VALUES (9, '认证图', 0, '', 9, '', 0, '2025-12-12 16:56:24', '2025-12-12 16:56:24');
INSERT INTO `ai_image_type` VALUES (10, '其他', 0, '', 10, '', 0, '2025-12-12 16:56:24', '2025-12-12 16:56:24');
-- ----------------------------
-- Table structure for ai_images
-- ----------------------------
DROP TABLE IF EXISTS `ai_images`;
CREATE TABLE `ai_images` (
`id` int NOT NULL AUTO_INCREMENT,
`image_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片名称',
`image_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片URL',
`image_thumb_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '缩略图URL',
`thumbnail_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '缩略图URL',
`department` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门',
`keywords` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关键词',
`size_type` enum('medical','lifestyle','instruction') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'medical' COMMENT '尺寸类型',
`image_type_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '图片类型ID',
`image_type_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片类型，场景图',
`file_size` bigint NULL DEFAULT NULL COMMENT '文件大小',
`width` int NULL DEFAULT NULL COMMENT '图片宽度',
`height` int NULL DEFAULT NULL COMMENT '图片高度',
`upload_user_id` int NOT NULL DEFAULT 0 COMMENT '上传用户ID',
`status` enum('active','inactive','deleted') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'active' COMMENT '状态',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_upload_user_id`(`upload_user_id` ASC) USING BTREE,
INDEX `idx_status`(`status` ASC) USING BTREE,
INDEX `idx_image_type_id`(`image_type_id` ASC) USING BTREE,
INDEX `idx_created_at`(`created_at` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_images
-- ----------------------------
INSERT INTO `ai_images` VALUES (1, '测试图片', 'https://cdn.test.com/test_image.jpg', '', '', '', '', 'medical', 0, '产品图', NULL, NULL, NULL, 1, 'deleted', '2025-12-12 18:52:01', '2025-12-12 18:52:01');
INSERT INTO `ai_images` VALUES (2, '批量图片1', 'https://cdn.test.com/batch1.jpg', '', '', '', '', 'medical', 0, '场景图', NULL, NULL, NULL, 1, 'active', '2025-12-12 18:52:01', '2025-12-12 18:52:01');
INSERT INTO `ai_images` VALUES (3, '批量图片2', 'https://cdn.test.com/batch2.jpg', '', '', '', '', 'medical', 0, '细节图', NULL, NULL, NULL, 1, 'active', '2025-12-12 18:52:01', '2025-12-12 18:52:01');
INSERT INTO `ai_images` VALUES (4, '测试图片', 'https://cdn.test.com/test_image.jpg', '', '', '', '', 'medical', 0, '产品图', NULL, NULL, NULL, 1, 'deleted', '2025-12-12 18:52:51', '2025-12-12 18:52:51');
INSERT INTO `ai_images` VALUES (5, '批量图片1', 'https://cdn.test.com/batch1.jpg', '', '', '', '', 'medical', 0, '场景图', NULL, NULL, NULL, 1, 'active', '2025-12-12 18:52:51', '2025-12-12 18:52:51');
INSERT INTO `ai_images` VALUES (6, '批量图片2', 'https://cdn.test.com/batch2.jpg', '', '', '', '', 'medical', 0, '细节图', NULL, NULL, NULL, 1, 'active', '2025-12-12 18:52:51', '2025-12-12 18:52:51');
INSERT INTO `ai_images` VALUES (7, '测试图片', 'https://cdn.test.com/test_image.jpg', '', '', '', '', 'medical', 0, '产品图', NULL, NULL, NULL, 1, 'deleted', '2025-12-12 18:58:42', '2025-12-12 18:58:42');
INSERT INTO `ai_images` VALUES (8, '批量图片1', 'https://cdn.test.com/batch1.jpg', '', '', '', '', 'medical', 0, '场景图', NULL, NULL, NULL, 1, 'active', '2025-12-12 18:58:42', '2025-12-12 18:58:42');
INSERT INTO `ai_images` VALUES (9, '批量图片2', 'https://cdn.test.com/batch2.jpg', '', '', '', '', 'medical', 0, '细节图', NULL, NULL, NULL, 1, 'active', '2025-12-12 18:58:42', '2025-12-12 18:58:42');
INSERT INTO `ai_images` VALUES (10, '测试图片', 'https://cdn.test.com/test_image.jpg', '', '', '', '', 'medical', 0, '产品图', NULL, NULL, NULL, 1, 'deleted', '2025-12-12 18:59:52', '2025-12-12 18:59:52');
INSERT INTO `ai_images` VALUES (11, '批量图片1', 'https://cdn.test.com/batch1.jpg', '', '', '', '', 'medical', 0, '场景图', NULL, NULL, NULL, 1, 'active', '2025-12-12 18:59:52', '2025-12-12 18:59:52');
INSERT INTO `ai_images` VALUES (12, '批量图片2', 'https://cdn.test.com/batch2.jpg', '', '', '', '', 'medical', 0, '细节图', NULL, NULL, NULL, 1, 'active', '2025-12-12 18:59:52', '2025-12-12 18:59:52');
INSERT INTO `ai_images` VALUES (13, '测试图片', 'https://cdn.test.com/test_image.jpg', '', '', '', '', 'medical', 0, '产品图', NULL, NULL, NULL, 1, 'deleted', '2025-12-12 19:00:53', '2025-12-12 19:00:53');
INSERT INTO `ai_images` VALUES (14, '批量图片1', 'https://cdn.test.com/batch1.jpg', '', '', '', '', 'medical', 0, '场景图', NULL, NULL, NULL, 1, 'active', '2025-12-12 19:00:53', '2025-12-12 19:00:53');
INSERT INTO `ai_images` VALUES (15, '批量图片2', 'https://cdn.test.com/batch2.jpg', '', '', '', '', 'medical', 0, '细节图', NULL, NULL, NULL, 1, 'active', '2025-12-12 19:00:53', '2025-12-12 19:00:53');
INSERT INTO `ai_images` VALUES (16, '测试图片', 'https://cdn.test.com/test_image.jpg', '', '', '', '', 'medical', 0, '产品图', NULL, NULL, NULL, 1, 'deleted', '2025-12-12 19:06:20', '2025-12-12 19:06:20');
INSERT INTO `ai_images` VALUES (17, '批量图片1', 'https://cdn.test.com/batch1.jpg', '', '', '', '', 'medical', 0, '场景图', NULL, NULL, NULL, 1, 'active', '2025-12-12 19:06:20', '2025-12-12 19:06:20');
INSERT INTO `ai_images` VALUES (18, '批量图片2', 'https://cdn.test.com/batch2.jpg', '', '', '', '', 'medical', 0, '细节图', NULL, NULL, NULL, 1, 'active', '2025-12-12 19:06:20', '2025-12-12 19:06:20');
INSERT INTO `ai_images` VALUES (19, '测试图片', 'https://cdn.test.com/test_image.jpg', '', '', '', '', 'medical', 0, '产品图', NULL, NULL, NULL, 1, 'deleted', '2025-12-12 19:07:24', '2025-12-12 19:07:24');
INSERT INTO `ai_images` VALUES (20, '批量图片1', 'https://cdn.test.com/batch1.jpg', '', '', '', '', 'medical', 0, '场景图', NULL, NULL, NULL, 1, 'active', '2025-12-12 19:07:24', '2025-12-12 19:07:24');
INSERT INTO `ai_images` VALUES (21, '批量图片2', 'https://cdn.test.com/batch2.jpg', '', '', '', '', 'medical', 0, '细节图', NULL, NULL, NULL, 1, 'active', '2025-12-12 19:07:24', '2025-12-12 19:07:24');
INSERT INTO `ai_images` VALUES (22, 'fff', 'blob:http://localhost:5174/efc2af21-345c-4e1b-9497-d1901966c8aa', '', '', '', '', 'medical', 0, '场景图', NULL, NULL, NULL, 1, 'active', '2025-12-12 20:52:43', '2025-12-12 20:52:43');
-- ----------------------------
-- Table structure for ai_logs
-- ----------------------------
DROP TABLE IF EXISTS `ai_logs`;
CREATE TABLE `ai_logs` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int NULL DEFAULT NULL COMMENT '用户ID',
`action` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '操作动作',
`target_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '目标类型',
`target_id` int NULL DEFAULT NULL COMMENT '目标ID',
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '描述',
`ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'IP地址',
`user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '用户代理',
`request_data` json NULL COMMENT '请求数据',
`response_data` json NULL COMMENT '响应数据',
`status` enum('success','error','warning') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'success' COMMENT '状态',
`error_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '错误消息',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_user_id`(`user_id` ASC) USING BTREE,
INDEX `idx_status`(`status` ASC) USING BTREE,
INDEX `idx_action`(`action` ASC) USING BTREE,
INDEX `idx_created_at`(`created_at` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_logs
-- ----------------------------
-- ----------------------------
-- Table structure for ai_product_images
-- ----------------------------
DROP TABLE IF EXISTS `ai_product_images`;
CREATE TABLE `ai_product_images` (
`id` int NOT NULL AUTO_INCREMENT,
`enterprise_id` int NOT NULL DEFAULT 0 COMMENT '所属企业ID',
`product_id` int NOT NULL DEFAULT 0 COMMENT '关联产品ID',
`image_id` int NOT NULL DEFAULT 0 COMMENT '图片ID',
`image_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片名称',
`image_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片URL',
`thumbnail_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '缩略图URL',
`type_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片类型',
`description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片描述',
`file_size` bigint NULL DEFAULT NULL COMMENT '文件大小',
`width` int NULL DEFAULT NULL COMMENT '图片宽度',
`height` int NULL DEFAULT NULL COMMENT '图片高度',
`upload_user_id` int NOT NULL DEFAULT 0 COMMENT '上传用户ID',
`status` enum('active','deleted') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'active' COMMENT '状态',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上传时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_enterprise_id`(`enterprise_id` ASC) USING BTREE,
INDEX `idx_product_id`(`product_id` ASC) USING BTREE,
INDEX `idx_status`(`status` ASC) USING BTREE,
INDEX `idx_enterprise_product`(`enterprise_id` ASC, `product_id` ASC) USING BTREE,
INDEX `idx_created_at`(`created_at` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '产品图片库表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of ai_product_images
-- ----------------------------
INSERT INTO `ai_product_images` VALUES (1, 1, 1, 0, '', 'https://cdn.test.com/image1.jpg', 'https://cdn.test.com/thumb1.jpg', '产品图', '美白面膜产品图', NULL, NULL, NULL, 1, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_product_images` VALUES (2, 2, 2, 0, '', 'https://cdn.test.com/image2.jpg', 'https://cdn.test.com/thumb2.jpg', '场景图', '保湿精华场景图', NULL, NULL, NULL, 2, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_product_images` VALUES (3, 3, 3, 0, '', 'https://cdn.test.com/image3.jpg', 'https://cdn.test.com/thumb3.jpg', '细节图', '防晒霜细节图', NULL, NULL, NULL, 3, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_product_images` VALUES (4, 4, 4, 0, '', 'https://cdn.test.com/image4.jpg', 'https://cdn.test.com/thumb4.jpg', '效果图', '口红效果图', NULL, NULL, NULL, 4, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_product_images` VALUES (5, 5, 5, 0, '', 'https://cdn.test.com/image5.jpg', 'https://cdn.test.com/thumb5.jpg', '产品图', '洗面奶产品图', NULL, NULL, NULL, 5, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_product_images` VALUES (6, 6, 6, 0, '', 'https://cdn.test.com/image6.jpg', 'https://cdn.test.com/thumb6.jpg', '场景图', '眼霜场景图', NULL, NULL, NULL, 6, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_product_images` VALUES (7, 7, 7, 0, '', 'https://cdn.test.com/image7.jpg', 'https://cdn.test.com/thumb7.jpg', '细节图', '粉底液细节图', NULL, NULL, NULL, 7, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_product_images` VALUES (8, 8, 8, 0, '', 'https://cdn.test.com/image8.jpg', 'https://cdn.test.com/thumb8.jpg', '效果图', '卸妆水效果图', NULL, NULL, NULL, 8, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_product_images` VALUES (9, 9, 9, 0, '', 'https://cdn.test.com/image9.jpg', 'https://cdn.test.com/thumb9.jpg', '产品图', '精油产品图', NULL, NULL, NULL, 9, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_product_images` VALUES (10, 10, 10, 0, '', 'https://cdn.test.com/image10.jpg', 'https://cdn.test.com/thumb10.jpg', '场景图', '护手霜场景图', NULL, NULL, NULL, 10, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
-- ----------------------------
-- Table structure for ai_product_tags
-- ----------------------------
DROP TABLE IF EXISTS `ai_product_tags`;
CREATE TABLE `ai_product_tags` (
`id` int NOT NULL AUTO_INCREMENT,
`enterprise_id` int NOT NULL DEFAULT 0 COMMENT '所属企业ID',
`product_id` int NOT NULL DEFAULT 0 COMMENT '关联产品ID',
`tag_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品的标签',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_enterprise_product_tag`(`enterprise_id` ASC, `product_id` ASC, `tag_name`(100) ASC) USING BTREE,
INDEX `idx_enterprise_id`(`enterprise_id` ASC) USING BTREE,
INDEX `idx_product_id`(`product_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_product_tags
-- ----------------------------
INSERT INTO `ai_product_tags` VALUES (1, 1, 1, '保湿', '2025-12-12 16:58:22');
INSERT INTO `ai_product_tags` VALUES (2, 2, 2, '美白', '2025-12-12 16:58:22');
INSERT INTO `ai_product_tags` VALUES (3, 3, 3, '防晒', '2025-12-12 16:58:22');
INSERT INTO `ai_product_tags` VALUES (4, 4, 4, '彩妆', '2025-12-12 16:58:22');
INSERT INTO `ai_product_tags` VALUES (5, 5, 5, '清洁', '2025-12-12 16:58:22');
INSERT INTO `ai_product_tags` VALUES (6, 6, 6, '抗衰老', '2025-12-12 16:58:22');
INSERT INTO `ai_product_tags` VALUES (7, 7, 7, '遮瑕', '2025-12-12 16:58:22');
INSERT INTO `ai_product_tags` VALUES (8, 8, 8, '温和', '2025-12-12 16:58:22');
INSERT INTO `ai_product_tags` VALUES (9, 9, 9, '修复', '2025-12-12 16:58:22');
INSERT INTO `ai_product_tags` VALUES (10, 10, 10, '滋养', '2025-12-12 16:58:22');
INSERT INTO `ai_product_tags` VALUES (11, 1, 14, '1', '2025-12-12 17:51:54');
INSERT INTO `ai_product_tags` VALUES (12, 1, 14, '2', '2025-12-12 17:51:54');
INSERT INTO `ai_product_tags` VALUES (13, 1, 15, '1', '2025-12-12 17:57:02');
INSERT INTO `ai_product_tags` VALUES (14, 1, 15, '2', '2025-12-12 17:57:02');
INSERT INTO `ai_product_tags` VALUES (15, 1, 16, '1', '2025-12-12 18:50:34');
INSERT INTO `ai_product_tags` VALUES (16, 1, 16, '2', '2025-12-12 18:50:34');
INSERT INTO `ai_product_tags` VALUES (17, 1, 17, '1', '2025-12-12 18:52:01');
INSERT INTO `ai_product_tags` VALUES (18, 1, 17, '2', '2025-12-12 18:52:01');
INSERT INTO `ai_product_tags` VALUES (19, 1, 18, '1', '2025-12-12 18:52:50');
INSERT INTO `ai_product_tags` VALUES (20, 1, 18, '2', '2025-12-12 18:52:50');
INSERT INTO `ai_product_tags` VALUES (21, 1, 19, '1', '2025-12-12 18:58:42');
INSERT INTO `ai_product_tags` VALUES (22, 1, 19, '2', '2025-12-12 18:58:42');
INSERT INTO `ai_product_tags` VALUES (23, 1, 20, '1', '2025-12-12 18:59:51');
INSERT INTO `ai_product_tags` VALUES (24, 1, 20, '2', '2025-12-12 18:59:51');
INSERT INTO `ai_product_tags` VALUES (25, 1, 21, '1', '2025-12-12 19:00:53');
INSERT INTO `ai_product_tags` VALUES (26, 1, 21, '2', '2025-12-12 19:00:53');
INSERT INTO `ai_product_tags` VALUES (27, 1, 22, '1', '2025-12-12 19:06:20');
INSERT INTO `ai_product_tags` VALUES (28, 1, 22, '2', '2025-12-12 19:06:20');
INSERT INTO `ai_product_tags` VALUES (29, 1, 23, '1', '2025-12-12 19:07:24');
INSERT INTO `ai_product_tags` VALUES (30, 1, 23, '2', '2025-12-12 19:07:24');
-- ----------------------------
-- Table structure for ai_product_types
-- ----------------------------
DROP TABLE IF EXISTS `ai_product_types`;
CREATE TABLE `ai_product_types` (
`id` int NOT NULL AUTO_INCREMENT,
`type_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品类型名称',
`enterprise_id` int NOT NULL DEFAULT 0 COMMENT '所属企业ID',
`product_id` int NOT NULL DEFAULT 0 COMMENT '关联产品ID',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_enterprise_product_type`(`enterprise_id` ASC, `product_id` ASC, `type_name` ASC) USING BTREE,
INDEX `idx_enterprise_id`(`enterprise_id` ASC) USING BTREE,
INDEX `idx_product_id`(`product_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_product_types
-- ----------------------------
INSERT INTO `ai_product_types` VALUES (1, '护肤品', 0, 0, '2025-12-12 16:56:24');
INSERT INTO `ai_product_types` VALUES (2, '彩妆', 0, 0, '2025-12-12 16:56:24');
INSERT INTO `ai_product_types` VALUES (3, '美发护发', 0, 0, '2025-12-12 16:56:24');
INSERT INTO `ai_product_types` VALUES (4, '身体护理', 0, 0, '2025-12-12 16:56:24');
INSERT INTO `ai_product_types` VALUES (5, '香水', 0, 0, '2025-12-12 16:56:24');
INSERT INTO `ai_product_types` VALUES (6, '男士护理', 0, 0, '2025-12-12 16:56:24');
INSERT INTO `ai_product_types` VALUES (7, '美容工具', 0, 0, '2025-12-12 16:56:24');
INSERT INTO `ai_product_types` VALUES (8, '洗护用品', 0, 0, '2025-12-12 16:56:24');
INSERT INTO `ai_product_types` VALUES (9, '口腔护理', 0, 0, '2025-12-12 16:56:24');
INSERT INTO `ai_product_types` VALUES (10, '防晒产品', 0, 0, '2025-12-12 16:56:24');
-- ----------------------------
-- Table structure for ai_products
-- ----------------------------
DROP TABLE IF EXISTS `ai_products`;
CREATE TABLE `ai_products` (
`id` int NOT NULL AUTO_INCREMENT,
`enterprise_id` int NOT NULL DEFAULT 0 COMMENT '所属企业ID',
`name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品名称',
`type_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品类型',
`image_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '产品主图URL',
`image_thumbnail_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '缩略图URL',
`knowledge` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '产品知识库（纯文字）',
`articles_total` int NOT NULL DEFAULT 0 COMMENT '文章总数',
`published_total` int NOT NULL DEFAULT 0 COMMENT '发布总数',
`status` enum('draft','active','deleted') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'draft' COMMENT '状态：draft=草稿，active=正常，deleted=已删除',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_enterprise_id`(`enterprise_id` ASC) USING BTREE,
INDEX `idx_status`(`status` ASC) USING BTREE,
INDEX `idx_enterprise_status`(`enterprise_id` ASC, `status` ASC) USING BTREE,
INDEX `idx_created_at`(`created_at` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '产品信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of ai_products
-- ----------------------------
INSERT INTO `ai_products` VALUES (1, 1, '美白面膜', '护肤品', '', '', '产品名称: 美白面膜\n产品特点: 温和不刺激,适合各种肤质使用\n主要成分: 天然植物萃取,添加多种维生素和矿物质', 1, 0, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_products` VALUES (2, 2, '保湿精华', '护肤品', '', '', '产品名称: 保湿精华\n产品特点: 深层补水,持久保湿\n主要成分: 透明质酸、甘油', 1, 0, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_products` VALUES (3, 3, '防晒霜', '防晒产品', '', '', '产品名称: 防晒霜\n产品特点: SPF50+,防水防汗\n主要成分: 物理防晒+化学防晒', 1, 0, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_products` VALUES (4, 4, '口红套装', '彩妆', '', '', '产品名称: 口红套装\n产品特点: 持久不掉色,滋润显色\n主要成分: 天然蜡质、植物油', 1, 0, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_products` VALUES (5, 5, '洗面奶', '洗护用品', '', '', '产品名称: 洗面奶\n产品特点: 温和清洁,不紧绷\n主要成分: 氨基酸表活', 1, 0, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_products` VALUES (6, 6, '眼霜', '护肤品', '', '', '产品名称: 眼霜\n产品特点: 淡化细纹,紧致眼周\n主要成分: 视黄醇、肽类', 1, 0, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_products` VALUES (7, 7, '粉底液', '彩妆', '', '', '产品名称: 粉底液\n产品特点: 轻薄遮瑕,自然持妆\n主要成分: 二氧化钛、氧化锌', 1, 0, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_products` VALUES (8, 8, '卸妆水', '洗护用品', '', '', '产品名称: 卸妆水\n产品特点: 温和卸妆,不刺激\n主要成分: 胶束水', 1, 0, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_products` VALUES (9, 9, '面部精油', '护肤品', '', '', '产品名称: 面部精油\n产品特点: 修复滋养,改善肤质\n主要成分: 多种植物精油', 1, 0, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_products` VALUES (10, 10, '护手霜', '身体护理', '', '', '产品名称: 护手霜\n产品特点: 滋润保湿,修护手部\n主要成分: 乳木果油、维E', 1, 0, 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_products` VALUES (11, 1, '测试产品', '1', '', '', '这是一个测试产品，用于API测试', 0, 0, 'active', '2025-12-12 17:41:22', '2025-12-12 17:41:22');
INSERT INTO `ai_products` VALUES (12, 1, '测试产品', '1', '', '', '这是一个测试产品，用于API测试', 0, 0, 'active', '2025-12-12 17:41:33', '2025-12-12 17:41:33');
INSERT INTO `ai_products` VALUES (13, 1, '测试产品', '1', '', '', '这是一个测试产品，用于API测试', 11, 0, 'active', '2025-12-12 17:43:30', '2025-12-12 20:53:25');
INSERT INTO `ai_products` VALUES (14, 1, '测试产品', '1', '', '', '更新后的产品知识库', 0, 0, 'deleted', '2025-12-12 17:51:54', '2025-12-12 17:51:54');
INSERT INTO `ai_products` VALUES (15, 1, '测试产品', '1', '', '', '更新后的产品知识库', 0, 0, 'deleted', '2025-12-12 17:57:02', '2025-12-12 17:57:02');
INSERT INTO `ai_products` VALUES (16, 1, '测试产品', '1', '', '', '更新后的产品知识库', 0, 0, 'deleted', '2025-12-12 18:50:34', '2025-12-12 18:50:34');
INSERT INTO `ai_products` VALUES (17, 1, '测试产品', '1', '', '', '更新后的产品知识库', 0, 0, 'deleted', '2025-12-12 18:52:01', '2025-12-12 18:52:01');
INSERT INTO `ai_products` VALUES (18, 1, '测试产品', '1', '', '', '更新后的产品知识库', 0, 0, 'deleted', '2025-12-12 18:52:50', '2025-12-12 18:52:51');
INSERT INTO `ai_products` VALUES (19, 1, '测试产品', '1', '', '', '更新后的产品知识库', 0, 0, 'deleted', '2025-12-12 18:58:42', '2025-12-12 18:58:42');
INSERT INTO `ai_products` VALUES (20, 1, '测试产品', '1', '', '', '更新后的产品知识库', 0, 0, 'deleted', '2025-12-12 18:59:51', '2025-12-12 18:59:52');
INSERT INTO `ai_products` VALUES (21, 1, '测试产品', '1', '', '', '更新后的产品知识库', 0, 0, 'deleted', '2025-12-12 19:00:53', '2025-12-12 19:00:53');
INSERT INTO `ai_products` VALUES (22, 1, '测试产品', '1', '', '', '更新后的产品知识库', 0, 0, 'deleted', '2025-12-12 19:06:20', '2025-12-12 19:06:20');
INSERT INTO `ai_products` VALUES (23, 1, '测试产品', '1', '', '', '更新后的产品知识库', 0, 0, 'deleted', '2025-12-12 19:07:24', '2025-12-12 19:07:24');
-- ----------------------------
-- Table structure for ai_prompt_tags
-- ----------------------------
DROP TABLE IF EXISTS `ai_prompt_tags`;
CREATE TABLE `ai_prompt_tags` (
`id` int NOT NULL AUTO_INCREMENT,
`tag_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'tag名称',
`created_user_id` int NOT NULL DEFAULT 0 COMMENT '创建用户ID',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_tag_name`(`tag_name` ASC) USING BTREE,
INDEX `idx_created_at`(`created_at` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '提示词模板表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of ai_prompt_tags
-- ----------------------------
INSERT INTO `ai_prompt_tags` VALUES (1, '种草', 1, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_tags` VALUES (2, '测评', 2, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_tags` VALUES (3, '教程', 3, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_tags` VALUES (4, '推荐', 4, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_tags` VALUES (5, '分析', 5, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_tags` VALUES (6, '故事', 6, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_tags` VALUES (7, '对比', 7, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_tags` VALUES (8, '解决方案', 8, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_tags` VALUES (9, '季节', 9, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_tags` VALUES (10, '效果', 10, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_tags` VALUES (11, '测试', 1, '2025-12-12 18:50:34', '2025-12-12 18:50:34');
INSERT INTO `ai_prompt_tags` VALUES (12, 'API', 1, '2025-12-12 18:50:34', '2025-12-12 18:50:34');
INSERT INTO `ai_prompt_tags` VALUES (13, 'gggggggggggg', 1, '2025-12-12 20:53:09', '2025-12-12 20:53:09');
-- ----------------------------
-- Table structure for ai_prompt_tags_relation
-- ----------------------------
DROP TABLE IF EXISTS `ai_prompt_tags_relation`;
CREATE TABLE `ai_prompt_tags_relation` (
`id` int NOT NULL AUTO_INCREMENT,
`prompt_workflow_id` int NOT NULL DEFAULT 0 COMMENT '提示词工作流ID',
`prompt_workflow_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '提示词工作流名称',
`tag_id` int NOT NULL DEFAULT 0 COMMENT '标签ID',
`tag_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标签名称',
`created_user_id` int NOT NULL DEFAULT 0 COMMENT '创建用户ID',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_prompt_tag`(`prompt_workflow_id` ASC, `tag_id` ASC) USING BTREE,
INDEX `idx_tag_id`(`tag_id` ASC) USING BTREE,
INDEX `idx_created_at`(`created_at` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_prompt_tags_relation
-- ----------------------------
INSERT INTO `ai_prompt_tags_relation` VALUES (17, 25, 'ggggggg', 13, 'gggggggggggg', 1, '2025-12-12 20:53:09', '2025-12-12 20:53:09');
-- ----------------------------
-- Table structure for ai_prompt_workflow
-- ----------------------------
DROP TABLE IF EXISTS `ai_prompt_workflow`;
CREATE TABLE `ai_prompt_workflow` (
`id` int NOT NULL AUTO_INCREMENT,
`enterprise_id` int NOT NULL DEFAULT 0 COMMENT '所属企业ID',
`prompt_workflow_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '提示词工作流名称',
`auth_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '认证Token',
`workflow_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '工作流ID',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '提示词内容',
`usage_count` int NOT NULL DEFAULT 0 COMMENT '使用次数统计',
`created_user_id` int NOT NULL DEFAULT 0 COMMENT '创建用户ID',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_enterprise_id`(`enterprise_id` ASC) USING BTREE,
INDEX `idx_workflow_id`(`workflow_id` ASC) USING BTREE,
INDEX `idx_created_at`(`created_at` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_prompt_workflow
-- ----------------------------
INSERT INTO `ai_prompt_workflow` VALUES (1, 1, '种草分享型', 'token001', 'WF-001', '你是一个小红书种草达人，请根据产品信息写一篇真实、有感染力的种草笔记...', 0, 1, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_workflow` VALUES (2, 2, '测评体验型', 'token002', 'WF-002', '你是一个产品测评师，请客观详细地描述产品使用体验...', 0, 2, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_workflow` VALUES (3, 3, '干货教程型', 'token003', 'WF-003', '你是一个美妆博主，请分享产品的正确使用方法和技巧...', 0, 3, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_workflow` VALUES (4, 4, '好物推荐型', 'token004', 'WF-004', '你是一个好物推荐官，请推荐这款产品的独特之处...', 0, 4, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_workflow` VALUES (5, 5, '成分分析型', 'token005', 'WF-005', '你是一个成分党，请分析产品的核心成分和功效...', 0, 5, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_workflow` VALUES (6, 6, '场景故事型', 'token006', 'WF-006', '请以故事的形式，讲述产品在特定场景下的使用体验...', 0, 6, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_workflow` VALUES (7, 7, '对比评测型', 'token007', 'WF-007', '请对比同类产品，突出这款产品的优势...', 0, 7, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_workflow` VALUES (8, 8, '问题解决型', 'token008', 'WF-008', '请针对用户的肌肤问题，介绍产品的解决方案...', 0, 8, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_workflow` VALUES (9, 9, '季节推荐型', 'token009', 'WF-009', '请结合季节特点，推荐产品的使用场景...', 0, 9, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_workflow` VALUES (10, 10, '效果展示型', 'token010', 'WF-010', '请详细描述产品的使用效果和前后对比...', 0, 10, '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_prompt_workflow` VALUES (11, 1, '测试提示词', '', 'WF-EFF397D5', '这是一个测试提示词模板...', 0, 0, '2025-12-12 17:14:05', '2025-12-12 17:14:05');
INSERT INTO `ai_prompt_workflow` VALUES (12, 1, '测试提示词', '', 'WF-87B92B31', '这是一个测试提示词模板...', 0, 0, '2025-12-12 17:19:28', '2025-12-12 17:19:28');
INSERT INTO `ai_prompt_workflow` VALUES (13, 1, '测试提示词', '', 'WF-22DC2A4B', '这是一个测试提示词模板...', 0, 0, '2025-12-12 17:31:54', '2025-12-12 17:31:54');
INSERT INTO `ai_prompt_workflow` VALUES (14, 1, '测试提示词', '', 'WF-CC8BB759', '这是一个测试提示词模板...', 2, 0, '2025-12-12 17:41:22', '2025-12-12 17:51:54');
INSERT INTO `ai_prompt_workflow` VALUES (15, 1, '测试提示词', '', 'WF-29EEECD0', '这是一个测试提示词模板...', 2, 0, '2025-12-12 17:51:54', '2025-12-12 17:57:03');
INSERT INTO `ai_prompt_workflow` VALUES (16, 1, '测试提示词', '', 'WF-0C48534A', '这是一个测试提示词模板...', 16, 0, '2025-12-12 17:57:03', '2025-12-12 19:07:25');
INSERT INTO `ai_prompt_workflow` VALUES (25, 1, 'ggggggg', '', 'WF-51A137DE', 'gggggggggggggggggggggg', 1, 0, '2025-12-12 20:53:09', '2025-12-12 20:53:25');
-- ----------------------------
-- Table structure for ai_users
-- ----------------------------
DROP TABLE IF EXISTS `ai_users`;
CREATE TABLE `ai_users` (
`id` int NOT NULL AUTO_INCREMENT,
`enterprise_id` int NOT NULL DEFAULT 0 COMMENT '所属企业ID',
`enterprise_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '企业名称',
`username` varchar(50) 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 '密码',
`real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '真实姓名',
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
`phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号',
`xhs_cookie` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '小红书Cookie',
`xhs_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '小红书绑定手机号',
`xhs_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '小红书账号名称',
`is_bound_xhs` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否绑定小红书：0=未绑定，1=已绑定',
`bound_at` timestamp NULL DEFAULT NULL COMMENT '绑定小红书的时间',
`department` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门',
`role` enum('admin','editor','reviewer','publisher','each_title_reviewer') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'editor' COMMENT '角色',
`status` enum('active','inactive','deleted') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'active' COMMENT '状态',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_username`(`username` ASC) USING BTREE,
INDEX `idx_enterprise_id`(`enterprise_id` ASC) USING BTREE,
INDEX `idx_status`(`status` ASC) USING BTREE,
INDEX `idx_role`(`role` ASC) USING BTREE,
INDEX `idx_is_bound_xhs`(`is_bound_xhs` ASC) USING BTREE,
INDEX `idx_enterprise_status`(`enterprise_id` ASC, `status` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of ai_users
-- ----------------------------
INSERT INTO `ai_users` VALUES (1, 1, '测试企业1号', 'user001', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', '测试用户1', NULL, '13800000001', NULL, '', '小红书用户1', 1, NULL, '产品部', 'editor', 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_users` VALUES (2, 2, '测试企业2号', 'user002', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', '测试用户2', NULL, '13800000002', NULL, '', '小红书用户2', 1, NULL, '运营部', 'reviewer', 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_users` VALUES (3, 3, '测试企业3号', 'user003', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', '测试用户3', NULL, '13800000003', NULL, '', '小红书用户3', 1, NULL, '市场部', 'publisher', 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_users` VALUES (4, 4, '测试企业4号', 'user004', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', '测试用户4', NULL, '13800000004', NULL, '', '小红书用户4', 1, NULL, '技术部', 'each_title_reviewer', 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_users` VALUES (5, 5, '测试企业5号', 'user005', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', '测试用户5', NULL, '13800000005', NULL, '', '小红书用户5', 1, NULL, '产品部', 'editor', 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_users` VALUES (6, 6, '测试企业6号', 'user006', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', '测试用户6', NULL, '13800000006', NULL, '', '', 0, NULL, '运营部', 'reviewer', 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_users` VALUES (7, 7, '测试企业7号', 'user007', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', '测试用户7', NULL, '13800000007', NULL, '', '', 0, NULL, '市场部', 'publisher', 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_users` VALUES (8, 8, '测试企业8号', 'user008', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', '测试用户8', NULL, '13800000008', NULL, '', '', 0, NULL, '技术部', 'each_title_reviewer', 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_users` VALUES (9, 9, '测试企业9号', 'user009', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', '测试用户9', NULL, '13800000009', NULL, '', '', 0, NULL, '产品部', 'editor', 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_users` VALUES (10, 10, '测试企业10号', 'user010', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', '测试用户10', NULL, '13800000010', NULL, '', '', 0, NULL, '运营部', 'reviewer', 'active', '2025-12-12 16:58:22', '2025-12-12 16:58:22');
INSERT INTO `ai_users` VALUES (11, 1, '测试企业1号', '13900000001', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', '测试员工', NULL, '13900000001', NULL, '', '', 0, NULL, '测试部', 'editor', 'active', '2025-12-12 17:41:22', '2025-12-12 17:41:22');
INSERT INTO `ai_users` VALUES (12, 0, '平台', 'platform_admin', 'a665a45920422f9d417e4867efdc4fb8a04a1f3fff1fa07e998e86f7f7a27ae3', '平台管理员', NULL, '13900000000', NULL, '', '', 0, NULL, NULL, 'admin', 'active', '2025-12-12 18:55:20', '2025-12-12 19:00:37');
INSERT INTO `ai_users` VALUES (14, 1, '测试企业1号', '13965537122', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', '测试员工API', NULL, '13965537122', NULL, '', '', 0, NULL, '测试部', 'editor', 'deleted', '2025-12-12 18:58:42', '2025-12-12 20:51:10');
INSERT INTO `ai_users` VALUES (15, 1, '测试企业1号', '13965537191', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', '测试员工API', NULL, '13965537191', NULL, '', '', 0, NULL, '测试部', 'editor', 'deleted', '2025-12-12 18:59:51', '2025-12-12 18:59:51');
INSERT INTO `ai_users` VALUES (16, 1, '测试企业1号', '13965537253', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', '测试员工API', NULL, '13965537253', NULL, '', '', 0, NULL, '测试部', 'editor', 'deleted', '2025-12-12 19:00:53', '2025-12-12 19:00:53');
INSERT INTO `ai_users` VALUES (17, 1, '测试企业1号', '13965537579', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', '测试员工API', NULL, '13965537579', NULL, '', '', 0, NULL, '测试部', 'editor', 'deleted', '2025-12-12 19:06:19', '2025-12-12 19:06:20');
INSERT INTO `ai_users` VALUES (18, 1, '测试企业1号', '13965537644', '256dfd66db93b7ce0d1e260b01971dffaafa1dadca903ed16defc4fba24be83b', '测试员工API', NULL, '13965537644', NULL, '', '', 0, NULL, '测试部', 'editor', 'deleted', '2025-12-12 19:07:24', '2025-12-12 19:07:24');
SET FOREIGN_KEY_CHECKS = 1;
Reference in New Issue View Git Blame Copy Permalink