-- Sharadar table schema: descriptions (SQLite)
-- As of 2026-08-02
-- https://api.sharadar.com/v1.0/schema/descriptions?format=sqlite

CREATE TABLE IF NOT EXISTS "descriptions" (
  "table" TEXT NOT NULL,
  "indicator" TEXT NOT NULL,
  "isfilter" TEXT,
  "isprimarykey" TEXT,
  "title" TEXT,
  "description" TEXT,
  "unittype" TEXT,
  PRIMARY KEY ("table", "indicator")
);

CREATE INDEX IF NOT EXISTS "descriptions_indicator_idx" ON "descriptions" ("indicator");