René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"renamed foreign key table definition constraint issue","articleBody":"defining a renamed foreign key reference to a partial key defined in:\r\n```@schema\r\nclass Animal(dj.Manual):\r\n    definition = \"\"\"\r\n    animal_id : char(16)\r\n    datasource_id=0: int\r\n    ---\r\n    animal_species: varchar(16)\r\n    animal_name: varchar(128)\r\n    animal_sex: ENUM('M', 'F', 'U')\r\n    animal_dob=NULL: date\r\n    -\u003e AnimalColor\r\n    \"\"\"\r\n```\r\nvia:\r\n```\r\n@schema\r\nclass Dam(dj.Manual):\r\n    definition = \"\"\"\r\n    -\u003e Animal\r\n    (dam_id) -\u003e Animal(animal_id)\r\n    \"\"\"\r\n```\r\nyields:\r\n```\r\nCREATE TABLE IF NOT EXISTS `tutorial_mlims_prod_ephys`.`dam` ( `animal_id` char(16) NOT NULL COMMENT \"\", `datasource_id` int NOT NULL COMMENT \"\", `dam_id` int NOT NULL COMMENT \"\", PRIMARY KEY (`animal_id`,`datasource_id`,`dam_id`), FOREIGN KEY (`animal_id`,`datasource_id`) REFERENCES `tutorial_mlims_prod_ephys`.`animal` (`animal_id`,`datasource_id`) ON UPDATE CASCADE ON DELETE RESTRICT, FOREIGN KEY (`datasource_id`,`dam_id`) REFERENCES `tutorial_mlims_prod_ephys`.`animal` (`animal_id`,`datasource_id`) ON UPDATE CASCADE ON DELETE RESTRICT ) ENGINE=InnoDB, COMMENT \"\";\r\n```\r\nand therefore this:\r\n```pymysql.err.IntegrityError: (1215, 'Cannot add foreign key constraint')\r\n```\r\n\r\n#517 code resolves issue.\r\n","author":{"url":"https://github.com/ixcat","@type":"Person","name":"ixcat"},"datePublished":"2018-11-14T02:01:04.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/518/datajoint-python/issues/518"}