Difference between revisions of "Paper Tables in Postgres"
From WormBaseWiki
Jump to navigationJump to search (Created page with '=List of Paper Tables in Postgres (Alphabetical= ==pap_affiliation== This table contains the affiliation (location) of one or more authors of the paper, meeting abstract, or ga…') |
|||
Line 1: | Line 1: | ||
− | =List of Paper Tables in Postgres (Alphabetical= | + | =List of Paper Tables in Postgres (Alphabetical)= |
==pap_affiliation== | ==pap_affiliation== | ||
− | + | Contains the affiliation (location) of one or more authors of the paper, meeting abstract, or gazette article | |
For papers, this table mostly contains legacy information that was imported from the CGC when WormBase starting curating paper data, as PubMed currently does not curate all author affiliations for papers. | For papers, this table mostly contains legacy information that was imported from the CGC when WormBase starting curating paper data, as PubMed currently does not curate all author affiliations for papers. | ||
For meeting abstracts and gazette articles, this table contains the full list of affiliations, but the affiliations are not mapped to specific individuals. | For meeting abstracts and gazette articles, this table contains the full list of affiliations, but the affiliations are not mapped to specific individuals. | ||
+ | |||
+ | ==pap_author== | ||
+ | |||
+ | Contains the author_id | ||
+ | |||
+ | ==pap_author_index== | ||
+ | |||
+ | |||
+ | author_id as joinkey | ||
+ | |||
+ | ==pap_author_possible== | ||
+ | |||
+ | |||
+ | author_id as joinkey | ||
+ | |||
+ | ==pap_author_sent== | ||
+ | |||
+ | author_id as joinkey | ||
+ | |||
+ | ==pap_author_verified== | ||
+ | |||
+ | author_id as joinkey |
Revision as of 22:45, 30 April 2011
Contents
List of Paper Tables in Postgres (Alphabetical)
pap_affiliation
Contains the affiliation (location) of one or more authors of the paper, meeting abstract, or gazette article
For papers, this table mostly contains legacy information that was imported from the CGC when WormBase starting curating paper data, as PubMed currently does not curate all author affiliations for papers.
For meeting abstracts and gazette articles, this table contains the full list of affiliations, but the affiliations are not mapped to specific individuals.
pap_author
Contains the author_id
pap_author_index
author_id as joinkey
pap_author_possible
author_id as joinkey
pap_author_sent
author_id as joinkey
pap_author_verified
author_id as joinkey