TABLES
6
VIEWS
0
COLUMNS
37
Constraints
11
chado.pub Tables
| Table / View | Referenced | Foreign Keys | Columns | Type | Comments |
|---|---|---|---|---|---|
| pub | 47 | 1 | 14 | Table | A documented provenance artefact - publications, documents, personal communication. |
| pub_dbxref | 0 | 2 | 4 | Table | Handle links to repositories, e.g. Pubmed, Biosis, zoorec, OCLC, Medline, ISSN, coden... |
| pub_relationship | 0 | 3 | 4 | Table | 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. |
| pubauthor | 1 | 1 | 7 | Table | 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. |
| pubauthor_contact | 0 | 2 | 3 | Table | An author on a publication may have a corresponding entry in the contact table and this table can link the two. |
| pubprop | 0 | 2 | 5 | Table | Property-value pairs for a pub. Follows standard chado pattern. |