| 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).
|
unhighlight
highlight