当前位置：首页 > news >正文

LobeChat数据库设计：完整表结构关系模型解析

news 2026/5/6 22:43:14

LobeChat数据库设计：完整表结构关系模型解析

【免费下载链接】lobehubThe ultimate space for work and life — to find, build, and collaborate with agent teammates that grow with you. We are taking agent harness to the next level — enabling multi-agent collaboration, effortless agent team design, and introducing agents as the unit of work interaction.项目地址: https://gitcode.com/GitHub_Trending/lo/lobehub

LobeChat作为一款强大的AI协作平台，其高效运行离不开精心设计的数据库架构。本文将深入解析LobeChat的数据库设计，包括核心表结构、关系模型以及设计亮点，帮助开发者和用户更好地理解其数据组织方式。

数据库架构概览

LobeChat的数据库设计采用了模块化思想，将不同功能模块的数据存储分离，同时通过合理的关联关系保证数据一致性。数据库模式定义在docs/development/database-schema.dbml文件中，采用DBML（Database Markup Language）格式，清晰描述了表结构和关系。

核心表结构解析

1. 智能体相关表

智能体（Agents）是LobeChat的核心功能，相关表结构设计如下：

agents表：存储智能体基本信息

table agents { id text [pk, not null] slug varchar(100) title varchar(255) description varchar(1000) tags jsonb [default: `[]`] editor_data jsonb avatar text background_color text user_id text [not null] model text provider text system_role text pinned boolean created_at "timestamp with time zone" [not null, default: `now()`] updated_at "timestamp with time zone" [not null, default: `now()`] }

agent_skills表：存储智能体技能信息

table agent_skills { id text [pk, not null] name text [not null] description text [not null] identifier text [not null] source text [not null] manifest jsonb [not null, default: `{}`] user_id text [not null] created_at "timestamp with time zone" [not null, default: `now()`] updated_at "timestamp with time zone" [not null, default: `now()`] }

2. 对话相关表

messages表：存储对话消息

table messages { id text [pk, not null] role varchar(255) [not null] content text summary text model text provider text user_id text [not null] topic_id text parent_id text agent_id text created_at "timestamp with time zone" [not null, default: `now()`] updated_at "timestamp with time zone" [not null, default: `now()`] }

topics表：存储对话主题

table topics { id text [pk, not null] title text user_id text [not null] agent_id text chat_group_id text created_at "timestamp with time zone" [not null, default: `now()`] updated_at "timestamp with time zone" [not null, default: `now()`] }

3. 文件与知识库表

files表：存储用户上传文件

table files { id text [pk, not null] user_id text [not null] file_type varchar(255) [not null] name text [not null] size integer [not null] url text [not null] created_at "timestamp with time zone" [not null, default: `now()`] }

knowledge_bases表：存储知识库信息

table knowledge_bases { id text [pk, not null] name text [not null] description text user_id text [not null] is_public boolean [default: false] created_at "timestamp with time zone" [not null, default: `now()`] updated_at "timestamp with time zone" [not null, default: `now()`] }