 
 ALTER TABLE anatomy OWNER TO ermrestddl;
 
+INSERT INTO anatomy(code,term) VALUES
+('Kidney', 'Kidney'),
+('Bone', 'Bone'),
+('Neural Tube', 'Neural Tube'),
+('Other', 'Other'),
+('Lung', 'Lung');
+
 CREATE TABLE annotation_type (
     id serial NOT NULL PRIMARY KEY,
     superclass_id text REFERENCES annotation_type(code),



ALTER TABLE annotation_type OWNER TO ermrestddl;

CREATE TABLE annotation (
    id serial NOT NULL PRIMARY KEY,

	"detailed": ["ID", "Initials", "Experiment Date", "Experiment Type", "Probe", "Probes", "Comment", "Number of Slides", "Number of Scans"],
	"compact": ["ID", "Initials", "Experiment Date", "Experiment Type", "Probe", "Probes", "Comment", "Number of Slides", "Number of Scans"],
	"entry": ["Initials", "Experiment Date", "Experiment Type", "Probe", "Comment"]
}'),

('Microscopy', 'specimen_gene', 'tag:isrd.isi.edu,2016:table-display', 
'{
	"compact": {"row_markdown_pattern":"**{{Gene ID}}**{.vocab}","separator_markdown":" "}
}')


;

