 
 ALTER TABLE "Experiment" DROP COLUMN "Experiment Description";
 ALTER TABLE "Experiment" DROP COLUMN "Tags";
+ALTER TABLE "Experiment" DROP CONSTRAINT "Experiment_Experiment Type_fkey";
+ALTER TABLE "Experiment" ADD CONSTRAINT "Experiment_Experiment Type_fkey" FOREIGN KEY ("Experiment Type") REFERENCES experiment_type (term);
 
 ALTER TABLE "Slide" DROP COLUMN "Rev.";
 ALTER TABLE "Slide" DROP COLUMN "Tags";

DROP TABLE "Probe";
DROP TABLE "Species";
DROP TABLE "Tissue";

DELETE FROM _ermrest.model_column_annotation;
DELETE FROM _ermrest.model_key_annotation;

('Microscopy', 'Scan', 'tag:isrd.isi.edu,2016:visible-columns', 
'{
	"compact": ["Thumbnail", "accession_number", "species", "tissue", "gene", "age", "submitter", "Acquisition Date"],
	"filter": ["Thumbnail", "accession_number", "species", "tissue", "gene", "age", "submitter", "Acquisition Date"],
	"detailed": ["Thumbnail", "HTTP URL", "Acquisition Date", "submitter", "species", "tissue", "gene", "gender", "age", "Image Size", "Objective", "Channels", "Channel Name", "Contrast Method", "Light Source Intensity", "Exposure Time", "resolution", "Scaling (per pixel)"]
}'),

('Microscopy', 'Specimen', 'description', '{"sortedBy": "Section Date", "top_columns": ["ID", "Species", "Tissue", "Age Value", "Age Unit", "Gene", "Initials", "Section Date"]}'),
('Microscopy', 'Specimen', 'tag:isrd.isi.edu,2016:visible-columns', 
'{
	"detailed": ["ID", "Species", "Tissue", "Age", "Genes", "Initials", "Section Date", "Comment"],
	"filter": ["ID", "Species", "Tissue", "Age", "Genes", "Initials", "Section Date", "Comment"]
}'),

('Microscopy', 'Experiment', 'description', '{"sortedBy": "Experiment Date", "top_columns": ["ID", "Initials", "Experiment Date", "Experiment Type", "Probe", "Comment"]}'),
('Microscopy', 'Experiment', 'tag:isrd.isi.edu,2016:visible-columns', 
'{
	"detailed": ["ID", "Initials", "Experiment Date", "Experiment Type", "Probe", "Comment"],
	"filter": ["ID", "Initials", "Experiment Date", "Experiment Type", "Probe", "Comment"]
}')

;
