Login | Datasets | Logout
Jump to... Home PLOT search PLANT search COMMUNITY search Simple search Manage datasets Tutorial About FAQ ------- Site map VegBranch Data dictionary ERD

detaildba_tabledescriptionreferencejournalwhere_tablenamereferenceJournal

VegBank Data Dictionary: Tables

Search for a VegBank Table (enter a word, field name, etc.):    <<Hide search Match any word Match whole words only Search for VegBank Table >>

Search VegBank Fields Here

Show field labels | Show database names

DB Table Name	referenceJournal
Table	Reference Journal
Notes	This table stores information about journals used as part of a reference.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition ID referenceJournal_ID required serial PK no Primary key for the referenceJournal table. Journal journal required varchar (250) n/a no The name of the journal, magazine, newspaper, zine, etc... in which the article was published. Example(s): Ecology, New York Times, Harper's, Canadian Journal of Botany/Revue Canadienne de Botanique ,The Journal of the American Medical Association ISSN issn no varchar (250) n/a no The ISSN, or International Standard Serial Number that has been assigned to this literature resource. Example(s): ISSN 1234-5679 Abbreviation abbreviation no varchar (250) n/a no Standard abbreviation or shorter name of the journal. Example(s): Can. J. Bot./Rev. Can. Bot., JAMA Accession Code accessionCode no varchar (100) n/a no Code that uniquely references this record, allowing reference to this record for this version of this database. Better than a primary key, which is automatically generated by a database and not globally unique. VegBank Accession codes are only generated by VegBank, and therefore data integrity can be guaranteed, unlike with a primary key (number).