   CONSTRAINT `fk_bmap_flowcell_to_study` FOREIGN KEY (`id_study_tmp`) REFERENCES `study` (`id_study_tmp`) ON DELETE RESTRICT ON UPDATE RESTRICT
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
+DROP TABLE IF EXISTS `cherrypicked_samples`;
+/*!50001 DROP VIEW IF EXISTS `cherrypicked_samples`*/;
+SET @saved_cs_client     = @@character_set_client;
+/*!50503 SET character_set_client = utf8mb4 */;
+/*!50001 CREATE VIEW `cherrypicked_samples` AS SELECT 
+ 1 AS `description`,
+ 1 AS `plate_barcode`,
+ 1 AS `phenotype`,
+ 1 AS `coordinate`,
+ 1 AS `created`,
+ 1 AS `event_type`*/;
+SET character_set_client = @saved_cs_client;
 DROP TABLE IF EXISTS `flgen_plate`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;

  CONSTRAINT `study_users_study_fk` FOREIGN KEY (`id_study_tmp`) REFERENCES `study` (`id_study_tmp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

  `filtered_positive` tinyint(1) DEFAULT NULL COMMENT 'Filtered positive result value',
  `filtered_positive_version` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Filtered positive version',
  `filtered_positive_timestamp` datetime DEFAULT NULL COMMENT 'Filtered positive timestamp',
  `lh_sample_uuid` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Sample uuid created in crawler',
  `lh_source_plate_uuid` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Source plate uuid created in crawler',
  `created_at` datetime DEFAULT NULL COMMENT 'When this record was inserted',
  `updated_at` datetime DEFAULT NULL COMMENT 'When this record was last updated',
  PRIMARY KEY (`id`),
