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

121010

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	Degree
DB Field Name	degree
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The degree field is used to describe the name or degree level for which the thesis was completed.

 

Table (DB Name)	reference
Table	Reference
Field	URL
DB Field Name	url
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	A URL (Uniform Resource Locator) from which this resource can be downloaded or additional information can be obtained.

 

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

 

Table (DB Name)	reference
Table	Reference
Field	Additional Information
DB Field Name	additionalInfo
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This field provides any information that is not characterized by the other resource metadata fields. Example: Copyright 2001, Robert Warner

 

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

 

Table (DB Name)	referenceAltIdent
Table	Reference Alternate Identifier
Field	ID
DB Field Name	referenceAltIdent_ID
Req'd?	required
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Primary key for the referenceAltIdent table.

 

Table (DB Name)	referenceAltIdent
Table	Reference Alternate Identifier
Field	Reference
DB Field Name	reference_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	reference.reference_ID
List?	no
Notes	n/a
Definition	Foreign key into the reference table to indicate which reference is referenced by this alternate identifier.

 

Table (DB Name)	referenceAltIdent
Table	Reference Alternate Identifier
Field	System
DB Field Name	system
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The data management system within which an identifier is in scope and therefore unique. This is typically a URL (Uniform Resource Locator) that indicates a data management system. All identifiers that share a system must be unique. In other words, if the same identifier is used in two locations with identical systems, then by definition the objects at which they point are in fact the same object. Example(s): http://metacat.somewhere.org/svc/mc/

 

Table (DB Name)	referenceAltIdent
Table	Reference Alternate Identifier
Field	Identifier
DB Field Name	identifier
Req'd?	required
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	An additional, secondary identifier for this entity. The primary identifier belongs in the reference table, but additional identifiers that are used to label this entity, possibly from different data management systems, can be listed here. Example: VCR3465

 

Table (DB Name)	referenceContributor
Table	Reference Contributor
Field	ID
DB Field Name	referenceContributor_ID
Req'd?	required
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Primary key for the referenceContributor table.