rollpix.db — image_usage

• admin_users
• billing_cache
• gemini_models
• image_usage
• llm_calls
• product_sessions
• sqlite_sequence
• stores

Toggle helper tables

• Structure
• Content
• Query
• Insert
• Drop
• Import
• Export

CREATE TABLE image_usage  (
  id TEXT PRIMARY KEY,
  request_id TEXT UNIQUE NOT NULL,
  store_key TEXT NOT NULL,
  origin_url TEXT,
  ts TEXT NOT NULL,
  sku TEXT NOT NULL,
  image_id TEXT,
  image_name TEXT NOT NULL,
  model TEXT NOT NULL,
  plan TEXT NOT NULL DEFAULT 'autogestionado',
  api_calls_count INTEGER NOT NULL,
  input_tokens_total INTEGER NOT NULL,
  output_tokens_total INTEGER NOT NULL,
  api_cost REAL NOT NULL,
  final_cost REAL NOT NULL,
  currency TEXT NOT NULL,
  meta_json TEXT
)

CREATE INDEX idx_image_usage_model
ON image_usage(model)

CREATE INDEX idx_image_usage_plan
ON image_usage(plan)

CREATE INDEX idx_image_usage_sku
ON image_usage(sku)

CREATE INDEX idx_image_usage_store_ts
ON image_usage(store_key, ts)