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

41010

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)	commUsage
Table	Community Usage
Field	Community Name
DB Field Name	COMMNAME_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	commName.COMMNAME_ID
List?	no
Notes	n/a
Definition	This field is the foreign key into the commName table.

 

Table (DB Name)	commUsage
Table	Community Usage
Field	Usage Start
DB Field Name	usageStart
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This is the date on which the party applied the name to the concept.

 

Table (DB Name)	commUsage
Table	Community Usage
Field	Usage Stop
DB Field Name	usageStop
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This is the date on which the party ceased to apply the name to the concept.

 

Table (DB Name)	commUsage
Table	Community Usage
Field	Community Name Status
DB Field Name	commNameStatus
Req'd?	no
Data Type	varchar (20)
Misc Flag	n/a
References	n/a
List?	closed
Notes	closed list
Definition	This field shows the status of the application of the name to the concept by the party (standard, not standard, undetermined).
closed List of Values: Value Description Sorting standard   1 not standard   2 undetermined   3

 

Table (DB Name)	commUsage
Table	Community Usage
Field	Class System
DB Field Name	classSystem
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	open
Notes	Like FGDC of Forest Cover Class.
Definition	This is the name of the classification system wherein the name is applied (e.g., Scientific, Spanish common).
open List of Values: Value Description Sorting Scientific Ecological Society of American Vegetation Classification Panel. 2003. Guidelines ver. 2 1 Translated Ecological Society of American Vegetation Classification Panel. 2003. Guidelines ver. 2 2 Code Ecological Society of American Vegetation Classification Panel. 2003. Guidelines ver. 2 3 Common Ecological Society of American Vegetation Classification Panel. 2003. Guidelines ver. 2 4 Other   6

 

Table (DB Name)	commUsage
Table	Community Usage
Field	Comm Status
DB Field Name	COMMSTATUS_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	commStatus.COMMSTATUS_ID
List?	no
Notes	n/a
Definition	Comm Status which applies to this commUsage.

 

Table (DB Name)	plantConcept
Table	Plant Concept
Field	ID
DB Field Name	PLANTCONCEPT_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Database assigned value to each unique record in the commConcept table.

 

Table (DB Name)	plantConcept
Table	Plant Concept
Field	Plant Name
DB Field Name	PLANTNAME_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	plantName.PLANTNAME_ID
List?	no
Notes	n/a
Definition	This is a foreign key into the plant name list, the entry in which when combined with a reference constitutes a concept.

 

Table (DB Name)	plantConcept
Table	Plant Concept
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	This is a foreign key to the reference in which the name was used, thereby defining a concept.

 

Table (DB Name)	plantConcept
Table	Plant Concept
Field	Plant Description
DB Field Name	plantDescription
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The plantDescription is a description of the plantConcept by the party contributing the plantConcept.