Login | Datasets | Logout
 

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 VegBank Fields Here

Show field labels | Show database names

DB Table Name reference
Table Reference
Notes This table stores information about references cited within the database
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID reference_ID required serial PK no Primary key for the reference table.
Short Name shortName no varchar (250) n/a no The 'shortName' field provides a concise or abbreviated name that describes the resource that is being documented.
Full Text fulltext no text n/a no Full Text of the reference citation.
Reference Type referenceType no varchar (250) n/a closed Describes the type of reference this generic type is being used to represent. Examples: book, journal article, web page.
Title title no varchar (250) n/a no The formal title given to the work by its author or publisher. The 'title' field provides a description of the resource that is being documented that is long enough to differentiate it from other similar resources.
Title Superior titleSuperior no varchar (250) n/a no A second, higher order title where appropriate, which in the case of a reference to a chapter is the Book title, and in the case of a Conference Presentation is the Name of the Conference.
Publication Date pubDate no Date n/a no The 'pubDate' field represents the date that the resource was published. The format should be represented as: CCYY, which represents a 4 digit year, or as CCYY-MM-DD, which denotes the full year, month, and day. Note that month and day are optional components. Formats must conform to ISO 8601. For example: 1999-10-26
Access Date accessDate no Date n/a no The date the resource being referenced was accessed. This is useful if the resource is could be changed after formal publication, such as web sites or databases.
Conference Date conferenceDate no Date n/a no The date the conference was held.
Reference Journal referenceJournal_ID no Integer FK no Foreign key into the journal table to identify the journal of this reference.
Volume volume no varchar (250) n/a no The volume field is used to describe the volume of the journal in which the article appears.
Issue issue no varchar (250) n/a no The issue field is used to describe the issue of the journal in which the article appears.
Page Range pageRange no varchar (250) n/a no The page range field is used for the beginning and ending pages of the journal article that is being documented.
Total Pages totalPages no Integer n/a no The total pages field is used to describe the total number of pages in the book that is being described.
Publisher publisher no varchar (250) n/a no The organization that physically put together the report and publishes it.
Publication Place publicationPlace no varchar (250) n/a no The location at which the work was published. This is usually the name of the city in which the publishing house produced the work.
ISBN isbn no varchar (250) n/a no The ISBN, or International Standard Book Number that has been assigned to this literature resource.
Edition edition no varchar (250) n/a no The edition field is to document the edition of the generic reference type that is being described.
Number Of Volumes numberOfVolumes no Integer n/a no Number of volumes in a collection
Chapter Number chapterNumber no Integer n/a no The chapter number of the chapter of a book that is being described.
Report Number reportNumber no Integer n/a no The report number field is used to describe the unique identification number that has been issued by the report institution for the report being described.
Communication Type communicationType no varchar (250) n/a no The type of personal communication. Could be an email, letter, memo, transcript of conversation either hardcopy or online.
Degree degree no varchar (250) n/a no The degree field is used to describe the name or degree level for which the thesis was completed.
URL url no text n/a no A URL (Uniform Resource Locator) from which this resource can be downloaded or additional information can be obtained.
DOI doi no text n/a no A Digital Object Identifier - a digital identifier for any object of intellectual property. A DOI provides a means of persistently identifying a piece of intellectual property on a digital network and associating it with related current data. (www.doi.org)
Additional Information additionalInfo no text n/a no This field provides any information that is not characterized by the other resource metadata fields. Example: Copyright 2001, Robert Warner
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).