Login | Datasets | Logout
 

VegBank Data Dictionary: Tables

  Search for a VegBank Table (enter a word, field name, etc.):    <<Hide search
Match any word
Match whole words only

   Search VegBank Fields Here

Show field labels | Show database names

DB Table Name userDefined
Table User Defined
Notes This table contains the definitions of user-defined variables. The table structure stems from desire to keep the user-defined variables separate from the main body of the database.
Description This table contains the definitions of user-defined variables. The table structure stems from desire to keep the user-defined variables separate from the main body of the database.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID USERDEFINED_ID no serial PK no Database generated identifier assigned to each unique user-defined variable.
User Defined Name userDefinedName no varchar (50) n/a open Name of the user-defined variable.
User Defined Metadata userDefinedMetadata no text n/a no Metadata about this user-defined variable.
User Defined Category userDefinedCategory no varchar (30) n/a closed Category of variable; included to facilitate queries for specific types of data.
User Defined Type userDefinedType required varchar (20) n/a no Database data type of the user-defined variable.
Table Name tableName required varchar (50) n/a no 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.
Accession Code accessionCode no varchar (100) n/a no 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).