-- updated 040423 DDH

-- Synonym: removed
-- Collector: removed
-- Latitude: removed
-- Longitude: removed
-- Avirulence: removed
-- Data_source: removed
-- Reaction_to_host_genes: removed
-- Reaction_to_host_germplasm: removed

create table isolate (
	id integer auto_increment primary key,
	name varchar(255),
	-- Species
	speciesid integer,
	-- Country
	country varchar(100)
) ENGINE=InnoDB;
create index name_index on isolate (name);
create index speciesid_index on isolate (speciesid);

create table isolatetype (
	id integer auto_increment primary key,
	isolateid integer,
	-- Type
	type varchar(100)
) ENGINE=InnoDB;
create index isolateid_index on isolatetype (isolateid);

create table isolateremark (
	id integer auto_increment primary key,
	isolateid integer,
	-- Characteristic, Note
	type varchar(50),
	remark text
) ENGINE=InnoDB;
create index isolateid_index on isolateremark (isolateid);

create table isolatereference (
	id integer auto_increment primary key,
	isolateid integer,
	-- Reference
	referenceid integer
) ENGINE=InnoDB;
create index isolateid_index on isolatereference (isolateid);
create index referenceid_index on isolatereference (referenceid);