49 lines
2.8 KiB
Markdown
49 lines
2.8 KiB
Markdown
# Session: 2026-05-07 12:39:54 GMT+8
|
||
|
||
- **Session Key**: agent:main:feishu:direct:ou_e63ce6b760ad39382852472f28fbe2a2
|
||
- **Session ID**: 34b92ba1-840b-4134-a753-1e6ab6ea9575
|
||
- **Source**: feishu
|
||
|
||
## Conversation Summary
|
||
|
||
assistant: 我来系统梳理所有数据库表中的字段、释义、用途和计算口径。先全面查阅已有的业务知识和数据表信息。
|
||
assistant: Now let me check the actual database tables to get exact field lists:
|
||
assistant: Now let me get detailed column info for all the key tables:
|
||
assistant: The BI aggregate tables don't exist in this DB yet. Let me check the MySQL side for some of these source tables:
|
||
assistant: MySQL user tables are not directly named matching the Go code names. Let me look at the MySQL config tables for the course-related structures, and also check the PostgreSQL for any additional fields I may have missed:
|
||
assistant: Now let me get the remaining key tables' field info:
|
||
assistant: Now let me also check the remaining PostgreSQL tables I haven't fetched yet:
|
||
assistant: OK, those tables don't exist. Now let me also check the MySQL `vala_order` database:
|
||
assistant: Now I have comprehensive information. Let me compile all of this into a well-organized document:
|
||
assistant: Now I can see the cut-off. Let me replace the truncated part and add the remaining sections:
|
||
assistant: The file was truncated. Let me fix it by replacing the last truncated section and appending all remaining content:
|
||
assistant: Now let me also update MEMORY.md to reference this new document:
|
||
assistant: 验证一下最终文档的完整性：
|
||
assistant: 文档完整。现在记录此次工作到当天的日记忆：
|
||
assistant: 好了，字段百科全书已梳理完成。以下是成果概要：
|
||
|
||
---
|
||
|
||
📊 **字段百科全书已创建**
|
||
|
||
**文件位置**: `business_knowledge/field_encyclopedia.md`（901行）
|
||
|
||
**覆盖范围**（共 34 张表）:
|
||
|
||
| 数据库 | 表数量 | 主要范围 |
|
||
|--------|--------|----------|
|
||
| PostgreSQL vala_bi | 24 张 | 订单、用户、角色、退费、课程、播放记录、巩固/强化/挑战源表、埋点等 |
|
||
| MySQL vala_user | 5 张 | 学习记录、课时完成、互动日志、游戏完成、长期记忆 |
|
||
| MySQL vala | 4 张 | 单元/课时配置、赛季包、挑战题目配置 |
|
||
| MySQL vala_order | 1 张 | 季度券源表 |
|
||
|
||
**每个字段包含**：字段名、数据类型、是否可空、释义、用途、计算口径（有口径的字段）
|
||
|
||
**额外包含**：
|
||
- 渠道映射表（sale_channel / key_from / download_channel）
|
||
- 核心计算口径汇总（GMV/GSV/退费率、Oops率/退出率、巩固/强化/挑战各指标）
|
||
- 课程结构计算方法（UnitIndex、ChapterIndex）
|
||
- 完整表名索引
|
||
|
||
这份文档可以作为后续所有数据查询工作的统一参考，有新表或字段变更时可以持续更新。
|