Query

rollpix.db — llm_calls

SQL

CREATE TABLE llm_calls  (
  id TEXT PRIMARY KEY,
  request_id TEXT UNIQUE,
  store_key TEXT NOT NULL,
  ts TEXT NOT NULL,
  provider TEXT NOT NULL,
  model TEXT NOT NULL,
  operation TEXT NOT NULL,
  status TEXT NOT NULL,
  plan TEXT NOT NULL DEFAULT 'autogestionado',
  input_tokens INTEGER NOT NULL,
  output_tokens INTEGER NOT NULL,
  api_cost REAL NOT NULL,
  latency_ms INTEGER,
  sku TEXT,
  image_id TEXT,
  job_id TEXT,
  provider_request_id TEXT,
  error_code TEXT,
  error_message TEXT,
  raw_json TEXT,
  product_session_id TEXT,
  session_call_number INTEGER,
  mode TEXT NOT NULL DEFAULT 'prod'
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
request_id TEXT ✓ Rename | Drop
store_key TEXT Rename | Drop
ts TEXT Rename | Drop
provider TEXT Rename | Drop
model TEXT Rename | Drop
operation TEXT Rename | Drop
status TEXT Rename | Drop
plan TEXT Rename | Drop
input_tokens INTEGER Rename | Drop
output_tokens INTEGER Rename | Drop
api_cost REAL Rename | Drop
latency_ms INTEGER ✓ Rename | Drop
sku TEXT ✓ Rename | Drop
image_id TEXT ✓ Rename | Drop
job_id TEXT ✓ Rename | Drop
provider_request_id TEXT ✓ Rename | Drop
error_code TEXT ✓ Rename | Drop
error_message TEXT ✓ Rename | Drop
raw_json TEXT ✓ Rename | Drop
product_session_id TEXT ✓ Rename | Drop
session_call_number INTEGER ✓ Rename | Drop
mode TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_llm_calls_mode mode SQL 
CREATE INDEX idx_llm_calls_mode
ON llm_calls(mode)
Drop
idx_llm_calls_model model SQL 
CREATE INDEX idx_llm_calls_model
ON llm_calls(model)
Drop
idx_llm_calls_plan plan SQL 
CREATE INDEX idx_llm_calls_plan
ON llm_calls(plan)
Drop
idx_llm_calls_session product_session_id SQL 
CREATE INDEX idx_llm_calls_session
ON llm_calls(product_session_id)
Drop
idx_llm_calls_status status SQL 
CREATE INDEX idx_llm_calls_status
ON llm_calls(status)
Drop
idx_llm_calls_store_ts
  • store_key
  • ts
 SQL 
CREATE INDEX idx_llm_calls_store_ts
ON llm_calls(store_key, ts)
Drop
sqlite_autoindex_llm_calls_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_llm_calls_2 request_id ✓ SQL
-- no sql found --
 Drop