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

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

CREATE INDEX `fundamentals_calendardate_idx` ON `fundamentals` (`calendardate`);

CREATE INDEX `fundamentals_dimension_idx` ON `fundamentals` (`dimension`);

CREATE INDEX `fundamentals_lastupdated_idx` ON `fundamentals` (`lastupdated`);

CREATE INDEX `fundamentals_ticker_idx` ON `fundamentals` (`ticker`);