src/hg/lib/t2gArticle.sql 1.2
1.2 2010/05/26 18:23:29 hiram
new version now with seqIds in t2g.sql
Index: src/hg/lib/t2gArticle.sql
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/lib/t2gArticle.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -b -B -U 4 -r1.1 -r1.2
--- src/hg/lib/t2gArticle.sql 20 May 2010 18:29:08 -0000 1.1
+++ src/hg/lib/t2gArticle.sql 26 May 2010 18:23:29 -0000 1.2
@@ -1,14 +1,14 @@
#Text to Genome project article data table
CREATE TABLE t2gArticle (
- pmcId bigint not null, # PMC ID
- displayId varchar(255) not null, # display ID
+ pmcId bigint not null, # PubMedCentral ID
+ displayId varchar(255) not null, # display ID shown on browser
authors varchar(6000) default null, # author list for this article
title varchar(2000) default null, # article title
journal varchar(1000) default null, # source journal
year varchar(255) default null, # publication year
pages varchar(255) default null, # publication pages
- pmid varchar(255) default null, # PM ID
+ pmid varchar(255) default null, # Pubmed ID
abstract blob not null, # article abstract
#Indices
PRIMARY KEY(pmcId),
KEY displayIdx(displayId)