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

CREATE TABLE IF NOT EXISTS `descriptions` (
  `table` VARCHAR(255) NOT NULL,
  `indicator` VARCHAR(255) NOT NULL,
  `isfilter` VARCHAR(255),
  `isprimarykey` VARCHAR(255),
  `title` VARCHAR(255),
  `description` TEXT,
  `unittype` VARCHAR(255),
  PRIMARY KEY (`table`, `indicator`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE INDEX `descriptions_indicator_idx` ON `descriptions` (`indicator`);