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

CREATE TABLE IF NOT EXISTS `holdings` (
  `ticker` VARCHAR(255) NOT NULL,
  `investorname` VARCHAR(255) NOT NULL,
  `securitytype` VARCHAR(255) NOT NULL,
  `date` DATE NOT NULL,
  `value` DOUBLE,
  `units` DOUBLE,
  PRIMARY KEY (`ticker`, `investorname`, `securitytype`, `date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE INDEX `holdings_date_idx` ON `holdings` (`date`);

CREATE INDEX `holdings_investorname_idx` ON `holdings` (`investorname`);

CREATE INDEX `holdings_securitytype_idx` ON `holdings` (`securitytype`);