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

CREATE TABLE IF NOT EXISTS `tickers` (
  `table` VARCHAR(255) NOT NULL,
  `permaticker` BIGINT NOT NULL,
  `ticker` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255),
  `exchange` VARCHAR(255),
  `isdelisted` VARCHAR(255),
  `category` VARCHAR(255),
  `cusips` VARCHAR(255),
  `siccode` BIGINT,
  `sicsector` VARCHAR(255),
  `sicindustry` VARCHAR(255),
  `figi` VARCHAR(255),
  `famaindustry` VARCHAR(255),
  `sector` VARCHAR(255),
  `industry` VARCHAR(255),
  `scalemarketcap` VARCHAR(255),
  `scalerevenue` VARCHAR(255),
  `relatedtickers` VARCHAR(255),
  `currency` VARCHAR(255),
  `location` VARCHAR(255),
  `lastupdated` DATE,
  `firstadded` DATE,
  `firstpricedate` DATE,
  `lastpricedate` DATE,
  `firstquarter` VARCHAR(255),
  `lastquarter` VARCHAR(255),
  `secfilings` VARCHAR(255),
  `companysite` VARCHAR(255),
  PRIMARY KEY (`table`, `permaticker`, `ticker`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE INDEX `tickers_lastupdated_idx` ON `tickers` (`lastupdated`);

CREATE INDEX `tickers_permaticker_idx` ON `tickers` (`permaticker`);

CREATE INDEX `tickers_table_idx` ON `tickers` (`table`);

CREATE INDEX `tickers_ticker_idx` ON `tickers` (`ticker`);