anchor.diff:    `study_id` varchar(128) DEFAULT NULL,
     `design` varchar(128) DEFAULT NULL,
     KEY `FK_STUDY_DESIGN_study_id` (`study_id`),
  -  CONSTRAINT `FK_STUDY_DESIGN_study_id` FOREIGN KEY (`study_id`) REFERENCES `STUDY_META` (`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 */;
  
positive.code:   `sampled_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `anatomical_site` int(16) DEFAULT NULL,
    PRIMARY KEY (`id`),
    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`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  
negative.code:   UNIQUE KEY `acronym` (`acronym`),
    KEY `FK_SAMPLECOLLECTIONS_study` (`study`),
    KEY `FK_SAMPLECOLLECTIONS_contact` (`contact`),
    CONSTRAINT `SAMPLECOLLECTIONS_ibfk_1` FOREIGN KEY (`contact`) REFERENCES `USERS` (`EMAIL`),
    CONSTRAINT `SAMPLECOLLECTIONS_ibfk_2` FOREIGN KEY (`study`) REFERENCES `study` (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  