AI request schema for PhoenixKit AI system.

Tracks every AI API request for usage history and statistics. Used for monitoring costs, performance, and debugging.

Schema Fields

Request Identity

• endpoint_id: Foreign key to the AI endpoint used (new system)
• endpoint_name: Denormalized endpoint name for historical display
• prompt_id: Foreign key to the AI prompt used (if request used a prompt template)
• prompt_name: Denormalized prompt name for historical display
• account_id: Foreign key to AI account (deprecated, for backward compatibility)
• user_id: Foreign key to the user who made the request (nullable if user deleted)
• slot_index: Which slot was used (deprecated, for backward compatibility)

Request Details

• model: Model identifier (e.g., "anthropic/claude-3-haiku")
• request_type: Type of request (e.g., "text_completion", "chat")

Token Usage

• input_tokens: Number of tokens in the prompt
• output_tokens: Number of tokens in the response
• total_tokens: Total tokens used (input + output)

Performance & Cost

• cost_cents: Estimated cost in nanodollars (when available)
• latency_ms: Response time in milliseconds
• status: Request status - "success", "error", or "timeout"
• error_message: Error details if status is not "success"

Metadata

• metadata: Additional context (temperature, max_tokens, etc.)

Status Types

• success - Request completed successfully
• error - Request failed with an error
• timeout - Request timed out

Usage Examples

# Log a successful request
{:ok, request} = PhoenixKit.Modules.AI.create_request(%{
  endpoint_id: endpoint.id,
  endpoint_name: "Claude Fast",
  user_id: 123,
  model: "anthropic/claude-3-haiku",
  request_type: "chat",
  input_tokens: 150,
  output_tokens: 320,
  total_tokens: 470,
  latency_ms: 850,
  status: "success",
  metadata: %{"temperature" => 0.7}
})

# Log a failed request
{:ok, request} = PhoenixKit.Modules.AI.create_request(%{
  endpoint_id: endpoint.id,
  endpoint_name: "Claude Fast",
  model: "anthropic/claude-3-haiku",
  status: "error",
  error_message: "Rate limit exceeded"
})