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

/*!40103 SET TIME_ZONE='+00:00' */;
CREATE TABLE `data_universe_permid` (
  `SecCode` int NOT NULL,
  `Type_` int NOT NULL,
  `QuotePermID` bigint DEFAULT NULL,
  `InstrPermID` bigint DEFAULT NULL,
  `OrgPermID` bigint DEFAULT NULL,
  `PriTrdQuotePermID` bigint DEFAULT NULL,
  `ValQuotePermID` 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,
  `Ticker` varchar(25) 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,
  `PermQuoteRetireDate` date DEFAULT NULL,
  `PermOrgIPODate` date DEFAULT NULL,
  `PermSecMapStartDate` date DEFAULT NULL,
  `PermSecMapEndDate` date DEFAULT NULL,
  PRIMARY KEY (`SecCode`,`Type_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
