-- MySQL dump 9.08
--
-- Host: localhost    Database: tscsnp
---------------------------------------------------------
-- Server version	4.0.13-Max-log

--
-- Table structure for table 'TBL_SNP_TRACEALIGN'
--

CREATE TABLE TBL_SNP_TRACEALIGN (
  SNP_ID int(9) unsigned NOT NULL default '0',
  TRACE_ID int(12) unsigned NOT NULL default '0',
  TRACE_ALLELEPOS int(9) unsigned NOT NULL default '0',
  TRACE_REVERSED set('Y','N') NOT NULL default '',
  IS_GENBANK_ACCESSION set('Y','N') NOT NULL default '',
  ALIGN_NUM int(3) NOT NULL default '0',
  ALIGNMENT_TEXT text NOT NULL,
  QLTY_ID int(12) unsigned default NULL,
  GENBANK_VERSION int(12) unsigned default NULL,
  PRIMARY KEY  (SNP_ID,TRACE_ID),
  KEY ind_trace_id (TRACE_ID)
) TYPE=MyISAM;