The Publication module describes references to sources of knowledge. Usually these are published articles but can also include conferences, Web pages, and so on.
A documented provenance artefact - publications, documents, personal communication.
| F-Key | Name | Type | Description |
|---|---|---|---|
| pub_id | serial | PRIMARY KEY | |
| title | text | Descriptive general heading. |
|
| volumetitle | text | Title of part if one of a series. |
|
| volume | character varying(255) | ||
| series_name | character varying(255) | Full name of (journal) series. |
|
| issue | character varying(255) | ||
| pyear | character varying(255) | ||
| pages | character varying(255) | Page number range[s], e.g. 457--459, viii + 664pp, lv--lvii. |
|
| miniref | character varying(255) | ||
| uniquename | text | UNIQUE NOT NULL | |
| type_id | integer | NOT NULL The type of the publication (book, journal, poem, graffiti, etc). Uses pub cv. See FBcv for publication descriptor, or FBcv.obo |
|
| is_obsolete | boolean | DEFAULT false | |
| publisher | character varying(255) | ||
| pubplace | character varying(255) |
pub Structure
Tables referencing this one via Foreign Key Constraints:
Handle links to repositories, e.g. Pubmed, Biosis, zoorec, OCLC, Medline, ISSN, coden…
| F-Key | Name | Type | Description |
|---|---|---|---|
| pub_dbxref_id | serial | PRIMARY KEY | |
| pub | pub_id | integer | UNIQUE#1 NOT NULL |
| dbxref | dbxref_id | integer | UNIQUE#1 NOT NULL |
| is_current | boolean | NOT NULL DEFAULT true |
pub_dbxref Structure
Handle relationships between publications, e.g. when one publication makes others obsolete, when one publication contains errata with respect to other publication(s), or when one publication also appears in another pub.
| F-Key | Name | Type | Description |
|---|---|---|---|
| pub_relationship_id | serial | PRIMARY KEY | |
| pub | subject_id | integer | UNIQUE#1 NOT NULL |
| pub | object_id | integer | UNIQUE#1 NOT NULL |
| cvterm | type_id | integer | UNIQUE#1 NOT NULL |
pub_relationship Structure
An author for a publication. Note the denormalisation (hence lack of _ in table name) - this is deliberate as it is in general too hard to assign IDs to authors.
| F-Key | Name | Type | Description |
|---|---|---|---|
| pubauthor_id | serial | PRIMARY KEY | |
| pub_id | integer | UNIQUE#1 NOT NULL | |
| rank | integer | UNIQUE#1 NOT NULL Order of author in author list for this pub - order is important. |
|
| editor | boolean | DEFAULT false Indicates whether the author is an editor for linked publication. Note: this is a boolean field but does not follow the normal chado convention for naming booleans. |
|
| surname | character varying(100) | NOT NULL | |
| givennames | character varying(100) | First name, initials |
|
| suffix | character varying(100) | Jr., Sr., etc |
pubauthor Structure
Property-value pairs for a pub. Follows standard chado pattern.
| F-Key | Name | Type | Description |
|---|---|---|---|
| pubprop_id | serial | PRIMARY KEY | |
| pub | pub_id | integer | UNIQUE#1 NOT NULL |
| cvterm | type_id | integer | UNIQUE#1 NOT NULL |
| value | text | NOT NULL | |
| rank | integer | UNIQUE#1 |
pubprop Structure