ai_message_step.sql 3.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
  1. -- AI 助手消息执行步骤表(思考过程 + 分步结论,docs/design/chat-process-timeline-plan.md)
  2. -- 追加型明细,物理删除,不设 del_flag;仅承接开关启用后新产生的对话,存量历史会话不回填。
  3. -- 幂等:create table / index if not exists,可重复执行。
  4. create table if not exists ai_message_step (
  5. id bigint not null,
  6. session_id bigint not null,
  7. message_id bigint not null,
  8. seq integer not null,
  9. step_key varchar(128) not null,
  10. kind varchar(20) not null,
  11. speaker varchar(10) default 'entry',
  12. expert_name varchar(100),
  13. agent_id bigint,
  14. title varchar(200),
  15. status varchar(20) not null,
  16. conclusion varchar(500),
  17. detail_json text,
  18. duration_ms bigint,
  19. remark varchar(500),
  20. create_by bigint,
  21. create_time timestamp,
  22. update_by bigint,
  23. update_time timestamp,
  24. constraint pk_ai_message_step primary key (id)
  25. );
  26. -- HITL 恢复段按 (message_id, step_key) upsert:暂停段 waiting → 恢复段终态,seq 保留原值
  27. create unique index if not exists uk_ai_message_step_key on ai_message_step (message_id, step_key);
  28. -- 会话级回放:按消息分组、轮内序号排序
  29. create index if not exists idx_ai_message_step_session on ai_message_step (session_id, message_id, seq);
  30. comment on table ai_message_step is 'AI 助手消息执行步骤表(思考/路由/工具/专家/确认/整合,物理追加+按步键幂等更新,仅新数据写入)';
  31. comment on column ai_message_step.id is '主键(雪花)';
  32. comment on column ai_message_step.session_id is '所属会话(ai_session.id)';
  33. comment on column ai_message_step.message_id is '所属助手消息(ai_message.id)';
  34. comment on column ai_message_step.seq is '轮内步骤序号(恢复段续接 maxSeq+n)';
  35. comment on column ai_message_step.step_key is '步骤键(轮内唯一,HITL 恢复段 upsert 依据)';
  36. comment on column ai_message_step.kind is '步骤类型 thinking/route/tool/expert/confirm/integration';
  37. comment on column ai_message_step.speaker is '说话人 entry/expert';
  38. comment on column ai_message_step.expert_name is '专家名(speaker=expert 时)';
  39. comment on column ai_message_step.agent_id is '关联智能体主键(专家步/确认步)';
  40. comment on column ai_message_step.title is '步骤标题(后端拼好)';
  41. comment on column ai_message_step.status is '状态 running/success/error/skipped/waiting/approved/rejected/expired/aborted';
  42. comment on column ai_message_step.conclusion is '一行结论(≤80 字)';
  43. comment on column ai_message_step.detail_json is '详情 JSON(思考全文/工具入参出参/专家原文+子工具/路由理由/确认处置,已脱敏)';
  44. comment on column ai_message_step.duration_ms is '步骤耗时(毫秒)';
  45. comment on column ai_message_step.remark is '备注';
  46. comment on column ai_message_step.create_by is '创建者';
  47. comment on column ai_message_step.create_time is '创建时间';
  48. comment on column ai_message_step.update_by is '更新者';
  49. comment on column ai_message_step.update_time is '更新时间';