docs/sql/init.sql · 长路/AgentX

代码拉取完成,页面将自动刷新

扫描微信二维码支付

取消

支付完成

richgiteeai

Watch

不关注关注所有动态仅关注版本发行动态关注但不提醒动态

1 Star 0 Fork 0

长路/AgentX

代码 Issues 0 Pull Requests 0 Wiki 统计流水线

服务

加入 Gitee

与超过 1400万开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)

免费加入

已有帐号? 立即登录

文件

master

分支 (31)

管理

master

2025年05月31日-feat/chat-multimodal

2025年05月28日/interrupt

2025年05月26日-feat/agent-schedule

fix/commit

2025年05月29日-feat/chat-preview

2025年05月21日-feat/tool-llm

xhyqaq-patch-1

2025年05月10日-feat/plguin-tools

2025年04月30日-feat/user

develop

2025年04月30日-feat/user-dev

test

2025年04月20日-feat/llm-service-agent-4

2025年04月06日-feat/llm-service-agent

2025年04月10日-feat/rag-检索逻辑

2025年04月01日-feat/llm-service-chat

2025年04月10日-feat/rag

2025年04月18日-feat/llm-service-agent-3

2025年04月06日-feat/llm-service-agent-2

该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。

项目仓库所选许可证以仓库主分支所使用许可证为准

克隆/下载

HTTPS SSH SVN SVN+SSH 下载ZIP

提示

下载代码请复制以下命令到终端执行

为确保你提交的代码身份被 Gitee 正确识别,请执行以下命令完成配置

git config --global user.name userName 
git config --global user.email userEmail

初次使用 SSH 协议进行代码克隆、推送等操作时,需按下述提示完成 SSH 配置

1 生成 RSA 密钥

2 获取 RSA 公钥内容,并配置到 SSH公钥中

在 Gitee 上使用 SVN,请访问使用指南

使用 HTTPS 协议时,命令行会出现如下账号密码验证步骤。基于安全考虑,Gitee 建议配置并使用私人令牌替代登录密码进行克隆、推送等操作

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # 私人令牌

分支 31

标签 0

AgentX

docs

sql

init.sql

init.sql 21.20 KB

-- AgentX初始化数据库脚本 - PostgreSQL版本

