PubMed
- PubMed comes from the National Center for Biotechnology Information, and is described by its creators thusly:
- PubMed, a service of the National Library of Medicine, includes over 14 million citations for biomedical articles back to the 1950's. These citations are from MEDLINE and additional life science journals. PubMed includes links to many sites providing full text articles and other related resources.
- [online; accessed 10/21/03; http://www.ncbi.nlm.nih.gov/PubMed/
Schema in CLSD
PubMed nicknames are found under the 'ncbi' schema. These nicknames make use of the Entrez wrapper to make direct queries against the NCBI's database.PubMed is accessed via the Entrez wrapper and its nicknames require a special syntax.
| Table | Field | Type | Description | Q | F |
|---|---|---|---|---|---|
| pmarticles | PMID | VARCHAR(10) | UID | Y | |
| MEDLINEID | VARCHAR(10) | UID | Y | ||
| OWNER | VARCHAR(8) | ||||
| STATUS | VARCHAR(32) | ||||
| DATECREATED | DATE | ||||
| DATECOMPLETED | DATE | ||||
| DATEREVISED | DATE | ||||
| ARTICLETITLE | VARCHAR(250) | TI | |||
| PAGINATION | VARCHAR(250) | ||||
| ABSTRACT | VARCHAR(32000) | TIAB | |||
| AFFILIATION | VARCHAR(250) | AD | |||
| AUTHORLIST | VARCHAR(3200) | AU | |||
| LANGUAGELIST | VARCHAR(250) | LA | |||
| PUBLICATIONTYPELIST | VARCHAR(250) | PT | |||
| VERNACULARTITLE | VARCHAR(250) | ||||
| DATEOFELECTRONICPUBLICATION | VARCHAR(32) | ||||
| COUNTRY | VARCHAR(128) | ||||
| MEDLINETA | VARCHAR(250) | TA | |||
| NLMUNIQUEID | VARCHAR(128) | ||||
| GENESYMBOLLIST | VARCHAR(250) | ||||
| NUMBEROFREFERENCES | INTEGER | ||||
| PERSONALNAMESUBJECTLIST | VARCHAR(250) | PS | |||
| KEYWORDLIST | VARCHAR(250) | ||||
| SPACEFLIGHTMISSIONLIST | VARCHAR(250) | ||||
| INVESTIGATORLIST | VARCHAR(250) | ||||
| PUBLICATIONSTATUS | VARCHAR(32) | ||||
| PROVIDERID | VARCHAR(32) | ||||
| CITATIONSUBSETLIST | VARCHAR(250) | SB | |||
| ALLFIELDS | VARCHAR(1) | ALL | |||
| TEXTWORDS | VARCHAR(1) | TW | |||
| PUBDATE | DATE | DP | |||
| PUBDATESTRING | VARCHAR(32) | DP | |||
| TITLE | VARCHAR(250) | TA | |||
| JOURNAL_ISSN | CHARACTER(9) | TA | |||
| JOURNAL_VOLUME | VARCHAR(10) | VI | |||
| JOURNAL_ISSUE | VARCHAR(10) | IP | |||
| JOURNAL_CODEN | VARCHAR(32) | ||||
| JOURNAL_ISOABBREVIATION | VARCHAR(32) | ||||
| BOOK_PUBLISHER | VARCHAR(128) | ||||
| BOOK_AUTHORS | VARCHAR(250) | ||||
| BOOK_COLLECTIONTITLE | VARCHAR(128) | ||||
| BOOK_VOLUME | VARCHAR(10) | ||||
| pmaccession | PMID | VARCHAR(10) | |||
| DATABANKNAME | VARCHAR(250) | SI | |||
| ACCESSION | VARCHAR(32) | SI | |||
| pmchemical | PMID | VARCHAR(10) | |||
| NAMEOFSUBSTANCE | VARCHAR(128) | NM | |||
| REGISTRYNUMBER | VARCHAR(32) | RN | |||
| CASREGISTRY | CHARACTER(1) | ||||
| pmmesh | PMID | VARCHAR(10) | ID | ||
| DESCRIPTORORNAME | VARCHAR(128) | MN/MAJR | |||
| DESCRIPTORISMAJOR | CHARACTER(1) | ||||
| QUALIFIERORSUBHEAD | VARCHAR(128) | SH | |||
| QSISMAJOR | CHARACTER(1) | ||||
| pmcomments | PMID | VARCHAR(10) | |||
| REFSOURCE | VARCHAR(128) | ||||
| TYPE | VARCHAR(32) | ||||
| NOTE | VARCHAR(3200) | ||||
| pmarticleid | PMID | VARCHAR(10) | |||
| ARTICLEID | VARCHAR(32) | ||||
| IDTYPE | VARCHAR(32) | ||||
| pmurl | PMID | VARCHAR(10) | |||
| URL | VARCHAR(250) | ||||
| LANGUAGE | CHARACTER(2) | ||||
| TYPE | CHARACTER(1) |
