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

141010

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)	referenceParty
Table	Reference Party
Field	Suffix
DB Field Name	suffix
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	A suffix or suffix abbreviation that follows a name. Examples: Jr., Senior, III, etc.

 

Table (DB Name)	referenceParty
Table	Reference Party
Field	Organization Name
DB Field Name	organizationName
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The responsible party field contains the full name of the organization that is associated with the resource. This field is intended to describe which institution or overall organization is associated with the resource being described. Note that this field, used in conjunction with 'individualName' and 'positionName' make up a single logical originator. Because of this, an originator with only the individualName of 'Joe Smith' is NOT the same as an originator with the name of 'Joe Smith' and the organizationName of 'NSF'. Also, the positionName should not be used in conjunction with individualName unless only that individual at that position would be considered an originator for the data package. If a positionName is used in conjunction with an organizationName, then that implies that any person who currently occupies said positionName at organizationName is the originator of the data package. Example(s): National Center for Ecological Analysis and Synthesis

 

Table (DB Name)	referenceParty
Table	Reference Party
Field	Current Name
DB Field Name	currentParty_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	referenceParty.referenceParty_ID
List?	no
Notes	recursive FK
Definition	Recursive Foreign key into the referenceParty table to indicate the current name of the party.

 

Table (DB Name)	referenceParty
Table	Reference Party
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)	referenceJournal
Table	Reference Journal
Field	ID
DB Field Name	referenceJournal_ID
Req'd?	required
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Primary key for the referenceJournal table.

 

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

 

Table (DB Name)	referenceJournal
Table	Reference Journal
Field	ISSN
DB Field Name	issn
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The ISSN, or International Standard Serial Number that has been assigned to this literature resource. Example(s): ISSN 1234-5679

 

Table (DB Name)	referenceJournal
Table	Reference Journal
Field	Abbreviation
DB Field Name	abbreviation
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Standard abbreviation or shorter name of the journal. Example(s): Can. J. Bot./Rev. Can. Bot., JAMA

 

Table (DB Name)	referenceJournal
Table	Reference Journal
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)	classContributor
Table	Classification Contributor
Field	ID
DB Field Name	CLASSCONTRIBUTOR_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for the classContributor table.
Definition	Database generated identifier assigned to each unique contribution to the classification of a plot observation.