rollpix.db — product_sessions

• 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 product_sessions  (
  id TEXT PRIMARY KEY,
  session_id TEXT UNIQUE NOT NULL,
  store_key TEXT NOT NULL,
  sku TEXT NOT NULL,
  started_at TEXT NOT NULL,
  closed_at TEXT,
  llm_calls_count INTEGER DEFAULT 0,
  total_api_cost REAL DEFAULT 0,
  final_cost REAL DEFAULT 0,
  status TEXT DEFAULT 'open',
  created_at TEXT DEFAULT (datetime('now')),
  session_type TEXT DEFAULT 'image_generation'
)

CREATE INDEX idx_product_sessions_session_id
ON product_sessions(session_id)

CREATE INDEX idx_product_sessions_session_type
ON product_sessions(session_type)

CREATE INDEX idx_product_sessions_sku
ON product_sessions(sku)

CREATE INDEX idx_product_sessions_status
ON product_sessions(status)

CREATE INDEX idx_product_sessions_store
ON product_sessions(store_key)