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

/*!40103 SET TIME_ZONE='+00:00' */;
CREATE TABLE `model_universe` (
  `SecCode` int NOT NULL,
  `Type_` int NOT NULL,
  `ID` varchar(31) NOT NULL,
  `ISIN` varchar(13) DEFAULT NULL,
  `RkdISIN` varchar(41) DEFAULT NULL,
  `RkdTicker` varchar(41) DEFAULT NULL,
  `PermIDTicker` varchar(25) DEFAULT NULL,
  `RkdSEDOL` varchar(7) DEFAULT NULL,
  `RkdCUSIP` varchar(9) DEFAULT NULL,
  `RkdRIC` varchar(41) DEFAULT NULL,
  `RkdDisplayRIC` varchar(23) DEFAULT NULL,
  `Name` varchar(61) DEFAULT NULL,
  `ModelCntry` char(2) DEFAULT NULL,
  `Country` char(3) 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,
  `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,
  `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,
  `QuotePermID` bigint DEFAULT NULL,
  `InstrPermID` bigint DEFAULT NULL,
  `OrgPermID` bigint DEFAULT NULL,
  `PriTrdQuotePermID` bigint DEFAULT NULL,
  `PriValQuotePermID` bigint DEFAULT NULL,
  `PriInstrPermID` bigint DEFAULT NULL,
  `IsPrimaryQuote` tinyint DEFAULT NULL,
  `IsPrimaryInstr` tinyint DEFAULT NULL,
  `PermQuoteStatus` varchar(2) DEFAULT NULL,
  `PermInstrStatus` varchar(2) DEFAULT NULL,
  `ExchCode` varchar(3) DEFAULT NULL,
  `QuoteClass` varchar(30) DEFAULT NULL,
  `InstrClass` varchar(30) DEFAULT NULL,
  `OrgTypeCode` varchar(50) DEFAULT NULL,
  `DomCntry` varchar(3) DEFAULT NULL,
  `IncCntry` varchar(3) DEFAULT NULL,
  `PriTRBCIndPermID` bigint DEFAULT NULL,
  `DsSecDelistDate` date DEFAULT NULL,
  `DsExchQtStartDate` date DEFAULT NULL,
  `SecMapStartDate` date DEFAULT NULL,
  `SecMapEndDate` date DEFAULT NULL,
  `PermQuoteRetireDate` date DEFAULT NULL,
  `PermOrgIPODate` date DEFAULT NULL,
  `PermSecMapStartDate` date DEFAULT NULL,
  `PermSecMapEndDate` date DEFAULT NULL,
  `startDate` date DEFAULT NULL,
  `endDate` date DEFAULT NULL,
  PRIMARY KEY (`SecCode`,`Type_`),
  KEY `ID` (`ID`),
  KEY `InfoCode` (`InfoCode`),
  KEY `RkdCode` (`RkdCode`),
  KEY `RkdIssueID` (`RkdIssueID`),
  KEY `QuotePermID` (`QuotePermID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
