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

101010

VegBank Data Dictionary: Field Details

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

Search VegBank Tables Here

Table (DB Name)	reference
Table	Reference
Field	Full Text
DB Field Name	fulltext
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Full Text of the reference citation.

 

Table (DB Name)	reference
Table	Reference
Field	Reference Type
DB Field Name	referenceType
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	closed
Notes	n/a
Definition	Describes the type of reference this generic type is being used to represent. Examples: book, journal article, web page.
closed List of Values: Value Description Sorting Article   10 Book   20 Chapter   30 EditedBook   40 Manuscript   50 Report   60 Thesis   70 ConferenceProceedings   80 PersonalCommunication   90 Presentation   100 Website   110 Generic   120

 

Table (DB Name)	reference
Table	Reference
Field	Title
DB Field Name	title
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	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.

 

Table (DB Name)	reference
Table	Reference
Field	Title Superior
DB Field Name	titleSuperior
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	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.

 

Table (DB Name)	reference
Table	Reference
Field	Publication Date
DB Field Name	pubDate
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	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

 

Table (DB Name)	reference
Table	Reference
Field	Access Date
DB Field Name	accessDate
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	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.

 

Table (DB Name)	reference
Table	Reference
Field	Conference Date
DB Field Name	conferenceDate
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The date the conference was held.

 

Table (DB Name)	reference
Table	Reference
Field	Reference Journal
DB Field Name	referenceJournal_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	referenceJournal.referenceJournal_ID
List?	no
Notes	n/a
Definition	Foreign key into the journal table to identify the journal of this reference.

 

Table (DB Name)	reference
Table	Reference
Field	Volume
DB Field Name	volume
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The volume field is used to describe the volume of the journal in which the article appears.

 

Table (DB Name)	reference
Table	Reference
Field	Issue
DB Field Name	issue
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The issue field is used to describe the issue of the journal in which the article appears.