CREATE TABLE `inter_entity_relationship` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `docId` int(11) NOT NULL,
  `relationship` text,
  `relationship_url` text,
  `relationship_text` text,
  `subject` varchar(100) DEFAULT NULL,
  `subject_url` text,
  `subject_text` text,
  `subject_id` int(11) DEFAULT NULL,
  `subject_table` text,
  `relation_type` text,
  `object` varchar(100) DEFAULT NULL,
  `object_url` text,
  `object_text` text,
  `object_id` int(11) DEFAULT NULL,
  `object_table` text,
  PRIMARY KEY (`id`,`docId`),
  KEY `docId_Index` (`docId`),
  KEY `object_index` (`object`),
  KEY `subject_index` (`subject`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
/*!50100 PARTITION BY KEY (docId) */