-- 会话表,存储用户与Agent的对话会话
CREATE TABLE sessions (
 id VARCHAR(36) PRIMARY KEY,
 title VARCHAR(255) NOT NULL,
 user_id VARCHAR(36) NOT NULL,
 agent_id VARCHAR(36),
 description TEXT,
 is_archived BOOLEAN DEFAULT FALSE,
 metadata JSONB,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 消息表,存储会话中的所有消息
CREATE TABLE messages (
 id VARCHAR(36) PRIMARY KEY,
 session_id VARCHAR(36) NOT NULL,
 role VARCHAR(20) NOT NULL,
 content TEXT NOT NULL,
 message_type VARCHAR(20) NOT NULL DEFAULT 'TEXT',
 token_count INTEGER DEFAULT 0,
 provider VARCHAR(50),
 model VARCHAR(50),
 metadata JSONB,
 file_urls JSONB,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 上下文表,管理对话上下文
CREATE TABLE context (
 id VARCHAR(36) PRIMARY KEY,
 session_id VARCHAR(36) NOT NULL,
 active_messages JSONB,
 summary TEXT,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- Agent 相关表结构
CREATE TABLE agents (
 id VARCHAR(36) PRIMARY KEY,
 name VARCHAR(255) NOT NULL,
 avatar VARCHAR(255),
 description TEXT,
 system_prompt TEXT,
 welcome_message TEXT,
 tool_ids JSONB,
 published_version VARCHAR(36),
 enabled BOOLEAN DEFAULT TRUE,
 agent_type INTEGER DEFAULT 1,
 user_id VARCHAR(36) NOT NULL,
 tool_preset_params JSONB,
 multi_modal BOOLEAN DEFAULT FALSE,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- Agent版本表
CREATE TABLE agent_versions (
 id VARCHAR(36) PRIMARY KEY,
 agent_id VARCHAR(36) NOT NULL,
 name VARCHAR(255) NOT NULL,
 avatar VARCHAR(255),
 description TEXT,
 version_number VARCHAR(20) NOT NULL,
 system_prompt TEXT,
 welcome_message TEXT,
 tool_ids JSONB,
 knowledge_base_ids JSONB,
 change_log TEXT,
 agent_type INTEGER DEFAULT 1,
 publish_status INTEGER DEFAULT 1,
 reject_reason TEXT,
 review_time TIMESTAMP,
 published_at TIMESTAMP,
 user_id VARCHAR(36) NOT NULL,
 tool_preset_params JSONB,
 multi_modal BOOLEAN DEFAULT FALSE,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- Agent工作区表
CREATE TABLE agent_workspace (
 id VARCHAR(36) PRIMARY KEY,
 agent_id VARCHAR(36) NOT NULL,
 user_id VARCHAR(36) NOT NULL,
 llm_model_config JSONB,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 服务提供商表
CREATE TABLE providers (
 id VARCHAR(36) PRIMARY KEY,
 user_id VARCHAR(36),
 protocol VARCHAR(50) NOT NULL,
 name VARCHAR(100) NOT NULL,
 description TEXT,
 config TEXT,
 is_official BOOLEAN DEFAULT FALSE,
 status BOOLEAN DEFAULT TRUE,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 模型表
CREATE TABLE models (
 id VARCHAR(36) PRIMARY KEY,
 user_id VARCHAR(36),
 provider_id VARCHAR(36) NOT NULL,
 model_id VARCHAR(100) NOT NULL,
 name VARCHAR(100) NOT NULL,
 description TEXT,
 is_official BOOLEAN DEFAULT FALSE,
 type VARCHAR(20) NOT NULL,
 status BOOLEAN DEFAULT TRUE,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 任务表
CREATE TABLE agent_tasks (
 id VARCHAR(36) PRIMARY KEY,
 session_id VARCHAR(36) NOT NULL,
 user_id VARCHAR(36) NOT NULL,
 parent_task_id VARCHAR(36),
 task_name VARCHAR(255) NOT NULL,
 description TEXT,
 status VARCHAR(20),
 progress INTEGER DEFAULT 0,
 start_time TIMESTAMP,
 end_time TIMESTAMP,
 task_result TEXT,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 定时任务表
CREATE TABLE scheduled_tasks (
 id VARCHAR(36) PRIMARY KEY,
 user_id VARCHAR(36) NOT NULL,
 agent_id VARCHAR(36) NOT NULL,
 session_id VARCHAR(36) NOT NULL,
 content TEXT NOT NULL,
 repeat_type VARCHAR(20) NOT NULL,
 repeat_config JSONB,
 status VARCHAR(20) DEFAULT 'ACTIVE',
 last_execute_time TIMESTAMP,
 next_execute_time TIMESTAMP,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

CREATE TABLE users (
 id varchar(36) PRIMARY KEY,
 nickname varchar(255) NOT NULL,
 email varchar(255),
 phone varchar(11),
 password varchar NOT NULL,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP,
 github_id varchar(255),
 github_login varchar(255),
 avatar_url varchar(255)
);

-- 工具相关表

-- 工具表
CREATE TABLE tools (
 id VARCHAR(36) PRIMARY KEY,
 name VARCHAR(255) NOT NULL,
 icon VARCHAR(255),
 subtitle VARCHAR(255),
 description TEXT,
 user_id VARCHAR(36) NOT NULL,
 labels JSONB,
 tool_type VARCHAR(50) NOT NULL,
 upload_type VARCHAR(20) NOT NULL,
 upload_url VARCHAR(255),
 install_command JSONB,
 tool_list JSONB,
 reject_reason TEXT,
 failed_step_status VARCHAR(20),
 mcp_server_name VARCHAR(255),
 status VARCHAR(20) NOT NULL,
 is_office BOOLEAN DEFAULT FALSE,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 工具版本表
CREATE TABLE tool_versions (
 id VARCHAR(36) PRIMARY KEY,
 name VARCHAR(255) NOT NULL,
 icon VARCHAR(255),
 subtitle VARCHAR(255),
 description TEXT,
 user_id VARCHAR(36) NOT NULL,
 version VARCHAR(50) NOT NULL,
 tool_id VARCHAR(36) NOT NULL,
 upload_type VARCHAR(20) NOT NULL,
 change_log TEXT,
 upload_url VARCHAR(255),
 tool_list JSONB,
 labels JSONB,
 mcp_server_name VARCHAR(255),
 is_office BOOLEAN DEFAULT FALSE,
 public_status BOOLEAN DEFAULT FALSE,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 用户工具关联表
CREATE TABLE user_tools (
 id VARCHAR(36) PRIMARY KEY,
 user_id VARCHAR(36) NOT NULL,
 name VARCHAR(255) NOT NULL,
 description TEXT,
 icon VARCHAR(255),
 subtitle VARCHAR(255),
 tool_id VARCHAR(36) NOT NULL,
 version VARCHAR(50) NOT NULL,
 tool_list JSONB,
 labels JSONB,
 is_office BOOLEAN DEFAULT FALSE,
 public_state BOOLEAN DEFAULT FALSE,
 mcp_server_name VARCHAR(255),
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 用户设置表
CREATE TABLE user_settings (
 id VARCHAR(36) PRIMARY KEY,
 user_id VARCHAR(36) NOT NULL UNIQUE,
 setting_config JSON,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 添加索引
CREATE INDEX idx_user_settings_user_id ON user_settings(user_id);

-- 创建索引
CREATE INDEX idx_sessions_user_id ON sessions(user_id);
CREATE INDEX idx_sessions_agent_id ON sessions(agent_id);
CREATE INDEX idx_context_session_id ON context(session_id);
CREATE INDEX idx_messages_session_id ON messages(session_id);
CREATE INDEX idx_agent_tasks_session_id ON agent_tasks(session_id);
CREATE INDEX idx_agent_tasks_user_id ON agent_tasks(user_id);
CREATE INDEX idx_agent_tasks_parent_task_id ON agent_tasks(parent_task_id);
CREATE INDEX idx_agents_user_id ON agents(user_id);
CREATE INDEX idx_agent_workspace_agent_id ON agent_workspace(agent_id);
CREATE INDEX idx_agent_workspace_user_id ON agent_workspace(user_id);
CREATE INDEX idx_agent_versions_agent_id ON agent_versions(agent_id);
CREATE INDEX idx_agent_versions_user_id ON agent_versions(user_id);
CREATE INDEX idx_models_provider_id ON models(provider_id);
CREATE INDEX idx_models_user_id ON models(user_id);
CREATE INDEX idx_providers_user_id ON providers(user_id);
CREATE INDEX idx_tools_user_id ON tools(user_id);
CREATE INDEX idx_scheduled_tasks_user_id ON scheduled_tasks(user_id);
CREATE INDEX idx_scheduled_tasks_agent_id ON scheduled_tasks(agent_id);
CREATE INDEX idx_scheduled_tasks_session_id ON scheduled_tasks(session_id);
CREATE INDEX idx_scheduled_tasks_status ON scheduled_tasks(status);
CREATE INDEX idx_user_settings_user_id ON user_settings(user_id);

-- 添加表和列的注释
COMMENT ON TABLE sessions IS '会话实体类,代表一个独立的对话会话/主题';
COMMENT ON COLUMN sessions.id IS '会话唯一ID';
COMMENT ON COLUMN sessions.title IS '会话标题';
COMMENT ON COLUMN sessions.user_id IS '所属用户ID';
COMMENT ON COLUMN sessions.agent_id IS '关联的Agent版本ID';
COMMENT ON COLUMN sessions.description IS '会话描述';
COMMENT ON COLUMN sessions.is_archived IS '是否归档';
COMMENT ON COLUMN sessions.metadata IS '会话元数据,可存储其他自定义信息,JSON格式';
COMMENT ON COLUMN sessions.created_at IS '创建时间';
COMMENT ON COLUMN sessions.updated_at IS '更新时间';
COMMENT ON COLUMN sessions.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE messages IS '消息实体类,代表对话中的一条消息';
COMMENT ON COLUMN messages.id IS '消息唯一ID';
COMMENT ON COLUMN messages.session_id IS '所属会话ID';
COMMENT ON COLUMN messages.role IS '消息角色 (user, assistant, system)';
COMMENT ON COLUMN messages.content IS '消息内容';
COMMENT ON COLUMN messages.message_type IS '消息类型';
COMMENT ON COLUMN messages.token_count IS 'Token数量';
COMMENT ON COLUMN messages.provider IS '服务提供商';
COMMENT ON COLUMN messages.model IS '使用的模型';
COMMENT ON COLUMN messages.metadata IS '消息元数据,JSON格式';
COMMENT ON COLUMN messages.created_at IS '创建时间';
COMMENT ON COLUMN messages.updated_at IS '更新时间';
COMMENT ON COLUMN messages.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE context IS '上下文实体类,管理会话的上下文窗口';
COMMENT ON COLUMN context.id IS '上下文唯一ID';
COMMENT ON COLUMN context.session_id IS '所属会话ID';
COMMENT ON COLUMN context.active_messages IS '活跃消息ID列表,JSON数组格式';
COMMENT ON COLUMN context.summary IS '历史消息摘要';
COMMENT ON COLUMN context.created_at IS '创建时间';
COMMENT ON COLUMN context.updated_at IS '更新时间';
COMMENT ON COLUMN context.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE agents IS 'Agent实体类,代表一个AI助手';
COMMENT ON COLUMN agents.id IS 'Agent唯一ID';
COMMENT ON COLUMN agents.name IS 'Agent名称';
COMMENT ON COLUMN agents.avatar IS 'Agent头像URL';
COMMENT ON COLUMN agents.description IS 'Agent描述';
COMMENT ON COLUMN agents.system_prompt IS 'Agent系统提示词';
COMMENT ON COLUMN agents.welcome_message IS '欢迎消息';
COMMENT ON COLUMN agents.published_version IS '当前发布的版本ID';
COMMENT ON COLUMN agents.enabled IS 'Agent状态:TRUE-启用,FALSE-禁用';
COMMENT ON COLUMN agents.agent_type IS 'Agent类型:1-聊天助手, 2-功能性Agent';
COMMENT ON COLUMN agents.user_id IS '创建者用户ID';
COMMENT ON COLUMN agents.created_at IS '创建时间';
COMMENT ON COLUMN agents.updated_at IS '更新时间';
COMMENT ON COLUMN agents.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE agent_versions IS 'Agent版本实体类,代表一个Agent的发布版本';
COMMENT ON COLUMN agent_versions.id IS '版本唯一ID';
COMMENT ON COLUMN agent_versions.agent_id IS '关联的Agent ID';
COMMENT ON COLUMN agent_versions.name IS 'Agent名称';
COMMENT ON COLUMN agent_versions.avatar IS 'Agent头像URL';
COMMENT ON COLUMN agent_versions.description IS 'Agent描述';
COMMENT ON COLUMN agent_versions.version_number IS '版本号,如1.0.0';
COMMENT ON COLUMN agent_versions.system_prompt IS 'Agent系统提示词';
COMMENT ON COLUMN agent_versions.welcome_message IS '欢迎消息';
COMMENT ON COLUMN agent_versions.tools IS 'Agent可使用的工具列表,JSON数组格式';
COMMENT ON COLUMN agent_versions.knowledge_base_ids IS '关联的知识库ID列表,JSON数组格式';
COMMENT ON COLUMN agent_versions.change_log IS '版本更新日志';
COMMENT ON COLUMN agent_versions.agent_type IS 'Agent类型:1-聊天助手, 2-功能性Agent';
COMMENT ON COLUMN agent_versions.publish_status IS '发布状态:1-审核中, 2-已发布, 3-拒绝, 4-已下架';
COMMENT ON COLUMN agent_versions.reject_reason IS '审核拒绝原因';
COMMENT ON COLUMN agent_versions.review_time IS '审核时间';
COMMENT ON COLUMN agent_versions.published_at IS '发布时间';
COMMENT ON COLUMN agent_versions.user_id IS '创建者用户ID';
COMMENT ON COLUMN agent_versions.created_at IS '创建时间';
COMMENT ON COLUMN agent_versions.updated_at IS '更新时间';
COMMENT ON COLUMN agent_versions.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE agent_workspace IS 'Agent工作区实体类,用于记录用户添加到工作区的Agent';
COMMENT ON COLUMN agent_workspace.id IS '主键ID';
COMMENT ON COLUMN agent_workspace.agent_id IS 'Agent ID';
COMMENT ON COLUMN agent_workspace.user_id IS '用户ID';
COMMENT ON COLUMN agent_workspace.llm_model_config IS '模型配置,JSON格式';
COMMENT ON COLUMN agent_workspace.created_at IS '创建时间';
COMMENT ON COLUMN agent_workspace.updated_at IS '更新时间';
COMMENT ON COLUMN agent_workspace.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE providers IS '服务提供商领域模型';
COMMENT ON COLUMN providers.id IS '服务提供商ID';
COMMENT ON COLUMN providers.user_id IS '用户ID';
COMMENT ON COLUMN providers.protocol IS '协议类型';
COMMENT ON COLUMN providers.name IS '服务提供商名称';
COMMENT ON COLUMN providers.description IS '服务提供商描述';
COMMENT ON COLUMN providers.config IS '服务提供商配置,加密后的值';
COMMENT ON COLUMN providers.is_official IS '是否官方服务提供商';
COMMENT ON COLUMN providers.status IS '服务提供商状态';
COMMENT ON COLUMN providers.created_at IS '创建时间';
COMMENT ON COLUMN providers.updated_at IS '更新时间';
COMMENT ON COLUMN providers.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE models IS '模型领域模型';
COMMENT ON COLUMN models.id IS '模型ID';
COMMENT ON COLUMN models.user_id IS '用户ID';
COMMENT ON COLUMN models.provider_id IS '服务提供商ID';
COMMENT ON COLUMN models.model_id IS '模型ID标识';
COMMENT ON COLUMN models.name IS '模型名称';
COMMENT ON COLUMN models.description IS '模型描述';
COMMENT ON COLUMN models.is_official IS '是否官方模型';
COMMENT ON COLUMN models.type IS '模型类型';
COMMENT ON COLUMN models.status IS '模型状态';
COMMENT ON COLUMN models.created_at IS '创建时间';
COMMENT ON COLUMN models.updated_at IS '更新时间';
COMMENT ON COLUMN models.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE agent_tasks IS '任务实体类';
COMMENT ON COLUMN agent_tasks.id IS '任务ID';
COMMENT ON COLUMN agent_tasks.session_id IS '所属会话ID';
COMMENT ON COLUMN agent_tasks.user_id IS '用户ID';
COMMENT ON COLUMN agent_tasks.parent_task_id IS '父任务ID';
COMMENT ON COLUMN agent_tasks.task_name IS '任务名称';
COMMENT ON COLUMN agent_tasks.description IS '任务描述';
COMMENT ON COLUMN agent_tasks.status IS '任务状态';
COMMENT ON COLUMN agent_tasks.progress IS '任务进度,存放父任务中';
COMMENT ON COLUMN agent_tasks.start_time IS '开始时间';
COMMENT ON COLUMN agent_tasks.end_time IS '结束时间';
COMMENT ON COLUMN agent_tasks.task_result IS '任务结果';
COMMENT ON COLUMN agent_tasks.created_at IS '创建时间';
COMMENT ON COLUMN agent_tasks.updated_at IS '更新时间';
COMMENT ON COLUMN agent_tasks.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE scheduled_tasks IS '定时任务实体类';
COMMENT ON COLUMN scheduled_tasks.id IS '定时任务唯一ID';
COMMENT ON COLUMN scheduled_tasks.user_id IS '用户ID';
COMMENT ON COLUMN scheduled_tasks.agent_id IS '关联的Agent ID';
COMMENT ON COLUMN scheduled_tasks.session_id IS '关联的会话ID';
COMMENT ON COLUMN scheduled_tasks.content IS '任务内容';
COMMENT ON COLUMN scheduled_tasks.repeat_type IS '重复类型:NONE-不重复, DAILY-每天, WEEKLY-每周, MONTHLY-每月, WORKDAYS-工作日, CUSTOM-自定义';
COMMENT ON COLUMN scheduled_tasks.repeat_config IS '重复配置,JSON格式存储具体的重复规则';
COMMENT ON COLUMN scheduled_tasks.status IS '任务状态:ACTIVE-活跃, PAUSED-暂停, COMPLETED-已完成';
COMMENT ON COLUMN scheduled_tasks.last_execute_time IS '上次执行时间';
COMMENT ON COLUMN scheduled_tasks.created_at IS '创建时间';
COMMENT ON COLUMN scheduled_tasks.updated_at IS '更新时间';
COMMENT ON COLUMN scheduled_tasks.deleted_at IS '逻辑删除时间';

COMMENT ON COLUMN users.id IS '主键';
COMMENT ON COLUMN users.nickname IS '昵称';
COMMENT ON COLUMN users.email IS '邮箱';
COMMENT ON COLUMN users.phone IS '手机号';
COMMENT ON COLUMN users.password IS '密码';
COMMENT ON COLUMN users.created_at IS '创建时间';
COMMENT ON COLUMN users.updated_at IS '更新时间';
COMMENT ON COLUMN users.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE tools IS '工具实体类';
COMMENT ON COLUMN tools.id IS '工具唯一ID';
COMMENT ON COLUMN tools.name IS '工具名称';
COMMENT ON COLUMN tools.icon IS '工具图标';
COMMENT ON COLUMN tools.subtitle IS '副标题';
COMMENT ON COLUMN tools.description IS '工具描述';
COMMENT ON COLUMN tools.user_id IS '用户ID';
COMMENT ON COLUMN tools.labels IS '标签列表,JSON数组格式';
COMMENT ON COLUMN tools.tool_type IS '工具类型';
COMMENT ON COLUMN tools.upload_type IS '上传方式';
COMMENT ON COLUMN tools.upload_url IS '上传URL';
COMMENT ON COLUMN tools.install_command IS '安装命令,JSON格式';
COMMENT ON COLUMN tools.tool_list IS '工具列表,JSON数组格式';
COMMENT ON COLUMN tools.status IS '审核状态';
COMMENT ON COLUMN tools.is_office IS '是否官方工具';
COMMENT ON COLUMN tools.created_at IS '创建时间';
COMMENT ON COLUMN tools.updated_at IS '更新时间';
COMMENT ON COLUMN tools.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE tool_versions IS '工具版本实体类';
COMMENT ON COLUMN tool_versions.id IS '版本唯一ID';
COMMENT ON COLUMN tool_versions.name IS '工具名称';
COMMENT ON COLUMN tool_versions.icon IS '工具图标';
COMMENT ON COLUMN tool_versions.subtitle IS '副标题';
COMMENT ON COLUMN tool_versions.description IS '工具描述';
COMMENT ON COLUMN tool_versions.user_id IS '用户ID';
COMMENT ON COLUMN tool_versions.version IS '版本号';
COMMENT ON COLUMN tool_versions.tool_id IS '工具ID';
COMMENT ON COLUMN tool_versions.upload_type IS '上传方式';
COMMENT ON COLUMN tool_versions.upload_url IS '上传URL';
COMMENT ON COLUMN tool_versions.tool_list IS '工具列表,JSON数组格式';
COMMENT ON COLUMN tool_versions.labels IS '标签列表,JSON数组格式';
COMMENT ON COLUMN tool_versions.is_office IS '是否官方工具';
COMMENT ON COLUMN tool_versions.public_status IS '公开状态';
COMMENT ON COLUMN tool_versions.created_at IS '创建时间';
COMMENT ON COLUMN tool_versions.updated_at IS '更新时间';
COMMENT ON COLUMN tool_versions.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE user_tools IS '用户工具关联实体类';
COMMENT ON COLUMN user_tools.id IS '唯一ID';
COMMENT ON COLUMN user_tools.user_id IS '用户ID';
COMMENT ON COLUMN user_tools.tool_version_id IS '工具版本ID';
COMMENT ON COLUMN user_tools.version IS '版本号';
COMMENT ON COLUMN user_tools.upload_type IS '上传方式';
COMMENT ON COLUMN user_tools.upload_url IS '上传URL';
COMMENT ON COLUMN user_tools.tool_list IS '工具列表,JSON数组格式';
COMMENT ON COLUMN user_tools.labels IS '标签列表,JSON数组格式';
COMMENT ON COLUMN user_tools.is_office IS '是否官方工具';
COMMENT ON COLUMN user_tools.public_state IS '公开状态';
COMMENT ON COLUMN user_tools.created_at IS '创建时间';
COMMENT ON COLUMN user_tools.updated_at IS '更新时间';
COMMENT ON COLUMN user_tools.deleted_at IS '逻辑删除时间';
 
-- 添加表和列的注释
COMMENT ON TABLE user_settings IS '用户设置表,存储用户的个性化配置';
COMMENT ON COLUMN user_settings.id IS '设置记录唯一ID';
COMMENT ON COLUMN user_settings.user_id IS '用户ID,关联users表';
COMMENT ON COLUMN user_settings.setting_config IS '设置配置JSON,格式:{"default_model": "模型ID"}';
COMMENT ON COLUMN user_settings.created_at IS '创建时间';
COMMENT ON COLUMN user_settings.updated_at IS '更新时间';
COMMENT ON COLUMN user_settings.deleted_at IS '逻辑删除时间';

一键复制编辑原始数据按行查看历史

Xhy 提交于 2025年06月02日 11:10 +08:00 . feat(agent): 添加多模态支持,允许上传文件并在对话中使用

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500

-- AgentX初始化数据库脚本 - PostgreSQL版本

-- 会话表,存储用户与Agent的对话会话
CREATE TABLE sessions (
 id VARCHAR(36) PRIMARY KEY,
 title VARCHAR(255) NOT NULL,
 user_id VARCHAR(36) NOT NULL,
 agent_id VARCHAR(36),
 description TEXT,
 is_archived BOOLEAN DEFAULT FALSE,
 metadata JSONB,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 消息表,存储会话中的所有消息
CREATE TABLE messages (
 id VARCHAR(36) PRIMARY KEY,
 session_id VARCHAR(36) NOT NULL,
 role VARCHAR(20) NOT NULL,
 content TEXT NOT NULL,
 message_type VARCHAR(20) NOT NULL DEFAULT 'TEXT',
 token_count INTEGER DEFAULT 0,
 provider VARCHAR(50),
 model VARCHAR(50),
 metadata JSONB,
 file_urls JSONB,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 上下文表,管理对话上下文
CREATE TABLE context (
 id VARCHAR(36) PRIMARY KEY,
 session_id VARCHAR(36) NOT NULL,
 active_messages JSONB,
 summary TEXT,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- Agent 相关表结构
CREATE TABLE agents (
 id VARCHAR(36) PRIMARY KEY,
 name VARCHAR(255) NOT NULL,
 avatar VARCHAR(255),
 description TEXT,
 system_prompt TEXT,
 welcome_message TEXT,
 tool_ids JSONB,
 published_version VARCHAR(36),
 enabled BOOLEAN DEFAULT TRUE,
 agent_type INTEGER DEFAULT 1,
 user_id VARCHAR(36) NOT NULL,
 tool_preset_params JSONB,
 multi_modal BOOLEAN DEFAULT FALSE,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- Agent版本表
CREATE TABLE agent_versions (
 id VARCHAR(36) PRIMARY KEY,
 agent_id VARCHAR(36) NOT NULL,
 name VARCHAR(255) NOT NULL,
 avatar VARCHAR(255),
 description TEXT,
 version_number VARCHAR(20) NOT NULL,
 system_prompt TEXT,
 welcome_message TEXT,
 tool_ids JSONB,
 knowledge_base_ids JSONB,
 change_log TEXT,
 agent_type INTEGER DEFAULT 1,
 publish_status INTEGER DEFAULT 1,
 reject_reason TEXT,
 review_time TIMESTAMP,
 published_at TIMESTAMP,
 user_id VARCHAR(36) NOT NULL,
 tool_preset_params JSONB,
 multi_modal BOOLEAN DEFAULT FALSE,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- Agent工作区表
CREATE TABLE agent_workspace (
 id VARCHAR(36) PRIMARY KEY,
 agent_id VARCHAR(36) NOT NULL,
 user_id VARCHAR(36) NOT NULL,
 llm_model_config JSONB,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 服务提供商表
CREATE TABLE providers (
 id VARCHAR(36) PRIMARY KEY,
 user_id VARCHAR(36),
 protocol VARCHAR(50) NOT NULL,
 name VARCHAR(100) NOT NULL,
 description TEXT,
 config TEXT,
 is_official BOOLEAN DEFAULT FALSE,
 status BOOLEAN DEFAULT TRUE,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 模型表
CREATE TABLE models (
 id VARCHAR(36) PRIMARY KEY,
 user_id VARCHAR(36),
 provider_id VARCHAR(36) NOT NULL,
 model_id VARCHAR(100) NOT NULL,
 name VARCHAR(100) NOT NULL,
 description TEXT,
 is_official BOOLEAN DEFAULT FALSE,
 type VARCHAR(20) NOT NULL,
 status BOOLEAN DEFAULT TRUE,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 任务表
CREATE TABLE agent_tasks (
 id VARCHAR(36) PRIMARY KEY,
 session_id VARCHAR(36) NOT NULL,
 user_id VARCHAR(36) NOT NULL,
 parent_task_id VARCHAR(36),
 task_name VARCHAR(255) NOT NULL,
 description TEXT,
 status VARCHAR(20),
 progress INTEGER DEFAULT 0,
 start_time TIMESTAMP,
 end_time TIMESTAMP,
 task_result TEXT,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 定时任务表
CREATE TABLE scheduled_tasks (
 id VARCHAR(36) PRIMARY KEY,
 user_id VARCHAR(36) NOT NULL,
 agent_id VARCHAR(36) NOT NULL,
 session_id VARCHAR(36) NOT NULL,
 content TEXT NOT NULL,
 repeat_type VARCHAR(20) NOT NULL,
 repeat_config JSONB,
 status VARCHAR(20) DEFAULT 'ACTIVE',
 last_execute_time TIMESTAMP,
 next_execute_time TIMESTAMP,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

CREATE TABLE users (
 id varchar(36) PRIMARY KEY,
 nickname varchar(255) NOT NULL,
 email varchar(255),
 phone varchar(11),
 password varchar NOT NULL,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP,
 github_id varchar(255),
 github_login varchar(255),
 avatar_url varchar(255)
);

-- 工具相关表

-- 工具表
CREATE TABLE tools (
 id VARCHAR(36) PRIMARY KEY,
 name VARCHAR(255) NOT NULL,
 icon VARCHAR(255),
 subtitle VARCHAR(255),
 description TEXT,
 user_id VARCHAR(36) NOT NULL,
 labels JSONB,
 tool_type VARCHAR(50) NOT NULL,
 upload_type VARCHAR(20) NOT NULL,
 upload_url VARCHAR(255),
 install_command JSONB,
 tool_list JSONB,
 reject_reason TEXT,
 failed_step_status VARCHAR(20),
 mcp_server_name VARCHAR(255),
 status VARCHAR(20) NOT NULL,
 is_office BOOLEAN DEFAULT FALSE,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 工具版本表
CREATE TABLE tool_versions (
 id VARCHAR(36) PRIMARY KEY,
 name VARCHAR(255) NOT NULL,
 icon VARCHAR(255),
 subtitle VARCHAR(255),
 description TEXT,
 user_id VARCHAR(36) NOT NULL,
 version VARCHAR(50) NOT NULL,
 tool_id VARCHAR(36) NOT NULL,
 upload_type VARCHAR(20) NOT NULL,
 change_log TEXT,
 upload_url VARCHAR(255),
 tool_list JSONB,
 labels JSONB,
 mcp_server_name VARCHAR(255),
 is_office BOOLEAN DEFAULT FALSE,
 public_status BOOLEAN DEFAULT FALSE,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 用户工具关联表
CREATE TABLE user_tools (
 id VARCHAR(36) PRIMARY KEY,
 user_id VARCHAR(36) NOT NULL,
 name VARCHAR(255) NOT NULL,
 description TEXT,
 icon VARCHAR(255),
 subtitle VARCHAR(255),
 tool_id VARCHAR(36) NOT NULL,
 version VARCHAR(50) NOT NULL,
 tool_list JSONB,
 labels JSONB,
 is_office BOOLEAN DEFAULT FALSE,
 public_state BOOLEAN DEFAULT FALSE,
 mcp_server_name VARCHAR(255),
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);


-- 用户设置表
CREATE TABLE user_settings (
 id VARCHAR(36) PRIMARY KEY,
 user_id VARCHAR(36) NOT NULL UNIQUE,
 setting_config JSON,
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 deleted_at TIMESTAMP
);

-- 添加索引
CREATE INDEX idx_user_settings_user_id ON user_settings(user_id);





-- 创建索引
CREATE INDEX idx_sessions_user_id ON sessions(user_id);
CREATE INDEX idx_sessions_agent_id ON sessions(agent_id);
CREATE INDEX idx_context_session_id ON context(session_id);
CREATE INDEX idx_messages_session_id ON messages(session_id);
CREATE INDEX idx_agent_tasks_session_id ON agent_tasks(session_id);
CREATE INDEX idx_agent_tasks_user_id ON agent_tasks(user_id);
CREATE INDEX idx_agent_tasks_parent_task_id ON agent_tasks(parent_task_id);
CREATE INDEX idx_agents_user_id ON agents(user_id);
CREATE INDEX idx_agent_workspace_agent_id ON agent_workspace(agent_id);
CREATE INDEX idx_agent_workspace_user_id ON agent_workspace(user_id);
CREATE INDEX idx_agent_versions_agent_id ON agent_versions(agent_id);
CREATE INDEX idx_agent_versions_user_id ON agent_versions(user_id);
CREATE INDEX idx_models_provider_id ON models(provider_id);
CREATE INDEX idx_models_user_id ON models(user_id);
CREATE INDEX idx_providers_user_id ON providers(user_id);
CREATE INDEX idx_tools_user_id ON tools(user_id);
CREATE INDEX idx_scheduled_tasks_user_id ON scheduled_tasks(user_id);
CREATE INDEX idx_scheduled_tasks_agent_id ON scheduled_tasks(agent_id);
CREATE INDEX idx_scheduled_tasks_session_id ON scheduled_tasks(session_id);
CREATE INDEX idx_scheduled_tasks_status ON scheduled_tasks(status);
CREATE INDEX idx_user_settings_user_id ON user_settings(user_id);

-- 添加表和列的注释
COMMENT ON TABLE sessions IS '会话实体类,代表一个独立的对话会话/主题';
COMMENT ON COLUMN sessions.id IS '会话唯一ID';
COMMENT ON COLUMN sessions.title IS '会话标题';
COMMENT ON COLUMN sessions.user_id IS '所属用户ID';
COMMENT ON COLUMN sessions.agent_id IS '关联的Agent版本ID';
COMMENT ON COLUMN sessions.description IS '会话描述';
COMMENT ON COLUMN sessions.is_archived IS '是否归档';
COMMENT ON COLUMN sessions.metadata IS '会话元数据,可存储其他自定义信息,JSON格式';
COMMENT ON COLUMN sessions.created_at IS '创建时间';
COMMENT ON COLUMN sessions.updated_at IS '更新时间';
COMMENT ON COLUMN sessions.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE messages IS '消息实体类,代表对话中的一条消息';
COMMENT ON COLUMN messages.id IS '消息唯一ID';
COMMENT ON COLUMN messages.session_id IS '所属会话ID';
COMMENT ON COLUMN messages.role IS '消息角色 (user, assistant, system)';
COMMENT ON COLUMN messages.content IS '消息内容';
COMMENT ON COLUMN messages.message_type IS '消息类型';
COMMENT ON COLUMN messages.token_count IS 'Token数量';
COMMENT ON COLUMN messages.provider IS '服务提供商';
COMMENT ON COLUMN messages.model IS '使用的模型';
COMMENT ON COLUMN messages.metadata IS '消息元数据,JSON格式';
COMMENT ON COLUMN messages.created_at IS '创建时间';
COMMENT ON COLUMN messages.updated_at IS '更新时间';
COMMENT ON COLUMN messages.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE context IS '上下文实体类,管理会话的上下文窗口';
COMMENT ON COLUMN context.id IS '上下文唯一ID';
COMMENT ON COLUMN context.session_id IS '所属会话ID';
COMMENT ON COLUMN context.active_messages IS '活跃消息ID列表,JSON数组格式';
COMMENT ON COLUMN context.summary IS '历史消息摘要';
COMMENT ON COLUMN context.created_at IS '创建时间';
COMMENT ON COLUMN context.updated_at IS '更新时间';
COMMENT ON COLUMN context.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE agents IS 'Agent实体类,代表一个AI助手';
COMMENT ON COLUMN agents.id IS 'Agent唯一ID';
COMMENT ON COLUMN agents.name IS 'Agent名称';
COMMENT ON COLUMN agents.avatar IS 'Agent头像URL';
COMMENT ON COLUMN agents.description IS 'Agent描述';
COMMENT ON COLUMN agents.system_prompt IS 'Agent系统提示词';
COMMENT ON COLUMN agents.welcome_message IS '欢迎消息';
COMMENT ON COLUMN agents.published_version IS '当前发布的版本ID';
COMMENT ON COLUMN agents.enabled IS 'Agent状态:TRUE-启用,FALSE-禁用';
COMMENT ON COLUMN agents.agent_type IS 'Agent类型:1-聊天助手, 2-功能性Agent';
COMMENT ON COLUMN agents.user_id IS '创建者用户ID';
COMMENT ON COLUMN agents.created_at IS '创建时间';
COMMENT ON COLUMN agents.updated_at IS '更新时间';
COMMENT ON COLUMN agents.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE agent_versions IS 'Agent版本实体类,代表一个Agent的发布版本';
COMMENT ON COLUMN agent_versions.id IS '版本唯一ID';
COMMENT ON COLUMN agent_versions.agent_id IS '关联的Agent ID';
COMMENT ON COLUMN agent_versions.name IS 'Agent名称';
COMMENT ON COLUMN agent_versions.avatar IS 'Agent头像URL';
COMMENT ON COLUMN agent_versions.description IS 'Agent描述';
COMMENT ON COLUMN agent_versions.version_number IS '版本号,如1.0.0';
COMMENT ON COLUMN agent_versions.system_prompt IS 'Agent系统提示词';
COMMENT ON COLUMN agent_versions.welcome_message IS '欢迎消息';
COMMENT ON COLUMN agent_versions.tools IS 'Agent可使用的工具列表,JSON数组格式';
COMMENT ON COLUMN agent_versions.knowledge_base_ids IS '关联的知识库ID列表,JSON数组格式';
COMMENT ON COLUMN agent_versions.change_log IS '版本更新日志';
COMMENT ON COLUMN agent_versions.agent_type IS 'Agent类型:1-聊天助手, 2-功能性Agent';
COMMENT ON COLUMN agent_versions.publish_status IS '发布状态:1-审核中, 2-已发布, 3-拒绝, 4-已下架';
COMMENT ON COLUMN agent_versions.reject_reason IS '审核拒绝原因';
COMMENT ON COLUMN agent_versions.review_time IS '审核时间';
COMMENT ON COLUMN agent_versions.published_at IS '发布时间';
COMMENT ON COLUMN agent_versions.user_id IS '创建者用户ID';
COMMENT ON COLUMN agent_versions.created_at IS '创建时间';
COMMENT ON COLUMN agent_versions.updated_at IS '更新时间';
COMMENT ON COLUMN agent_versions.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE agent_workspace IS 'Agent工作区实体类,用于记录用户添加到工作区的Agent';
COMMENT ON COLUMN agent_workspace.id IS '主键ID';
COMMENT ON COLUMN agent_workspace.agent_id IS 'Agent ID';
COMMENT ON COLUMN agent_workspace.user_id IS '用户ID';
COMMENT ON COLUMN agent_workspace.llm_model_config IS '模型配置,JSON格式';
COMMENT ON COLUMN agent_workspace.created_at IS '创建时间';
COMMENT ON COLUMN agent_workspace.updated_at IS '更新时间';
COMMENT ON COLUMN agent_workspace.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE providers IS '服务提供商领域模型';
COMMENT ON COLUMN providers.id IS '服务提供商ID';
COMMENT ON COLUMN providers.user_id IS '用户ID';
COMMENT ON COLUMN providers.protocol IS '协议类型';
COMMENT ON COLUMN providers.name IS '服务提供商名称';
COMMENT ON COLUMN providers.description IS '服务提供商描述';
COMMENT ON COLUMN providers.config IS '服务提供商配置,加密后的值';
COMMENT ON COLUMN providers.is_official IS '是否官方服务提供商';
COMMENT ON COLUMN providers.status IS '服务提供商状态';
COMMENT ON COLUMN providers.created_at IS '创建时间';
COMMENT ON COLUMN providers.updated_at IS '更新时间';
COMMENT ON COLUMN providers.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE models IS '模型领域模型';
COMMENT ON COLUMN models.id IS '模型ID';
COMMENT ON COLUMN models.user_id IS '用户ID';
COMMENT ON COLUMN models.provider_id IS '服务提供商ID';
COMMENT ON COLUMN models.model_id IS '模型ID标识';
COMMENT ON COLUMN models.name IS '模型名称';
COMMENT ON COLUMN models.description IS '模型描述';
COMMENT ON COLUMN models.is_official IS '是否官方模型';
COMMENT ON COLUMN models.type IS '模型类型';
COMMENT ON COLUMN models.status IS '模型状态';
COMMENT ON COLUMN models.created_at IS '创建时间';
COMMENT ON COLUMN models.updated_at IS '更新时间';
COMMENT ON COLUMN models.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE agent_tasks IS '任务实体类';
COMMENT ON COLUMN agent_tasks.id IS '任务ID';
COMMENT ON COLUMN agent_tasks.session_id IS '所属会话ID';
COMMENT ON COLUMN agent_tasks.user_id IS '用户ID';
COMMENT ON COLUMN agent_tasks.parent_task_id IS '父任务ID';
COMMENT ON COLUMN agent_tasks.task_name IS '任务名称';
COMMENT ON COLUMN agent_tasks.description IS '任务描述';
COMMENT ON COLUMN agent_tasks.status IS '任务状态';
COMMENT ON COLUMN agent_tasks.progress IS '任务进度,存放父任务中';
COMMENT ON COLUMN agent_tasks.start_time IS '开始时间';
COMMENT ON COLUMN agent_tasks.end_time IS '结束时间';
COMMENT ON COLUMN agent_tasks.task_result IS '任务结果';
COMMENT ON COLUMN agent_tasks.created_at IS '创建时间';
COMMENT ON COLUMN agent_tasks.updated_at IS '更新时间';
COMMENT ON COLUMN agent_tasks.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE scheduled_tasks IS '定时任务实体类';
COMMENT ON COLUMN scheduled_tasks.id IS '定时任务唯一ID';
COMMENT ON COLUMN scheduled_tasks.user_id IS '用户ID';
COMMENT ON COLUMN scheduled_tasks.agent_id IS '关联的Agent ID';
COMMENT ON COLUMN scheduled_tasks.session_id IS '关联的会话ID';
COMMENT ON COLUMN scheduled_tasks.content IS '任务内容';
COMMENT ON COLUMN scheduled_tasks.repeat_type IS '重复类型:NONE-不重复, DAILY-每天, WEEKLY-每周, MONTHLY-每月, WORKDAYS-工作日, CUSTOM-自定义';
COMMENT ON COLUMN scheduled_tasks.repeat_config IS '重复配置,JSON格式存储具体的重复规则';
COMMENT ON COLUMN scheduled_tasks.status IS '任务状态:ACTIVE-活跃, PAUSED-暂停, COMPLETED-已完成';
COMMENT ON COLUMN scheduled_tasks.last_execute_time IS '上次执行时间';
COMMENT ON COLUMN scheduled_tasks.created_at IS '创建时间';
COMMENT ON COLUMN scheduled_tasks.updated_at IS '更新时间';
COMMENT ON COLUMN scheduled_tasks.deleted_at IS '逻辑删除时间';

COMMENT ON COLUMN users.id IS '主键';
COMMENT ON COLUMN users.nickname IS '昵称';
COMMENT ON COLUMN users.email IS '邮箱';
COMMENT ON COLUMN users.phone IS '手机号';
COMMENT ON COLUMN users.password IS '密码';
COMMENT ON COLUMN users.created_at IS '创建时间';
COMMENT ON COLUMN users.updated_at IS '更新时间';
COMMENT ON COLUMN users.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE tools IS '工具实体类';
COMMENT ON COLUMN tools.id IS '工具唯一ID';
COMMENT ON COLUMN tools.name IS '工具名称';
COMMENT ON COLUMN tools.icon IS '工具图标';
COMMENT ON COLUMN tools.subtitle IS '副标题';
COMMENT ON COLUMN tools.description IS '工具描述';
COMMENT ON COLUMN tools.user_id IS '用户ID';
COMMENT ON COLUMN tools.labels IS '标签列表,JSON数组格式';
COMMENT ON COLUMN tools.tool_type IS '工具类型';
COMMENT ON COLUMN tools.upload_type IS '上传方式';
COMMENT ON COLUMN tools.upload_url IS '上传URL';
COMMENT ON COLUMN tools.install_command IS '安装命令,JSON格式';
COMMENT ON COLUMN tools.tool_list IS '工具列表,JSON数组格式';
COMMENT ON COLUMN tools.status IS '审核状态';
COMMENT ON COLUMN tools.is_office IS '是否官方工具';
COMMENT ON COLUMN tools.created_at IS '创建时间';
COMMENT ON COLUMN tools.updated_at IS '更新时间';
COMMENT ON COLUMN tools.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE tool_versions IS '工具版本实体类';
COMMENT ON COLUMN tool_versions.id IS '版本唯一ID';
COMMENT ON COLUMN tool_versions.name IS '工具名称';
COMMENT ON COLUMN tool_versions.icon IS '工具图标';
COMMENT ON COLUMN tool_versions.subtitle IS '副标题';
COMMENT ON COLUMN tool_versions.description IS '工具描述';
COMMENT ON COLUMN tool_versions.user_id IS '用户ID';
COMMENT ON COLUMN tool_versions.version IS '版本号';
COMMENT ON COLUMN tool_versions.tool_id IS '工具ID';
COMMENT ON COLUMN tool_versions.upload_type IS '上传方式';
COMMENT ON COLUMN tool_versions.upload_url IS '上传URL';
COMMENT ON COLUMN tool_versions.tool_list IS '工具列表,JSON数组格式';
COMMENT ON COLUMN tool_versions.labels IS '标签列表,JSON数组格式';
COMMENT ON COLUMN tool_versions.is_office IS '是否官方工具';
COMMENT ON COLUMN tool_versions.public_status IS '公开状态';
COMMENT ON COLUMN tool_versions.created_at IS '创建时间';
COMMENT ON COLUMN tool_versions.updated_at IS '更新时间';
COMMENT ON COLUMN tool_versions.deleted_at IS '逻辑删除时间';

COMMENT ON TABLE user_tools IS '用户工具关联实体类';
COMMENT ON COLUMN user_tools.id IS '唯一ID';
COMMENT ON COLUMN user_tools.user_id IS '用户ID';
COMMENT ON COLUMN user_tools.tool_version_id IS '工具版本ID';
COMMENT ON COLUMN user_tools.version IS '版本号';
COMMENT ON COLUMN user_tools.upload_type IS '上传方式';
COMMENT ON COLUMN user_tools.upload_url IS '上传URL';
COMMENT ON COLUMN user_tools.tool_list IS '工具列表,JSON数组格式';
COMMENT ON COLUMN user_tools.labels IS '标签列表,JSON数组格式';
COMMENT ON COLUMN user_tools.is_office IS '是否官方工具';
COMMENT ON COLUMN user_tools.public_state IS '公开状态';
COMMENT ON COLUMN user_tools.created_at IS '创建时间';
COMMENT ON COLUMN user_tools.updated_at IS '更新时间';
COMMENT ON COLUMN user_tools.deleted_at IS '逻辑删除时间';
 
-- 添加表和列的注释
COMMENT ON TABLE user_settings IS '用户设置表,存储用户的个性化配置';
COMMENT ON COLUMN user_settings.id IS '设置记录唯一ID';
COMMENT ON COLUMN user_settings.user_id IS '用户ID,关联users表';
COMMENT ON COLUMN user_settings.setting_config IS '设置配置JSON,格式:{"default_model": "模型ID"}';
COMMENT ON COLUMN user_settings.created_at IS '创建时间';
COMMENT ON COLUMN user_settings.updated_at IS '更新时间';
COMMENT ON COLUMN user_settings.deleted_at IS '逻辑删除时间';