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

/*!40103 SET TIME_ZONE='+00:00' */;
CREATE TABLE `data_universe_rkd` (
  `SecCode` int NOT NULL,
  `Type_` int NOT NULL,
  `ID` varchar(31) NOT NULL,
  `RkdCode` int DEFAULT NULL,
  `RkdIssueID` int DEFAULT NULL,
  `RkdIssueCode` int DEFAULT NULL,
  `RkdIssueType` char(1) DEFAULT NULL,
  `RkdIssueStatus` int DEFAULT NULL,
  `RkdIssueOrder` int DEFAULT NULL,
  `RkdListingType` char(3) DEFAULT NULL,
  `ISIN` varchar(41) DEFAULT NULL,
  `Ticker` varchar(41) DEFAULT NULL,
  `SEDOL` varchar(7) DEFAULT NULL,
  `CUSIP` varchar(9) DEFAULT NULL,
  `RIC` varchar(41) DEFAULT NULL,
  `DisplayRIC` varchar(23) DEFAULT NULL,
  `RkdExchCode` varchar(5) DEFAULT NULL,
  `RkdExchCtry` char(3) DEFAULT NULL,
  `ShPerListing` float DEFAULT NULL,
  `PrimaryIssueType` char(3) DEFAULT NULL,
  `PrimaryIssueCode` int DEFAULT NULL,
  `RelType` int DEFAULT NULL,
  `COATypeCode` char(3) DEFAULT NULL,
  PRIMARY KEY (`SecCode`,`Type_`),
  KEY `ID` (`ID`),
  KEY `RkdCode` (`RkdCode`),
  KEY `RkdIssueID` (`RkdIssueID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;