 
 ) COLLATE=utf8_general_ci ENGINE=MyISAM;
 
+
+DROP TABLE IF EXISTS biological_model_strain;
 CREATE TABLE biological_model_strain (
-
 	biological_model_id       INT(10) UNSIGNED NOT NULL,
 	strain_acc                VARCHAR(20) NOT NULL,
 	strain_db_id              INT(10) NOT NULL,

 * deleting data from this table
 * missing: tells if there was no data for this observation.
 */
CREATE TABLE observation (

	id                         INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	db_id                      INT(10) UNSIGNED NOT NULL,
	biological_sample_id       INT(10) UNSIGNED NULL,


) COLLATE=utf8_general_ci ENGINE=MyISAM;


/**
 * Links multiple observations to experiment
 */
DROP TABLE IF EXISTS experiment_observation;
CREATE TABLE experiment_observation (
	experiment_id              INT(10) UNSIGNED NOT NULL,
	observation_id             INT(10) UNSIGNED NOT NULL,
