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

--
-- Table structure for table 'TBL_SNP_INFO'
--

CREATE TABLE TBL_SNP_INFO (
  SNP_ID int(9) NOT NULL default '0',
  SNP_USERID varchar(12) NOT NULL default '',
  SNP_LABID varchar(96) NOT NULL default '',
  SNP_NOTIFICATIONURL varchar(128) NOT NULL default '',
  SUBMITTER_ID int(3) NOT NULL default '0',
  SNP_SUBMITDATE date NOT NULL default '0000-00-00',
  SNP_ACKDATE date NOT NULL default '0000-00-00',
  SNP_CONFIDENCE int(3) NOT NULL default '0',
  SNP_CONFIRMED set('Y','N') NOT NULL default '',
  SNP_WITHDRAWN set('Y','N') NOT NULL default '',
  CLIQUE_ID int(9) default NULL,
  SNP_GENOMIC set('Y','N') NOT NULL default '',
  CLIQUE_POSITION int(6) default NULL,
  DBSNP_ID int(12) default NULL,
  SNP_REVISED char(1) default NULL,
  REFSNP_ID int(12) default NULL,
  variation varchar(15) default NULL,
  PRIMARY KEY  (SNP_ID),
  UNIQUE KEY DBSNP_ID (DBSNP_ID),
  UNIQUE KEY SNP_USERID (SNP_USERID),
  KEY REFSNP_ID (REFSNP_ID)
) TYPE=MyISAM;