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

detaildba_tabledescriptioncommconceptwhere_tablenamecommConcept

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 for VegBank Table >>

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).