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

--
-- Table structure for table 'tbl_genotype'
--

CREATE TABLE tbl_genotype (
  DBSNP_ID int(11) NOT NULL default '0',
  SNP_ID int(11) default NULL,
  INSTITUTE_CODE varchar(32) NOT NULL default '',
  PERSON_ID varchar(32) NOT NULL default '',
  ALLELE_1 char(1) default NULL,
  ALLELE_2 char(1) default NULL,
  protocol varchar(64) default NULL,
  panel_code varchar(50) default NULL,
  KEY DBSNP_ID_2 (DBSNP_ID,INSTITUTE_CODE,protocol),
  KEY PERSON_ID (PERSON_ID),
  KEY INSTITUTE_CODE (INSTITUTE_CODE,panel_code),
  KEY INSTITUTE_CODE_2 (INSTITUTE_CODE,PERSON_ID,SNP_ID)
) TYPE=MyISAM;