M7-09b P1 | ChatSession 知识库会话列表索引 #95

New Issue

wangdl · 2026-06-06T16:27:25+08:00

wangdl commented

2026-06-06 16:27:25 +08:00

目标

知识库下所有相关会话的查询索引。

索引

CREATE INDEX idx_chat_session_kb ON ChatSession(parentKnowledgeBaseId, scopeType, lastMessageAt DESC);
CREATE INDEX idx_chat_session_user_kb ON ChatSession(userId, parentKnowledgeBaseId, lastMessageAt DESC);

## 目标知识库下所有相关会话的查询索引。 ## 索引 CREATE INDEX idx_chat_session_kb ON ChatSession(parentKnowledgeBaseId, scopeType, lastMessageAt DESC); CREATE INDEX idx_chat_session_user_kb ON ChatSession(userId, parentKnowledgeBaseId, lastMessageAt DESC);

wangdl added this to the M7：ChatScope 会话系统 — 学习对象绑定的上下文会话 milestone 2026-06-06 16:27:25 +08:00

wangdl referenced this issue

2026-06-06 16:29:05 +08:00

CHAT-000 P0 | ChatScope 里程碑总设计文档 #97

wangdl closed this issue

2026-06-06 16:47:27 +08:00

wangdl referenced this issue

2026-06-06 16:48:11 +08:00

M7-01 P0 | Prisma ChatSession 新增 scopeType scopeId parentKnowledgeBaseId #79

wangdl referenced this issue

2026-06-06 16:50:24 +08:00

M7-01 P0 | Prisma ChatSession 新增 scopeType scopeId parentKnowledgeBaseId #79

wangdl commented

2026-06-06 16:52:36 +08:00

完成情况

交付物

知识库会话列表索引 (prisma/schema.prisma):

@@index([userId, parentKnowledgeBaseId])

覆盖的查询场景

-- 知识库下所有会话（不分 scope）
SELECT * FROM "ChatSession"
WHERE "userId" = ? AND "parentKnowledgeBaseId" = ?
  AND "isDeleted" = false
ORDER BY "isPinned" DESC, "lastMessageAt" DESC;

涉及文件

文件	变更
prisma/schema.prisma	@@index([userId, parentKnowledgeBaseId])

## 完成情况 ### 交付物 **知识库会话列表索引** (`prisma/schema.prisma`): ```prisma @@index([userId, parentKnowledgeBaseId]) ``` ### 覆盖的查询场景 ```sql -- 知识库下所有会话（不分 scope） SELECT * FROM "ChatSession" WHERE "userId" = ? AND "parentKnowledgeBaseId" = ? AND "isDeleted" = false ORDER BY "isPinned" DESC, "lastMessageAt" DESC; ``` ### 涉及文件 | 文件 | 变更 | |------|------| | prisma/schema.prisma | @@index([userId, parentKnowledgeBaseId]) |

wangdl referenced this issue

2026-06-06 16:55:26 +08:00

M7-09 P2 | ChatSession 数据库索引优化 #77

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: wangdl/api-server#95