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

CREATE TABLE IF NOT EXISTS "fundamentals" (
  "ticker" TEXT NOT NULL,
  "dimension" TEXT NOT NULL,
  "calendardate" TEXT,
  "date" TEXT NOT NULL,
  "reportperiod" TEXT NOT NULL,
  "fiscalperiod" TEXT,
  "lastupdated" TEXT,
  "accoci" INTEGER,
  "assets" INTEGER,
  "assetsavg" INTEGER,
  "assetsc" INTEGER,
  "assetsnc" INTEGER,
  "assetturnover" REAL,
  "bvps" REAL,
  "capex" INTEGER,
  "cashneq" INTEGER,
  "cashnequsd" INTEGER,
  "cor" INTEGER,
  "consolinc" INTEGER,
  "currentratio" REAL,
  "de" REAL,
  "debt" INTEGER,
  "debtc" INTEGER,
  "debtnc" INTEGER,
  "debtusd" INTEGER,
  "deferredrev" INTEGER,
  "depamor" INTEGER,
  "deposits" INTEGER,
  "divyield" REAL,
  "dps" REAL,
  "ebit" INTEGER,
  "ebitda" INTEGER,
  "ebitdamargin" REAL,
  "ebitdausd" INTEGER,
  "ebitusd" INTEGER,
  "ebt" INTEGER,
  "eps" REAL,
  "epsdil" REAL,
  "epsusd" REAL,
  "equity" INTEGER,
  "equityavg" INTEGER,
  "equityusd" INTEGER,
  "ev" INTEGER,
  "evebit" INTEGER,
  "evebitda" REAL,
  "fcf" INTEGER,
  "fcfps" REAL,
  "fxusd" REAL,
  "gp" INTEGER,
  "grossmargin" REAL,
  "intangibles" INTEGER,
  "intexp" INTEGER,
  "invcap" INTEGER,
  "invcapavg" INTEGER,
  "inventory" INTEGER,
  "investments" INTEGER,
  "investmentsc" INTEGER,
  "investmentsnc" INTEGER,
  "liabilities" INTEGER,
  "liabilitiesc" INTEGER,
  "liabilitiesnc" INTEGER,
  "marketcap" INTEGER,
  "ncf" INTEGER,
  "ncfbus" INTEGER,
  "ncfcommon" INTEGER,
  "ncfdebt" INTEGER,
  "ncfdiv" INTEGER,
  "ncff" INTEGER,
  "ncfi" INTEGER,
  "ncfinv" INTEGER,
  "ncfo" INTEGER,
  "ncfx" INTEGER,
  "netinc" INTEGER,
  "netinccmn" INTEGER,
  "netinccmnusd" INTEGER,
  "netincdis" INTEGER,
  "netincnci" INTEGER,
  "netmargin" REAL,
  "opex" INTEGER,
  "opinc" INTEGER,
  "payables" INTEGER,
  "payoutratio" REAL,
  "pb" REAL,
  "pe" REAL,
  "pe1" REAL,
  "ppnenet" INTEGER,
  "prefdivis" INTEGER,
  "price" REAL,
  "ps" REAL,
  "ps1" REAL,
  "receivables" INTEGER,
  "retearn" INTEGER,
  "revenue" INTEGER,
  "revenueusd" INTEGER,
  "rnd" INTEGER,
  "roa" REAL,
  "roe" REAL,
  "roic" REAL,
  "ros" REAL,
  "sbcomp" INTEGER,
  "sgna" INTEGER,
  "sharefactor" REAL,
  "sharesbas" INTEGER,
  "shareswa" INTEGER,
  "shareswadil" INTEGER,
  "sps" REAL,
  "tangibles" INTEGER,
  "taxassets" INTEGER,
  "taxexp" INTEGER,
  "taxliabilities" INTEGER,
  "tbvps" REAL,
  "workingcapital" INTEGER,
  PRIMARY KEY ("ticker", "dimension", "date", "reportperiod")
);

CREATE INDEX IF NOT EXISTS "fundamentals_calendardate_idx" ON "fundamentals" ("calendardate");

CREATE INDEX IF NOT EXISTS "fundamentals_dimension_idx" ON "fundamentals" ("dimension");

CREATE INDEX IF NOT EXISTS "fundamentals_lastupdated_idx" ON "fundamentals" ("lastupdated");

CREATE INDEX IF NOT EXISTS "fundamentals_ticker_idx" ON "fundamentals" ("ticker");