-- updated 040423 DDH

-- Gene: geneset->gene
-- Abbreviation: removed
-- Character_affected: removed

create table geneset (
	id integer auto_increment primary key,
	name varchar(255),
	-- Gene_class
	geneclassid integer
) ENGINE=InnoDB;
create index name_index on geneset (name);
create index geneclassid_index on geneset (geneclassid);

create table genesetreference (
	id integer auto_increment primary key,
	genesetid integer,
	-- Reference
	referenceid integer
) ENGINE=InnoDB;
create index genesetid_index on genesetreference (genesetid);
create index referenceid_index on genesetreference (referenceid);

create table genesetremark (
	id integer auto_increment primary key,
	genesetid integer,
	-- Comment
	type varchar(50),
	remark text
) ENGINE=InnoDB;
create index genesetid_index on genesetremark (genesetid);

create table genesetwgcreference (
	id integer auto_increment primary key,
	genesetid integer,
	-- Numbered_reference
	number integer,
	referenceid integer
) ENGINE=InnoDB;
create index genesetid_index on genesetwgcreference (genesetid);
create index referenceid_index on genesetwgcreference (referenceid);