7f33fb42a1fb58a02a3f798e56332e5beac65133 max Sat Mar 17 13:21:09 2012 -0700 renaming all publications tracks tables to pubsXXXX diff --git src/hg/lib/pubsArticle.sql src/hg/lib/pubsArticle.sql new file mode 100644 index 0000000..d357b8e --- /dev/null +++ src/hg/lib/pubsArticle.sql @@ -0,0 +1,18 @@ +#Text to Genome project article data table +CREATE TABLE t2gArticle ( + articleId bigint not null, # internal article ID, created during download + displayId varchar(255) not null, # display ID shown on browser, format: <author><year><letters> + extId varchar(255) not null, # publisher ID e.g. PMCxxxx or doi or sciencedirect ID + pmid bigint not null, # PubmedID if available + citation varchar(2000) default null, # source journal citation + year int not null, # year of publication or 0 if not defined + title varchar(6000) default null, # article title + authors varchar(12000) default null, # author list for this article + abstract varchar(32000) not null, # article abstract + url varchar(1000) default null, # url to fulltext of article + dbs varchar(500) default null, # list of DBs with matches to this article + #Indices + PRIMARY KEY(articleId), + KEY displayIdx(displayId), + KEY extIdx(extId) +);