aiChat/resource/aiChat.sql

CREATE TABLE `ai_message_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '内容',
  `type` tinyint(4) NOT NULL COMMENT '类型 1：用户提问 2：智能助手回复',
  `useful` tinyint(4) DEFAULT NULL COMMENT '-1：无用 1：有用',
  `item` tinyint(4) NOT NULL COMMENT '1：常见问题 2：业务意图 3：chatgpt',
  `refer` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '会话来源地址',
  `person_id` int(11) NOT NULL COMMENT '自然人id',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=100001 COMMENT='aichat聊天记录';

CREATE TABLE `ai_question_list` (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '问题表id',
    `status` tinyint(4) DEFAULT '1' COMMENT '状态：0：无效 1：有效',
    `question` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '问题',
    `source` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'index：网站首页 detail：三级页 workDesk：工作桌面首页 ',
    `question_type` tinyint(4) DEFAULT '1' COMMENT '1：猜你想问 2：常见问题',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `update_time` datetime DEFAULT NULL,
    PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=30001 COMMENT='常见问题列表';


CREATE TABLE `ai_question` (
   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '问题表id',
   `ai_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'actionCode',
   `question` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '问题',
   `answer` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '答案内容',
   `status` tinyint(4) DEFAULT '1' COMMENT '状态：0：无效 1：有效',
   `source` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'index：网站首页 detail：三级页 workDesk：工作桌面首页 ',
   `joggle` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'rpc业务接口地址',
   `auto_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '默认url',
   `isbusiness` tinyint(4) DEFAULT '0' COMMENT '是否业务企图：0：否 1：是',
   `check_member` int(11) DEFAULT '0' COMMENT '是否校验大会员权限:0：否 1：是',
   `service_id` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '大会员功能服务id 多个都好拼接',
   `noperm` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '无权限回复',
   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
   `update_time` datetime DEFAULT NULL,
   PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=30001;