rollpix.db — gemini_models

CREATE TABLE gemini_models  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  model_key TEXT UNIQUE NOT NULL,
  model_id TEXT NOT NULL,
  display_name TEXT NOT NULL,
  cost_per_1m_input REAL NOT NULL,
  cost_per_1m_output REAL NOT NULL,
  cost_per_image REAL NOT NULL,
  active INTEGER NOT NULL DEFAULT 1,
  created_at TEXT DEFAULT (datetime('now')),
  updated_at TEXT DEFAULT (datetime('now')),
  provider TEXT NOT NULL DEFAULT 'google',
  quality TEXT,
  size TEXT,
  cost_per_1m_text_input REAL,
  cost_per_1m_image_input REAL,
  cost_per_1m_text_output REAL,
  cost_per_1m_thinking REAL,
  cost_per_1m_image_output REAL
)