From 4f4e5d74b8b254028803bf295bcd96328a15d72c Mon Sep 17 00:00:00 2001 From: zhangjinyang <409225776@qq.com> Date: 星期三, 09 四月 2025 18:20:43 +0800 Subject: [PATCH] init --- sql/aiflowy.ddl.sql | 504 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 504 insertions(+), 0 deletions(-) diff --git a/sql/aiflowy.ddl.sql b/sql/aiflowy.ddl.sql index e69de29..6644f56 100644 --- a/sql/aiflowy.ddl.sql +++ b/sql/aiflowy.ddl.sql @@ -0,0 +1,504 @@ +SET NAMES utf8mb4; +SET FOREIGN_KEY_CHECKS = 0; + +-- ---------------------------- +-- Table structure for tb_ai_bot +-- ---------------------------- +DROP TABLE IF EXISTS `tb_ai_bot`; +CREATE TABLE `tb_ai_bot` ( + `id` bigint UNSIGNED NOT NULL COMMENT '涓婚敭ID', + `dept_id` bigint UNSIGNED NOT NULL COMMENT '閮ㄩ棬ID', + `tenant_id` bigint UNSIGNED NOT NULL COMMENT '绉熸埛ID', + `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏍囬', + `description` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎻忚堪', + `icon` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍥炬爣', + `llm_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT 'LLM ID', + `llm_options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT 'LLM閫夐」', + `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '閫夐」', + `created` datetime NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', + `created_by` bigint UNSIGNED NULL DEFAULT NULL COMMENT '鍒涘缓鑰匢D', + `modified` datetime NULL DEFAULT NULL COMMENT '淇敼鏃堕棿', + `modified_by` bigint UNSIGNED NULL DEFAULT NULL COMMENT '淇敼鑰匢D', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; + + +-- ---------------------------- +-- Table structure for tb_ai_bot_knowledge +-- ---------------------------- +DROP TABLE IF EXISTS `tb_ai_bot_knowledge`; +CREATE TABLE `tb_ai_bot_knowledge` ( + `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, + `bot_id` bigint UNSIGNED NULL DEFAULT NULL, + `knowledge_id` bigint UNSIGNED NULL DEFAULT NULL, + `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_ai_bot_llm +-- ---------------------------- +DROP TABLE IF EXISTS `tb_ai_bot_llm`; +CREATE TABLE `tb_ai_bot_llm` ( + `id` bigint UNSIGNED NOT NULL, + `bot_id` bigint UNSIGNED NULL DEFAULT NULL, + `llm_id` bigint UNSIGNED NULL DEFAULT NULL, + `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_ai_bot_message +-- ---------------------------- +DROP TABLE IF EXISTS `tb_ai_bot_message`; +CREATE TABLE `tb_ai_bot_message` ( + `id` bigint UNSIGNED NOT NULL, + `bot_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT 'Bot ID', + `account_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '鍏宠仈鐨勮处鎴稩D', + `session_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍥炶瘽ID', + `role` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, + `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, + `image` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, + `prompt_tokens` int NULL DEFAULT NULL, + `completion_tokens` int NULL DEFAULT NULL, + `total_tokens` int NULL DEFAULT NULL, + `functions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鏂规硶瀹氫箟', + `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, + `created` datetime NULL DEFAULT NULL, + `modified` datetime NULL DEFAULT NULL, + PRIMARY KEY (`id`) USING BTREE, + INDEX `bot_id`(`bot_id`) USING BTREE, + INDEX `account_id`(`account_id`) USING BTREE, + INDEX `session_id`(`session_id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'Bot 娑堟伅璁板綍琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_ai_bot_plugins +-- ---------------------------- +DROP TABLE IF EXISTS `tb_ai_bot_plugins`; +CREATE TABLE `tb_ai_bot_plugins` ( + `id` bigint UNSIGNED NOT NULL, + `bot_id` bigint UNSIGNED NULL DEFAULT NULL, + `plugin_id` bigint UNSIGNED NULL DEFAULT NULL, + `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_ai_bot_workflow +-- ---------------------------- +DROP TABLE IF EXISTS `tb_ai_bot_workflow`; +CREATE TABLE `tb_ai_bot_workflow` ( + `id` bigint UNSIGNED NOT NULL, + `bot_id` bigint UNSIGNED NULL DEFAULT NULL, + `workflow_id` bigint UNSIGNED NULL DEFAULT NULL, + `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_ai_chat_message +-- ---------------------------- +DROP TABLE IF EXISTS `tb_ai_chat_message`; +CREATE TABLE `tb_ai_chat_message` ( + `id` bigint UNSIGNED NOT NULL, + `topic_id` bigint UNSIGNED NULL DEFAULT NULL, + `role` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, + `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, + `image` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, + `prompt_tokens` int NULL DEFAULT NULL, + `completion_tokens` int NULL DEFAULT NULL, + `total_tokens` int NULL DEFAULT NULL, + `tools` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, + `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, + `created` datetime NULL DEFAULT NULL, + `modified` datetime NULL DEFAULT NULL, + PRIMARY KEY (`id`) USING BTREE, + INDEX `topic_id`(`topic_id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'AI 娑堟伅璁板綍琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_ai_chat_topic +-- ---------------------------- +DROP TABLE IF EXISTS `tb_ai_chat_topic`; +CREATE TABLE `tb_ai_chat_topic` ( + `id` bigint UNSIGNED NOT NULL, + `account_id` bigint UNSIGNED NULL DEFAULT NULL, + `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, + `created` datetime NULL DEFAULT NULL, + `modified` datetime NULL DEFAULT NULL, + PRIMARY KEY (`id`) USING BTREE, + INDEX `account_id`(`account_id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'AI 璇濋琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_ai_document +-- ---------------------------- +DROP TABLE IF EXISTS `tb_ai_document`; +CREATE TABLE `tb_ai_document` ( + `id` bigint UNSIGNED NOT NULL, + `knowledge_id` bigint UNSIGNED NOT NULL COMMENT '鐭ヨ瘑搴揑D', + `document_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏂囨。绫诲瀷 pdf/word/aieditor 绛�', + `document_path` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏂囨。璺緞', + `title` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏍囬', + `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鍐呭', + `content_type` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍐呭绫诲瀷', + `slug` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'URL 鍒悕', + `order_no` int NULL DEFAULT NULL COMMENT '鎺掑簭搴忓彿', + `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鍏朵粬閰嶇疆椤�', + `created` datetime NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', + `created_by` bigint NULL DEFAULT NULL COMMENT '鍒涘缓浜篒D', + `modified` datetime NULL DEFAULT NULL COMMENT '鏈�鍚庣殑淇敼鏃堕棿', + `modified_by` bigint NULL DEFAULT NULL COMMENT '鏈�鍚庣殑淇敼浜虹殑ID', + PRIMARY KEY (`id`) USING BTREE, + INDEX `knowledge_id`(`knowledge_id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鏂囨。' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_ai_document_chunk +-- ---------------------------- +DROP TABLE IF EXISTS `tb_ai_document_chunk`; +CREATE TABLE `tb_ai_document_chunk` ( + `id` bigint UNSIGNED NOT NULL, + `document_id` bigint UNSIGNED NOT NULL COMMENT '鏂囨。ID', + `knowledge_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '鐭ヨ瘑搴揑D', + `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鍒嗗潡鍐呭', + `sorting` int UNSIGNED NULL DEFAULT NULL COMMENT '鍒嗗壊椤哄簭', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_ai_document_history +-- ---------------------------- +DROP TABLE IF EXISTS `tb_ai_document_history`; +CREATE TABLE `tb_ai_document_history` ( + `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, + `document_id` bigint NULL DEFAULT NULL COMMENT '淇敼鐨勬枃妗D', + `old_title` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏃ф爣棰�', + `new_title` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏂版爣棰�', + `old_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鏃у唴瀹�', + `new_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鏂板唴瀹�', + `old_document_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏃х殑鏂囨。绫诲瀷', + `new_document_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏂扮殑棰濇枃妗ｇ被鍨�', + `created` datetime NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', + `created_by` bigint NULL DEFAULT NULL COMMENT '鍒涘缓浜篒D', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; + + +-- ---------------------------- +-- Table structure for tb_ai_knowledge +-- ---------------------------- +DROP TABLE IF EXISTS `tb_ai_knowledge`; +CREATE TABLE `tb_ai_knowledge` ( + `id` bigint UNSIGNED NOT NULL, + `dept_id` bigint UNSIGNED NOT NULL COMMENT '閮ㄩ棬ID', + `tenant_id` bigint UNSIGNED NOT NULL COMMENT '绉熸埛ID', + `icon` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'ICON', + `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏍囬', + `description` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎻忚堪', + `slug` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'URL 鍒悕', + `vector_store_enable` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鍚敤鍚戦噺瀛樺偍', + `vector_store_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍚戦噺鏁版嵁搴撶被鍨�', + `vector_store_collection` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍚戦噺鏁版嵁搴撻泦鍚�', + `vector_store_config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鍚戦噺鏁版嵁搴撻厤缃�', + `vector_embed_llm_id` bigint NULL DEFAULT NULL COMMENT 'Embedding 妯″瀷ID', + `created` datetime NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', + `created_by` bigint UNSIGNED NULL DEFAULT NULL COMMENT '鍒涘缓鐢ㄦ埛ID', + `modified` datetime NULL DEFAULT NULL COMMENT '鏈�鍚庝竴娆′慨鏀规椂闂�', + `modified_by` bigint UNSIGNED NULL DEFAULT NULL COMMENT '鏈�鍚庝竴娆′慨鏀圭敤鎴稩D', + `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鍏朵粬閰嶇疆', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐭ヨ瘑搴�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_ai_llm +-- ---------------------------- +DROP TABLE IF EXISTS `tb_ai_llm`; +CREATE TABLE `tb_ai_llm` ( + `id` bigint UNSIGNED NOT NULL, + `dept_id` bigint UNSIGNED NOT NULL COMMENT '閮ㄩ棬ID', + `tenant_id` bigint UNSIGNED NOT NULL COMMENT '绉熸埛ID', + `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏍囬鎴栧悕绉�', + `brand` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍝佺墝', + `icon` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'ICON', + `description` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎻忚堪', + `support_chat` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔瀵硅瘽', + `support_function_calling` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔鏂规硶璋冪敤', + `support_embed` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔鍚戦噺鍖�', + `support_reranker` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔閲嶆帓', + `support_text_to_image` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔鏂囧瓧鐢熸垚鍥剧墖', + `support_image_to_image` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔鍥剧墖鐢熸垚鍥剧墖', + `support_text_to_audio` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔鏂囧瓧鐢熸垚璇煶', + `support_audio_to_audio` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔璇煶鐢熸垚璇煶', + `support_text_to_video` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔鏂囧瓧鐢熸垚瑙嗛', + `support_image_to_video` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔鍥剧墖鐢熸垚瑙嗛', + `llm_endpoint` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶фā鍨嬭姹傚湴鍧�', + `llm_model` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶фā鍨嬪悕绉�', + `llm_api_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶фā鍨� API KEY', + `llm_extra_config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '澶фā鍨嬪叾浠栧睘鎬ч厤缃�', + `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鍏朵粬閰嶇疆鍐呭', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_ai_plugins +-- ---------------------------- +DROP TABLE IF EXISTS `tb_ai_plugins`; +CREATE TABLE `tb_ai_plugins` ( + `id` bigint UNSIGNED NOT NULL COMMENT '涓婚敭', + `dept_id` bigint UNSIGNED NOT NULL COMMENT '閮ㄩ棬ID', + `tenant_id` bigint UNSIGNED NOT NULL COMMENT '绉熸埛ID', + `plugin_type` tinyint NOT NULL DEFAULT 1 COMMENT '鎻掍欢绫诲瀷', + `plugin_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鎻掍欢鍚嶇О', + `plugin_desc` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鎻掍欢鎻忚堪', + `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鎻掍欢閰嶇疆', + `status` tinyint NOT NULL DEFAULT 0 COMMENT '鏁版嵁鐘舵��', + `created` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿', + `created_by` bigint UNSIGNED NOT NULL COMMENT '鍒涘缓鑰�', + `modified` datetime NOT NULL COMMENT '淇敼鏃堕棿', + `modified_by` bigint UNSIGNED NOT NULL COMMENT '淇敼鑰�', + `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '澶囨敞', + `is_deleted` tinyint NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囪瘑', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鎻掍欢' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_ai_workflow +-- ---------------------------- +DROP TABLE IF EXISTS `tb_ai_workflow`; +CREATE TABLE `tb_ai_workflow` ( + `id` bigint UNSIGNED NOT NULL COMMENT 'ID 涓婚敭', + `dept_id` bigint UNSIGNED NOT NULL COMMENT '閮ㄩ棬ID', + `tenant_id` bigint UNSIGNED NOT NULL COMMENT '绉熸埛ID', + `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏍囬', + `description` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎻忚堪', + `icon` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'ICON', + `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '宸ヤ綔娴佽璁＄殑 JSON 鍐呭', + `created` datetime NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', + `created_by` bigint UNSIGNED NULL DEFAULT NULL COMMENT '鍒涘缓浜�', + `modified` datetime NULL DEFAULT NULL COMMENT '鏈�鍚庝慨鏀规椂闂�', + `modified_by` bigint UNSIGNED NULL DEFAULT NULL COMMENT '鏈�鍚庝慨鏀圭殑浜�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_sys_account +-- ---------------------------- +DROP TABLE IF EXISTS `tb_sys_account`; +CREATE TABLE `tb_sys_account` ( + `id` bigint UNSIGNED NOT NULL COMMENT '涓婚敭', + `dept_id` bigint UNSIGNED NOT NULL COMMENT '閮ㄩ棬ID', + `tenant_id` bigint UNSIGNED NOT NULL COMMENT '绉熸埛ID', + `login_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鐧诲綍璐﹀彿', + `password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '瀵嗙爜', + `account_type` tinyint NOT NULL DEFAULT 0 COMMENT '璐︽埛绫诲瀷', + `nickname` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '鏄电О', + `mobile` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '鎵嬫満鐢佃瘽', + `email` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '閭欢', + `avatar` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '璐︽埛澶村儚', + `data_scope` int NULL DEFAULT 1 COMMENT '鏁版嵁鏉冮檺绫诲瀷', + `dept_id_list` json NULL COMMENT '鑷畾涔夐儴闂ㄦ潈闄�', + `status` tinyint NOT NULL DEFAULT 0 COMMENT '鏁版嵁鐘舵��', + `created` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿', + `created_by` bigint UNSIGNED NOT NULL COMMENT '鍒涘缓鑰�', + `modified` datetime NOT NULL COMMENT '淇敼鏃堕棿', + `modified_by` bigint UNSIGNED NOT NULL COMMENT '淇敼鑰�', + `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '澶囨敞', + `is_deleted` tinyint NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囪瘑', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `uni_login_name`(`login_name`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐢ㄦ埛琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_sys_account_position +-- ---------------------------- +DROP TABLE IF EXISTS `tb_sys_account_position`; +CREATE TABLE `tb_sys_account_position` ( + `id` bigint UNSIGNED NOT NULL COMMENT '涓婚敭', + `account_id` bigint UNSIGNED NOT NULL COMMENT '鐢ㄦ埛ID', + `position_id` bigint UNSIGNED NOT NULL COMMENT '鑱屼綅ID', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐢ㄦ埛-鑱屼綅琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_sys_account_role +-- ---------------------------- +DROP TABLE IF EXISTS `tb_sys_account_role`; +CREATE TABLE `tb_sys_account_role` ( + `id` bigint UNSIGNED NOT NULL COMMENT '涓婚敭', + `account_id` bigint UNSIGNED NOT NULL COMMENT '鐢ㄦ埛ID', + `role_id` bigint UNSIGNED NOT NULL COMMENT '瑙掕壊ID', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐢ㄦ埛-瑙掕壊琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_sys_dept +-- ---------------------------- +DROP TABLE IF EXISTS `tb_sys_dept`; +CREATE TABLE `tb_sys_dept` ( + `id` bigint UNSIGNED NOT NULL COMMENT '涓婚敭', + `tenant_id` bigint UNSIGNED NOT NULL COMMENT '绉熸埛ID', + `parent_id` bigint UNSIGNED NOT NULL COMMENT '鐖剁骇ID', + `ancestors` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '鐖剁骇閮ㄩ棬ID闆嗗悎', + `dept_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '閮ㄩ棬鍚嶇О', + `dept_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '閮ㄩ棬缂栫爜', + `sort_no` int NULL DEFAULT 0 COMMENT '鎺掑簭', + `status` tinyint NOT NULL DEFAULT 0 COMMENT '鏁版嵁鐘舵��', + `created` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿', + `created_by` bigint UNSIGNED NOT NULL COMMENT '鍒涘缓鑰�', + `modified` datetime NOT NULL COMMENT '淇敼鏃堕棿', + `modified_by` bigint UNSIGNED NOT NULL COMMENT '淇敼鑰�', + `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '澶囨敞', + `is_deleted` tinyint NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囪瘑', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '閮ㄩ棬琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_sys_dict +-- ---------------------------- +DROP TABLE IF EXISTS `tb_sys_dict`; +CREATE TABLE `tb_sys_dict` ( + `id` bigint UNSIGNED NOT NULL COMMENT '涓婚敭', + `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏁版嵁瀛楀吀鍚嶇О', + `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '瀛楀吀缂栫爜', + `description` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '瀛楀吀鎻忚堪鎴栧娉�', + `dict_type` tinyint NULL DEFAULT NULL COMMENT '瀛楀吀绫诲瀷 1 鑷畾涔夊瓧鍏搞��2 鏁版嵁琛ㄥ瓧鍏搞�� 3 鏋氫妇绫诲瓧鍏搞�� 4 绯荤粺瀛楀吀锛堣嚜瀹氫箟 DictLoader锛�', + `sort_no` int NULL DEFAULT NULL COMMENT '鎺掑簭缂栧彿', + `status` tinyint NULL DEFAULT NULL COMMENT '鏄惁鍚敤', + `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鎵╁睍瀛楀吀 瀛樻斁 json', + `created` datetime NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', + `modified` datetime NULL DEFAULT NULL COMMENT '淇敼鏃堕棿', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `key`(`code`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '绯荤粺瀛楀吀琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for tb_sys_dict_item +-- ---------------------------- +DROP TABLE IF EXISTS `tb_sys_dict_item`; +CREATE TABLE `tb_sys_dict_item` ( + `id` bigint UNSIGNED NOT NULL COMMENT '涓婚敭', + `dict_id` bigint UNSIGNED NOT NULL COMMENT '褰掑睘鍝釜瀛楀吀', + `text` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '鍚嶇О鎴栧唴瀹�', + `value` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '鍊�', + `description` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎻忚堪', + `sort_no` int NOT NULL DEFAULT 0 COMMENT '鎺掑簭', + `css_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT 'css鏍峰紡鍐呭', + `css_class` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'css鏍峰紡绫诲悕', + `remark` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞', + `status` tinyint NULL DEFAULT 0 COMMENT '鐘舵��', + `created` datetime NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', + `modified` datetime NULL DEFAULT NULL COMMENT '淇敼鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鏁版嵁瀛楀吀鍐呭' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_sys_log +-- ---------------------------- +DROP TABLE IF EXISTS `tb_sys_log`; +CREATE TABLE `tb_sys_log` ( + `id` bigint UNSIGNED NOT NULL, + `account_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '鎿嶄綔浜�', + `action_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎿嶄綔鍚嶇О', + `action_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎿嶄綔鐨勭被鍨�', + `action_class` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎿嶄綔娑夊強鐨勭被', + `action_method` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎿嶄綔娑夊強鐨勬柟娉�', + `action_url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎿嶄綔娑夊強鐨� URL 鍦板潃', + `action_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎿嶄綔娑夊強鐨勭敤鎴� IP 鍦板潃', + `action_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鎿嶄綔璇锋眰鍙傛暟', + `action_body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鎿嶄綔璇锋眰body', + `status` tinyint NULL DEFAULT NULL COMMENT '鎿嶄綔鐘舵�� 1 鎴愬姛 9 澶辫触', + `created` datetime NULL DEFAULT NULL COMMENT '鎿嶄綔鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鎿嶄綔鏃ュ織琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_sys_menu +-- ---------------------------- +DROP TABLE IF EXISTS `tb_sys_menu`; +CREATE TABLE `tb_sys_menu` ( + `id` bigint UNSIGNED NOT NULL COMMENT '涓婚敭', + `parent_id` bigint UNSIGNED NOT NULL COMMENT '鐖惰彍鍗昳d', + `menu_type` int NOT NULL COMMENT '鑿滃崟绫诲瀷', + `menu_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鑿滃崟鏍囬', + `menu_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '鑿滃崟url', + `component` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '缁勪欢璺緞', + `menu_icon` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '鍥炬爣/鍥剧墖鍦板潃', + `is_show` int NOT NULL DEFAULT 1 COMMENT '鏄惁鏄剧ず', + `permission_tag` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '鏉冮檺鏍囪瘑', + `sort_no` int NULL DEFAULT 0 COMMENT '鎺掑簭', + `status` tinyint NOT NULL DEFAULT 0 COMMENT '鏁版嵁鐘舵��', + `created` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿', + `created_by` bigint UNSIGNED NOT NULL COMMENT '鍒涘缓鑰�', + `modified` datetime NOT NULL COMMENT '淇敼鏃堕棿', + `modified_by` bigint UNSIGNED NOT NULL COMMENT '淇敼鑰�', + `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '澶囨敞', + `is_deleted` tinyint NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囪瘑', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鑿滃崟琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_sys_option +-- ---------------------------- +DROP TABLE IF EXISTS `tb_sys_option`; +CREATE TABLE `tb_sys_option` ( + `tenant_id` bigint UNSIGNED NOT NULL COMMENT '绉熸埛ID', + `key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '閰嶇疆KEY', + `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '閰嶇疆鍐呭', + INDEX `uni_key`(`tenant_id`, `key`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '绯荤粺閰嶇疆淇℃伅琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for tb_sys_position +-- ---------------------------- +DROP TABLE IF EXISTS `tb_sys_position`; +CREATE TABLE `tb_sys_position` ( + `id` bigint UNSIGNED NOT NULL COMMENT '涓婚敭', + `tenant_id` bigint UNSIGNED NOT NULL COMMENT '绉熸埛ID', + `dept_id` bigint UNSIGNED NOT NULL COMMENT '閮ㄩ棬ID', + `position_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '宀椾綅鍚嶇О', + `position_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '宀椾綅缂栫爜', + `sort_no` int NULL DEFAULT 0 COMMENT '鎺掑簭', + `status` tinyint NOT NULL DEFAULT 0 COMMENT '鏁版嵁鐘舵��', + `created` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿', + `created_by` bigint UNSIGNED NOT NULL COMMENT '鍒涘缓鑰�', + `modified` datetime NOT NULL COMMENT '淇敼鏃堕棿', + `modified_by` bigint UNSIGNED NOT NULL COMMENT '淇敼鑰�', + `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '澶囨敞', + `is_deleted` tinyint NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囪瘑', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鑱屼綅琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_sys_role +-- ---------------------------- +DROP TABLE IF EXISTS `tb_sys_role`; +CREATE TABLE `tb_sys_role` ( + `id` bigint UNSIGNED NOT NULL COMMENT '涓婚敭', + `tenant_id` bigint UNSIGNED NOT NULL COMMENT '绉熸埛ID', + `role_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '瑙掕壊鍚嶇О', + `role_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '瑙掕壊鏍囪瘑', + `status` tinyint NOT NULL DEFAULT 0 COMMENT '鏁版嵁鐘舵��', + `created` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿', + `created_by` bigint UNSIGNED NOT NULL COMMENT '鍒涘缓鑰�', + `modified` datetime NOT NULL COMMENT '淇敼鏃堕棿', + `modified_by` bigint UNSIGNED NOT NULL COMMENT '淇敼鑰�', + `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '澶囨敞', + `is_deleted` tinyint NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囪瘑', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `uni_tenant_role`(`tenant_id`, `role_key`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '绯荤粺瑙掕壊' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for tb_sys_role_menu +-- ---------------------------- +DROP TABLE IF EXISTS `tb_sys_role_menu`; +CREATE TABLE `tb_sys_role_menu` ( + `id` bigint UNSIGNED NOT NULL COMMENT '涓婚敭', + `role_id` bigint UNSIGNED NOT NULL COMMENT '瑙掕壊ID', + `menu_id` bigint UNSIGNED NOT NULL COMMENT '鑿滃崟ID', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '瑙掕壊-鑿滃崟琛�' ROW_FORMAT = Dynamic; + +SET FOREIGN_KEY_CHECKS = 1; -- Gitblit v1.8.0