Template:ChadoTable pub
From GMOD
This template is a Chado Table Template. It defines a single table from the Chado schema, and every Chado table has a template like this one. This template is automatically included in two places:
- The module page for the module the table is a part of. This is where updates and comments should be posted.
- The Chado Tables page, which lists all tables.
You can include this template anywhere you want to show the table description.
Table: | pub |
Module: | Publication |
A documented provenance artefact - publications, documents, personal communication.
FK | 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 | |
cvterm | type_id | integer | NOT NULL The type of the publication (book, journal, poem, graffiti, etc). Uses pub cv. |
is_obsolete | boolean | DEFAULT false | |
publisher | character varying(255) | ||
pubplace | character varying(255) |
Tables referencing pub via foreign key constraints:
- cell_line_cvterm
- cell_line_feature
- cell_line_library
- cell_line_pub
- cell_line_synonym
- cell_lineprop_pub
- expression_pub
- feature_cvterm
- feature_cvterm_pub
- feature_expression
- feature_pub
- feature_relationship_pub
- feature_relationshipprop_pub
- feature_synonym
- featureloc_pub
- featuremap_pub
- featureprop_pub
- library_cvterm
- library_pub
- library_synonym
- libraryprop_pub
- nd_experiment_pub
- phendesc
- phenotype_comparison
- phenotype_comparison_cvterm
- phenstatement
- phylonode_pub
- phylotree_pub
- project_pub
- protocol
- pub_dbxref
- pub_relationship
- pubauthor
- pubprop
- stock_cvterm
- stock_pub
- stock_relationship_cvterm
- stock_relationship_pub
- stockprop_pub
- study