Difference between revisions of "Chado Publication Module"
m |
m |
||
Line 328: | Line 328: | ||
---- | ---- | ||
− | |||
− | |||
− | |||
− | |||
[[Category: Chado]] | [[Category: Chado]] | ||
− |
Revision as of 15:17, 5 April 2007
Contents
Introduction
This page or section needs to be edited. Please help by editing this page to add your revisions or additions.
Tables
Table: pub
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. | |
is_obsolete | boolean | DEFAULT false | |
publisher | character varying(255) | ||
pubplace | character varying(255) |
Tables referencing this one via Foreign Key Constraints:
Table: pub_dbxref
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_id | integer | UNIQUE#1 NOT NULL | |
dbxref_id | integer | UNIQUE#1 NOT NULL | |
is_current | boolean | NOT NULL DEFAULT true |
Table: pub_relationship
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 | |
subject_id | integer | UNIQUE#1 NOT NULL | |
object_id | integer | UNIQUE#1 NOT NULL | |
type_id | integer | UNIQUE#1 NOT NULL |
Table: pubauthor
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 |
Table: pubprop
Property-value pairs for a pub. Follows standard chado pattern.
F-Key | Name | Type | Description |
---|---|---|---|
pubprop_id | serial | PRIMARY KEY | |
pub_id | integer | UNIQUE#1 NOT NULL | |
type_id | integer | UNIQUE#1 NOT NULL | |
value | text | NOT NULL | |
rank | integer | UNIQUE#1 |