M7-09c P2 | ChatSession 删除过滤索引 #96

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_list ON ChatSession(userId, isDeleted, lastMessageAt DESC);

## 目标全局历史会话列表的删除过滤索引。 ## 索引 CREATE INDEX idx_chat_session_list ON ChatSession(userId, isDeleted, lastMessageAt DESC);

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

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, isDeleted])

覆盖的查询场景

-- 全局列表：排除已删除
SELECT * FROM "ChatSession"
WHERE "userId" = ? AND "isDeleted" = false
ORDER BY "lastMessageAt" DESC;

涉及文件

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

## 完成情况 ### 交付物 **删除过滤索引** (`prisma/schema.prisma`): ```prisma @@index([userId, isDeleted]) ``` ### 覆盖的查询场景 ```sql -- 全局列表：排除已删除 SELECT * FROM "ChatSession" WHERE "userId" = ? AND "isDeleted" = false ORDER BY "lastMessageAt" DESC; ``` ### 涉及文件 | 文件 | 变更 | |------|------| | prisma/schema.prisma | @@index([userId, isDeleted]) |

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#96