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

CREATE TABLE IF NOT EXISTS "holdings" (
  "ticker" TEXT NOT NULL,
  "investorname" TEXT NOT NULL,
  "securitytype" TEXT NOT NULL,
  "date" TEXT NOT NULL,
  "value" REAL,
  "units" REAL,
  PRIMARY KEY ("ticker", "investorname", "securitytype", "date")
);

CREATE INDEX IF NOT EXISTS "holdings_date_idx" ON "holdings" ("date");

CREATE INDEX IF NOT EXISTS "holdings_investorname_idx" ON "holdings" ("investorname");

CREATE INDEX IF NOT EXISTS "holdings_securitytype_idx" ON "holdings" ("securitytype");