-- updated 040423 DDH

-- Orthologous_gene_set: geneclass->geneset
-- QTL: geneclass->qtlgeneclass->qtl
-- Gene: geneclass->gene
-- Locus: geneclass->gene->genelocus->locus
-- Gene_product: removed

-- Sequence:

create table geneclass (
	id integer auto_increment primary key,
	name varchar(255),
	-- URL
	url varchar(255),
	urldescription varchar(255),
	-- Abbreviation
	abbreviation varchar(25)
) ENGINE=InnoDB;
create index name_index on geneclass (name);

create table geneclassreference (
	id integer auto_increment primary key,
	geneclassid integer,
	-- Reference
	referenceid integer
) ENGINE=InnoDB;
create index geneclassid_index on geneclassreference (geneclassid);
create index referenceid_index on geneclassreference (referenceid);

create table geneclassseealso (
	id integer auto_increment primary key,
	geneclassid integer,
	-- See_also
	seealso_geneclassid integer
) ENGINE=InnoDB;
create index geneclassid_index on geneclassseealso (geneclassid);
create index seealso_geneclassid_index on geneclassseealso (seealso_geneclassid);

create table geneclasstraitaffected (
	id integer auto_increment primary key,
	geneclassid integer,
	-- Character_affected
	traitid integer
) ENGINE=InnoDB;
create index geneclassid_index on geneclasstraitaffected (geneclassid);
create index traitid_index on geneclasstraitaffected (traitid);

create table geneclasspathology (
	id integer auto_increment primary key,
	geneclassid integer,
	-- Pathology
	pathologyid integer
) ENGINE=InnoDB;
create index geneclassid_index on geneclasspathology (geneclassid);
create index pathologyid_index on geneclasspathology (pathologyid);

create table geneclassclone (
	id integer auto_increment primary key,
	geneclassid integer,
	-- Clone
	probeid integer
) ENGINE=InnoDB;
create index geneclassid_index on geneclassclone (geneclassid);
create index probeid_index on geneclassclone (probeid);

create table geneclassremark (
	id integer auto_increment primary key,
	geneclassid integer,
	-- Comment
	type varchar(50),
	remark text
) ENGINE=InnoDB;
create index geneclassid_index on geneclassremark (geneclassid);

create table geneclasswgcreference (
	id integer auto_increment primary key,
	geneclassid integer,
	-- Numbered_reference
	number integer,
	referenceid integer
) ENGINE=InnoDB;
create index geneclassid_index on geneclasswgcreference (geneclassid);
create index referenceid_index on geneclasswgcreference (referenceid);