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

--
-- Table structure for table `association`
--

CREATE TABLE association (
  id int(11) NOT NULL auto_increment,
  term_id int(11) NOT NULL default '0',
  gene_product_id int(11) NOT NULL default '0',
  is_not int(11) default NULL,
  role_group int(11) default NULL,
  assocdate int(11) default NULL,
  source_db_id int(11) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY a0 (id),
  KEY source_db_id (source_db_id),
  KEY a1 (term_id),
  KEY a2 (gene_product_id),
  KEY a3 (term_id,gene_product_id),
  KEY a4 (id,term_id,gene_product_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;