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 commConcept
Table Community Concept
Notes This table store the concepts (assertions) that are linked to community names through the commUsage table.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID COMMCONCEPT_ID no serial PK no Database assigned value to each unique record in the commConcept table.
Community Name COMMNAME_ID required Integer FK no Foreign key into the commName table providing the name used for the community when it was defined by usage in a publication (which could be this database).
Reference reference_ID no Integer FK no Foreign key into the Reference table to identify a reference in which the community was identified by a name. This could be a regular publication, or a self reference created by completing the commDescription field in reference
Community Description commDescription no text n/a no The commDescription is a description of the community concept by the party that contributed the concept.
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).