CREATE TABLE `name_alternatives` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `watchListName` varchar(100) DEFAULT NULL,
  `userName` varchar(100) DEFAULT NULL,
  `personId` int(11) NOT NULL,
  `docId` int(11) NOT NULL,
  `personTable` text NOT NULL,
  `PersonName` varchar(100) DEFAULT NULL,
  `family_name` varchar(100) DEFAULT NULL,
  `given_name` varchar(100) DEFAULT NULL,
  `middle_name` varchar(100) DEFAULT NULL,
  `maiden_name` varchar(100) DEFAULT NULL,
  `hispanic_maternal_name` varchar(100) DEFAULT NULL,
  `son` varchar(100) DEFAULT NULL,
  `nisba` varchar(100) DEFAULT NULL,
  `father_patrimonyal_name` varchar(100) DEFAULT NULL,
  `grandfather_patrimonyal_name` varchar(100) DEFAULT NULL,
  `tribal_name` varchar(100) DEFAULT NULL,
  `unknown_name_role` varchar(100) DEFAULT NULL,
  `matronymic_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`,`personId`,`docId`),
  KEY `docId_Index` (`docId`),
  KEY `personId_Table_index` (`personId`,`personTable`(1)),
  KEY `family_name_index` (`family_name`),
  KEY `given_name_index` (`given_name`),
  KEY `son_index` (`son`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
/*!50100 PARTITION BY KEY (docId) */