-- MySQL dump 8.23
--
-- Host: localhost    Database: PO_0305
---------------------------------------------------------
-- Server version	4.1.7-standard-log

--
-- Table structure for table `gene_product`
--

CREATE TABLE gene_product (
  id int(11) NOT NULL auto_increment,
  symbol varchar(128) NOT NULL default '',
  dbxref_id int(11) NOT NULL default '0',
  species_id int(11) default NULL,
  secondary_species_id int(11) default NULL,
  type_id int(11) default NULL,
  full_name text,
  PRIMARY KEY  (id),
  UNIQUE KEY dbxref_id (dbxref_id),
  UNIQUE KEY g0 (id),
  KEY type_id (type_id),
  KEY g1 (symbol),
  KEY g2 (dbxref_id),
  KEY g3 (species_id),
  KEY g4 (id,species_id),
  KEY g5 (dbxref_id,species_id),
  KEY g6 (id,dbxref_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
