Javascript is disabled! Some VegBank functions will not work without it.
More info...
Table (DB Name) userDefined
Table User Defined
Field
ID
DB Field Name
USERDEFINED_ID
Req'd?
no
Data Type
serial
Misc Flag
PK
References
n/a
List?
no
Notes
Primary key for userDefined
Definition
Database generated identifier assigned to each unique user-defined variable.
Table (DB Name) userDefined
Table User Defined
Field
User Defined Name
DB Field Name
userDefinedName
Req'd?
no
Data Type
varchar (50)
Misc Flag
n/a
References
n/a
List?
open
Notes
open list
Definition
Name of the user-defined variable.
open List of Values:
Value Description Sorting
Microbial biomass
1
Slope convexity
2
Depth to permafrost
3
Table (DB Name) userDefined
Table User Defined
Field
User Defined Metadata
DB Field Name
userDefinedMetadata
Req'd?
no
Data Type
text
Misc Flag
n/a
References
n/a
List?
no
Notes
n/a
Definition
Metadata about this user-defined variable.
Table (DB Name) userDefined
Table User Defined
Field
User Defined Category
DB Field Name
userDefinedCategory
Req'd?
no
Data Type
varchar (30)
Misc Flag
n/a
References
n/a
List?
closed
Notes
closed list
Definition
Category of variable; included to facilitate queries for specific types of data.
closed List of Values:
Value Description Sorting
Soil, physical attributes
1
Soil, chemical attributes
2
Geology and geomorphology
3
Moisture
4
Environment
5
Topography
6
Disturbance and land use
7
Subplots
8
Not specified
9
Table (DB Name) userDefined
Table User Defined
Field
User Defined Type
DB Field Name
userDefinedType
Req'd?
required
Data Type
varchar (20)
Misc Flag
n/a
References
n/a
List?
no
Notes
n/a
Definition
Database data type of the user-defined variable.
Table (DB Name) userDefined
Table User Defined
Field
Table Name
DB Field Name
tableName
Req'd?
required
Data Type
varchar (50)
Misc Flag
n/a
References
n/a
List?
no
Notes
n/a
Definition
Name of table with which this user-defined variable is associated. For example soilBHorizonColor may be defined by the data contributor as associated with the observation table.
Table (DB Name) userDefined
Table User Defined
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) embargo
Table Embargo on Plot
Field
Embargo ID
DB Field Name
embargo_ID
Req'd?
required
Data Type
serial
Misc Flag
PK
References
n/a
List?
no
Notes
n/a
Definition
Database generated unique key for each record in this table.
Table (DB Name) embargo
Table Embargo on Plot
Field
Plot ID
DB Field Name
plot_ID
Req'd?
required
Data Type
Integer
Misc Flag
FK
References
plot.PLOT_ID
List?
no
Notes
n/a
Definition
Foreign key to the plot to which this embargo applies.
Table (DB Name) embargo
Table Embargo on Plot
Field
Embargo Reason
DB Field Name
embargoReason
Req'd?
required
Data Type
text
Misc Flag
n/a
References
n/a
List?
closed
Notes
Author stipulation,Rare species,Landownership,Bad data,Other
Definition
Reason why the plot is embargoed. This field, as all fields in this table, are private and cannot be viewed or downloaded by VegBank users.
closed List of Values:
Value Description Sorting
Author stipulation
Plot Author requires that plot be embargoed
1
Rare Species
There are rare species on this plot whose exact location should not be revealed to all users.
2
Land Ownership
Land owner requires plot data to be embargoed
3
Bad Data
The data pertaining to this plot have been determined to have errors.
4
Other
None of the above reasons.
99
unhighlight
highlight