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

--
-- Table structure for table `evidence`
--

CREATE TABLE evidence (
  id int(11) NOT NULL auto_increment,
  code varchar(8) NOT NULL default '',
  association_id int(11) NOT NULL default '0',
  dbxref_id int(11) NOT NULL default '0',
  seq_acc varchar(255) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY association_id (association_id,dbxref_id,code),
  UNIQUE KEY ev0 (id),
  KEY ev1 (association_id),
  KEY ev2 (code),
  KEY ev3 (dbxref_id),
  KEY ev4 (association_id,code)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;