CREATE TABLE `slotdata` (
  `docId` int(11) NOT NULL,
  `conceptName` varchar(100) DEFAULT NULL,
  `conceptUrl` varchar(100) DEFAULT NULL,
  `translation` varchar(100) DEFAULT NULL,
  `source` varchar(100) DEFAULT NULL,
  `caption` varchar(100) DEFAULT NULL,
  `modifier` varchar(100) DEFAULT NULL,
  `full_name` varchar(100) DEFAULT NULL,
  `also_known_as` varchar(100) DEFAULT NULL,
  `alias` varchar(100) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `organizational_title` varchar(100) DEFAULT NULL,
  `normalized_acronym` varchar(100) DEFAULT NULL,
  `tribal_name` varchar(100) DEFAULT NULL,
  `gender` varchar(100) DEFAULT NULL,
  `ethnicity` varchar(100) DEFAULT NULL,
  `national_identity` varchar(100) DEFAULT NULL,
  `country_of_residence` varchar(100) DEFAULT NULL,
  `religion` varchar(100) DEFAULT NULL,
  `islamic_sect` varchar(100) DEFAULT NULL,
  `ideological_stream` varchar(100) DEFAULT NULL,
  `organization` varchar(100) DEFAULT NULL,
  `Organizational_identity` varchar(100) DEFAULT NULL,
  `date_of_birth` varchar(100) DEFAULT NULL,
  `year_of_birth` varchar(100) DEFAULT NULL,
  `year_of_birth_from` varchar(100) DEFAULT NULL,
  `year_of_birth_to` varchar(100) DEFAULT NULL,
  `date_of_death` varchar(100) DEFAULT NULL,
  `head_of_state` varchar(100) DEFAULT NULL,
  `incumbency` varchar(100) DEFAULT NULL,
  `date_begin_incumbent_position` varchar(100) DEFAULT NULL,
  `date_end_non_incumbent_position` varchar(100) DEFAULT NULL,
  `possible_relations` varchar(100) DEFAULT NULL,
  `anti_whom` varchar(100) DEFAULT NULL,
  `pro` varchar(100) DEFAULT NULL,
  `writings` varchar(100) DEFAULT NULL,
  `father` varchar(100) DEFAULT NULL,
  `mother` varchar(100) DEFAULT NULL,
  `son` varchar(100) DEFAULT NULL,
  `brothers` varchar(100) DEFAULT NULL,
  `cousins` varchar(100) DEFAULT NULL,
  `grandfather` varchar(100) DEFAULT NULL,
  `relations` varchar(100) DEFAULT NULL,
  `links_to_people` varchar(500) DEFAULT NULL,
  `head` varchar(100) DEFAULT NULL,
  `branch_of` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `capital_city` varchar(100) DEFAULT NULL,
  `region` varchar(100) DEFAULT NULL,
  `neighborhood_quarter` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `analyst_notes` varchar(500) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`,`docId`),
  KEY `caption_index` (`caption`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
/*!50100 PARTITION BY KEY (docId) */