df7f137657
This adds a `captain_sessions` table to log every Captain run, starting with Assistant Responses and Copilot Responses. Each session records the assistant, model, credits consumed, the FAQs/documents/scenario that contributed to the response, and the full run context — giving customers visibility into how a response was generated and giving us durable stats on credit, FAQ, and document usage (which today only exist as ephemeral trace metadata and an aggregate account counter). ## What changed - New `Captain::Session` model with a `session_type` enum (`assistant`, `copilot`). The subject (`Conversation` / `CopilotThread`) and result (`Message` / `CopilotMessage`) classes are inferred from the session type, so the table stores plain `subject_id` / `result_id` ids. `result_id` is nullable so failed runs that still consumed credits can be logged. - Composite indexes on `[session_type, subject_id]`, `[session_type, result_id]`, and `[account_id, session_type, created_at]` for lookup and usage-stats queries. - Factory and model specs. This PR is schema + model only; the writer/instrumentation that records sessions from the assistant and copilot flows will follow. --------- Co-authored-by: Sony Mathew <sony@chatwoot.com>
25 lines
907 B
Ruby
25 lines
907 B
Ruby
class CreateAgentSessions < ActiveRecord::Migration[7.1]
|
|
def change
|
|
create_table :agent_sessions do |t|
|
|
t.integer :session_type, null: false
|
|
t.references :subject, polymorphic: true, null: false, index: false
|
|
t.references :result, polymorphic: true, index: false
|
|
t.references :account, null: false, index: true
|
|
t.references :assistant, null: false, index: true
|
|
t.references :user, index: true
|
|
t.string :llm_model
|
|
t.float :credits_consumed
|
|
t.jsonb :faq_ids, default: []
|
|
t.jsonb :document_ids, default: []
|
|
t.jsonb :scenario_ids, default: []
|
|
t.jsonb :run_context, default: {}
|
|
|
|
t.timestamps
|
|
end
|
|
|
|
add_index :agent_sessions, [:account_id, :session_type, :created_at]
|
|
add_index :agent_sessions, [:account_id, :subject_type, :subject_id]
|
|
add_index :agent_sessions, [:account_id, :result_type, :result_id]
|
|
end
|
|
end
|