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

CREATE TABLE IF NOT EXISTS `insiders` (
  `ticker` VARCHAR(255) NOT NULL,
  `date` DATE NOT NULL,
  `formtype` VARCHAR(255) NOT NULL,
  `ownername` VARCHAR(255) NOT NULL,
  `officertitle` VARCHAR(255),
  `isdirector` VARCHAR(255),
  `isofficer` VARCHAR(255),
  `istenpercentowner` VARCHAR(255),
  `transactiondate` DATE,
  `securityadcode` VARCHAR(255),
  `transactioncode` VARCHAR(255),
  `sharesownedbeforetransaction` BIGINT,
  `transactionshares` BIGINT,
  `sharesownedfollowingtransaction` BIGINT,
  `transactionpricepershare` DOUBLE,
  `transactionvalue` BIGINT,
  `securitytitle` VARCHAR(255),
  `directorindirect` VARCHAR(255),
  `natureofownership` VARCHAR(255),
  `dateexercisable` DATE,
  `priceexercisable` DOUBLE,
  `expirationdate` DATE,
  `rownum` BIGINT NOT NULL,
  PRIMARY KEY (`ticker`, `date`, `formtype`, `ownername`, `rownum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE INDEX `insiders_date_idx` ON `insiders` (`date`);

CREATE INDEX `insiders_ownername_idx` ON `insiders` (`ownername`);

CREATE INDEX `insiders_securityadcode_idx` ON `insiders` (`securityadcode`);

CREATE INDEX `insiders_transactionvalue_idx` ON `insiders` (`transactionvalue`);