M7-09a P0 | ChatSession scope 核心查询索引（open-or-create） #94

New Issue

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

wangdl commented

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

目标

open-or-create 和 scope 会话列表的核心索引。与 #79 同批执行。

索引

CREATE INDEX idx_chat_session_scope ON ChatSession(userId, scopeType, scopeId, lastMessageAt DESC);

用途

open-or-create exact scope session
当前 scope 会话列表

## 目标 open-or-create 和 scope 会话列表的核心索引。与 #79 同批执行。 ## 索引 CREATE INDEX idx_chat_session_scope ON ChatSession(userId, scopeType, scopeId, lastMessageAt DESC); ## 用途 - open-or-create exact scope session - 当前 scope 会话列表

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:26 +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, scopeType, scopeId])

覆盖的查询场景

-- open-or-create: 查找同一 scope 下的现有会话
SELECT * FROM "ChatSession"
WHERE "userId" = ? AND "scopeType" = ? AND "scopeId" = ?
  AND "isDeleted" = false
ORDER BY "updatedAt" DESC LIMIT 1;

-- AI 页面内：当前 scope 的会话列表
SELECT * FROM "ChatSession"
WHERE "userId" = ? AND "scopeType" = ? AND "scopeId" = ?
  AND "isDeleted" = false
ORDER BY "lastMessageAt" DESC;

涉及文件

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

## 完成情况 ### 交付物 **核心查询索引** (`prisma/schema.prisma`): ```prisma @@index([userId, scopeType, scopeId]) ``` ### 覆盖的查询场景 ```sql -- open-or-create: 查找同一 scope 下的现有会话 SELECT * FROM "ChatSession" WHERE "userId" = ? AND "scopeType" = ? AND "scopeId" = ? AND "isDeleted" = false ORDER BY "updatedAt" DESC LIMIT 1; -- AI 页面内：当前 scope 的会话列表 SELECT * FROM "ChatSession" WHERE "userId" = ? AND "scopeType" = ? AND "scopeId" = ? AND "isDeleted" = false ORDER BY "lastMessageAt" DESC; ``` ### 涉及文件 | 文件 | 变更 | |------|------| | prisma/schema.prisma | @@index([userId, scopeType, scopeId]) |

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