# MySQL dump 7.1
#
# Host: localhost    Database: hg5
#--------------------------------------------------------
# Server version	3.22.32

#
# Table structure for table 'knownMore'
#
CREATE TABLE knownMore (
  name varchar(255) DEFAULT '' NOT NULL,
  transId varchar(255) DEFAULT '' NOT NULL,
  geneId varchar(255) DEFAULT '' NOT NULL,
  gbGeneName int(10) unsigned DEFAULT '0' NOT NULL,
  gbProductName int(10) unsigned DEFAULT '0' NOT NULL,
  gbProteinAcc varchar(255) DEFAULT '' NOT NULL,
  gbNgi varchar(255) DEFAULT '' NOT NULL,
  gbPgi varchar(255) DEFAULT '' NOT NULL,
  omimId int(10) unsigned DEFAULT '0' NOT NULL,
  omimName varchar(255) DEFAULT '' NOT NULL,
  hugoId int(10) unsigned DEFAULT '0' NOT NULL,
  hugoSymbol varchar(255) DEFAULT '' NOT NULL,
  hugoName varchar(255) DEFAULT '' NOT NULL,
  hugoMap varchar(255) DEFAULT '' NOT NULL,
  pmId1 int(10) unsigned DEFAULT '0' NOT NULL,
  pmId2 int(10) unsigned DEFAULT '0' NOT NULL,
  refSeqAcc varchar(255) DEFAULT '' NOT NULL,
  aliases varchar(255) DEFAULT '' NOT NULL,
  locusLinkId int(10) unsigned DEFAULT '0' NOT NULL,
  gdbId varchar(255) DEFAULT '' NOT NULL,
  KEY name (name(24)),
  PRIMARY KEY (transId(24)),
  KEY omimId (omimId),
  KEY hugoId (hugoId),
  KEY hugoSymbol (hugoSymbol(16)),
  KEY refSeqAcc (refSeqAcc(16))
);
