Query

avatarai.db — ProviderPricing

SQL

CREATE TABLE "ProviderPricing"  (
  "Provider" TEXT NOT NULL,
  "Model" TEXT NOT NULL,
  "InputCostPerMillion" REAL NOT NULL,
  "OutputCostPerMillion" REAL NOT NULL,
  "Notes" TEXT NULL,
  "UpdatedAt" TEXT NOT NULL,
  CONSTRAINT "PK_ProviderPricing" PRIMARY KEY ("Provider", "Model")
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Provider TEXT ✓ Rename | Drop
Model TEXT ✓ Rename | Drop
InputCostPerMillion REAL Rename | Drop
OutputCostPerMillion REAL Rename | Drop
Notes TEXT ✓ Rename | Drop
UpdatedAt TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_ProviderPricing_1
  • Provider
  • Model
 ✓ SQL
-- no sql found --
 Drop