| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| source_site | varchar | — | NO | 小芸站点ID |
| channel | varchar | MUL | NO | ai_chat/h5_visit/service_msg/other |
| biz_key | varchar | UNI | NO | 幂等键: 站点+渠道+原始ID |
| open_id | varchar | MUL | YES | |
| nickname | varchar | — | YES | |
| content | text | — | YES | |
| payload | json | — | YES | |
| occurred_at | datetime | — | YES | |
| received_at | datetime | — | NO |