/*!40101 SET NAMES binary*/;
/*!40014 SET FOREIGN_KEY_CHECKS=0*/;

/*!40103 SET TIME_ZONE='+00:00' */;
CREATE TABLE `data_universe_ds2` (
  `SecCode` int NOT NULL,
  `Type_` int NOT NULL,
  `ID` varchar(31) NOT NULL,
  `ISIN` varchar(13) DEFAULT NULL,
  `Name` varchar(61) DEFAULT NULL,
  `Country` varchar(4) DEFAULT NULL,
  `InfoCode` int DEFAULT NULL,
  `DsSecCode` int DEFAULT NULL,
  `DsCmpyCode` int DEFAULT NULL,
  `IsMajorSec` char(1) DEFAULT NULL,
  `DsCtryQtStatus` char(1) DEFAULT NULL,
  `DsPrimQtSedol` varchar(7) DEFAULT NULL,
  `DsTypeCode` varchar(5) DEFAULT NULL,
  `DsExchMnem` char(3) DEFAULT NULL,
  `DsExchCtryCode` char(7) DEFAULT NULL,
  `DsQuoteCurr` char(3) DEFAULT NULL,
  `DsSecDelistDate` date DEFAULT NULL,
  `DsExchQtStartDate` date DEFAULT NULL,
  `SecMapStartDate` date DEFAULT NULL,
  `SecMapEndDate` date DEFAULT NULL,
  PRIMARY KEY (`SecCode`,`Type_`),
  KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
