CREATE TABLE `financial_market_positive_sentiment_indicator` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `docId` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `ontName` varchar(100) DEFAULT NULL,
  `ontUrl` varchar(100) DEFAULT NULL,
  `docKey` varchar(100) DEFAULT NULL,
  `anti` varchar(100) DEFAULT NULL,
  `pro` varchar(100) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `occurrences` int(11) DEFAULT NULL,
  `positive` varchar(100) DEFAULT NULL,
  `negative` varchar(100) DEFAULT NULL,
  `orgText` varbinary(100) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`,`docId`),
  KEY `docId_Index` (`docId`),
  KEY `name_index` (`name`),
  KEY `orgText_index` (`orgText`),
  KEY `ontUrl_index` (`ontUrl`),
  KEY `type_index` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
/*!50100 PARTITION BY KEY (docId) */