Login | Datasets | Logout
 

VegBank Data Dictionary - Search Fields

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

   Search VegBank Tables Here
««more pages

«previous  | page 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  next»
records 1 through 10 of 503

more pages»»

show labels | show db fields
Table Field DB Field Name Req'd? Data Type Misc Flag List? Definition
Community Concept ID COMMCONCEPT_ID no serial PK no Database assigned value to each unique record in the commConcept table.
Community Concept 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).
Community Concept 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 Concept Community Description commDescription no text n/a no The commDescription is a description of the community concept by the party that contributed the concept.
Community 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).
Community Correlation ID COMMCORRELATION_ID no serial PK no Database assigned value to each unique record in the communityCorrelation table.
Community Correlation Community Status COMMSTATUS_ID required Integer FK no This is the foreign key into the CommStatus table "pointing" to a concept no longer viewed as standard by the party.
Community Correlation Community Concept COMMCONCEPT_ID required Integer FK no This is the foreign key into the communityConcept table "pointing" to a concept recognized by the party as a "standard" concept.
Community Correlation Community Convergence commConvergence required varchar (20) n/a closed This is the descriptive attribute that is used to relate the congruence between two concepts.
Community Correlation Correlation Start correlationStart required Date n/a no This is the start date for recognition by a party of a correlation between two concepts.

««more pages

«previous  | page 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  next»
records 1 through 10 of 503

more pages»»