Create
Query
rollpix.db
—
billing_cache
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
Insert row into billing_cache
store_key
TEXT NOT NULL
year
INTEGER NOT NULL
month
INTEGER NOT NULL
total_sessions
INTEGER (default 0)
total_calls
INTEGER (default 0)
total_skus
INTEGER (default 0)
image_generate_count
INTEGER (default 0)
image_edit_count
INTEGER (default 0)
description_generate_count
INTEGER (default 0)
image_search_count
INTEGER (default 0)
image_upload_count
INTEGER (default 0)
image_generation_sessions
INTEGER (default 0)
description_generation_sessions
INTEGER (default 0)
search_sessions
INTEGER (default 0)
api_cost_total
REAL (default 0)
invoiced_amount
REAL (default 0)
margin
REAL (default 0)
margin_percent
REAL (default 0)
billing_model
TEXT
calculated_at
TEXT (default datetime('now'))
Insert
Cancel