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

181010

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)	coverMethod
Table	Cover Method
Field	ID
DB Field Name	COVERMETHOD_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for the coverMethod table.
Definition	Database generated identifier assigned to each unique coverclass methodology.

 

Table (DB Name)	coverMethod
Table	Cover Method
Field	Reference
DB Field Name	reference_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	reference.reference_ID
List?	no
Notes	Foreign key into the reference table.
Definition	Foreign Key into the reference table, linking the defining reference to a cover method.

 

Table (DB Name)	coverMethod
Table	Cover Method
Field	Cover Type
DB Field Name	coverType
Req'd?	required
Data Type	varchar (30)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Name of the coverclass method (e.g., Braun-Blanquet, Barkman, Domin, Daubenmire, Carolina Vegetation Survey, etc.).

 

Table (DB Name)	coverMethod
Table	Cover Method
Field	Cover Estimation Method
DB Field Name	coverEstimationMethod
Req'd?	no
Data Type	varchar (80)
Misc Flag	n/a
References	n/a
List?	closed
Notes	n/a
Definition	The way that cover is estimated on the observation.
closed List of Values: Value Description Sorting canopy cover Cover estimated as the percentage of ground covered by a vertical outermost perimeter of the natural spread of foliage of plants. (SRM 1989) 1 foliar cover Cover estimated as the percentage of ground covered by the vertical portion of plants. Small openings in the canopy and intraspecific overlap are excluded (SRM 1989). Foliar cover is the vertical projection of shoots; i.e., stems and leaves. 2

 

Table (DB Name)	coverMethod
Table	Cover Method
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)	definedValue
Table	Defined Value
Field	ID
DB Field Name	DEFINEDVALUE_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for the definedValue table
Definition	Database generated identifier assigned to each unique defined value.

 

Table (DB Name)	definedValue
Table	Defined Value
Field	User Defined
DB Field Name	USERDEFINED_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	userDefined.USERDEFINED_ID
List?	no
Notes	n/a
Definition	Link to a specific user-defined variable defined in the userDefined table.

 

Table (DB Name)	definedValue
Table	Defined Value
Field	Table Record
DB Field Name	tableRecord_ID
Req'd?	required
Data Type	Integer
Misc Flag	n/a
References	n/a
List?	no
Notes	Pseudokey for the table with which this value should be associated
Definition	The numeric value of the record number (primary key) that this user-defined value would have if it were in the table identified by USERDEFINED_ID.

 

Table (DB Name)	definedValue
Table	Defined Value
Field	Defined Value
DB Field Name	definedValue
Req'd?	required
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The value of the user-defined variable.

 

Table (DB Name)	disturbanceObs
Table	Disturbance Observation
Field	ID
DB Field Name	disturbanceObs_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for disturbanceObs
Definition	Database generated identifier assigned to each unique disturbance observation..