Template:ChadoTable pub

From GMOD
Jump to: navigation, search

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:

  1. The module page for the module the table is a part of. This is where updates and comments should be posted.
  2. 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.

pub columns
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: