Schema Version: 1.3 Module: chado

pub


Description

A documented provenance artefact - publications, documents, personal communication.

Columns

Column Type Size Foreign Key Nullable Default Comments
pub_id bigserial 19
nextval('pub.pub_pub_id_seq'::regclass)
title text 2147483647
√ null

Descriptive general heading.
volumetitle text 2147483647
√ null

Title of part if one of a series.
volume varchar 255
√ null
series_name varchar 255
√ null

Full name of (journal) series.
issue varchar 255
√ null
pyear varchar 255
√ null
pages varchar 255
√ null

Page number ranges, e.g. 457--459, viii + 664pp, lv--lvii.
miniref varchar 255
√ null
uniquename text 2147483647
null
type_id int8 19
cvterm.cvterm_id pub_type_id_fkey C
null

The type of the publication (book, journal, poem, graffiti, etc). Uses pub cv.
is_obsolete bool 1
√ false
publisher varchar 255
√ null
pubplace varchar 255
√ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
pub_pkey Primary key Asc pub_id
pub_c1 Must be unique Asc uniquename
pub_idx1 Performance Asc type_id

Relationships

The following entity relationship (ER) diagram shows the relationships involving the pub table.

These relationships often cross chado module boundries, in which case the table name will be prefixed with the module it is in. When querying these tables do not include the module name, as all chado tables are contained within the same schema.

Show relationships within degrees of separation