anchor.diff:    `sampled_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
     `anatomical_site` int(16) DEFAULT NULL,
     PRIMARY KEY (`id`),
  -  KEY `samplecollection_id` (`samplecollection_id`),
  -  KEY `parent_id` (`parent_id`),
  -  KEY `anatomical_site` (`anatomical_site`),
  +  KEY `FK_SAMPLES_samplecollection_id` (`samplecollection_id`),
  +  KEY `FK_SAMPLES_parent_id` (`parent_id`),
  +  KEY `FK_SAMPLES_anatomical_site` (`anatomical_site`),
  +  CONSTRAINT `FK_SAMPLES_anatomical_site` FOREIGN KEY (`anatomical_site`) REFERENCES `ANATOMICAL_PARTS` (`id`),
  +  CONSTRAINT `FK_SAMPLES_parent_id` FOREIGN KEY (`parent_id`) REFERENCES `SAMPLES` (`id`),
  +  CONSTRAINT `FK_SAMPLES_samplecollection_id` FOREIGN KEY (`samplecollection_id`) REFERENCES `SAMPLECOLLECTIONS` (`id`),
     CONSTRAINT `SAMPLES_ibfk_1` FOREIGN KEY (`samplecollection_id`) REFERENCES `SAMPLECOLLECTIONS` (`id`),
     CONSTRAINT `SAMPLES_ibfk_2` FOREIGN KEY (`parent_id`) REFERENCES `SAMPLES` (`id`),
     CONSTRAINT `SAMPLES_ibfk_3` FOREIGN KEY (`anatomical_site`) REFERENCES `ANATOMICAL_PARTS` (`id`)
  
positive.code: CREATE TABLE `STUDY_DESIGN` (
    `study_id` varchar(128) DEFAULT NULL,
    `design` varchar(128) DEFAULT NULL,
    KEY `study_id` (`study_id`),
    CONSTRAINT `STUDY_DESIGN_ibfk_1` FOREIGN KEY (`study_id`) REFERENCES `STUDY_META` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
negative.code:   `type` varchar(128) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `id` (`id`),
    KEY `FK_jobhistory_user` (`user`),
    KEY `FK_jobhistory_study` (`study`),
    CONSTRAINT `FK_jobhistory_study` FOREIGN KEY (`study`) REFERENCES `study` (`name`),
    CONSTRAINT `FK_jobhistory_user` FOREIGN KEY (`user`) REFERENCES `USERS` (`EMAIL`),
    CONSTRAINT `jobhistory_ibfk_2` FOREIGN KEY (`user`) REFERENCES `USERS` (`EMAIL`),
    CONSTRAINT `jobhistory_ibfk_3` FOREIGN KEY (`study`) REFERENCES `study` (`name`) ON DELETE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  