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

VegBank Data Dictionary: Field Details

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

Search VegBank Tables Here

Table (DB Name)	commConcept
Table	Community Concept
Field	ID
DB Field Name	COMMCONCEPT_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Database assigned value to each unique record in the commConcept table.

 

Table (DB Name)	commConcept
Table	Community Concept
Field	Community Name
DB Field Name	COMMNAME_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	commName.COMMNAME_ID
List?	no
Notes	na
Definition	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).

 

Table (DB Name)	commConcept
Table	Community Concept
Field	Reference
DB Field Name	reference_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	reference.reference_ID
List?	no
Notes	n/a
Definition	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

 

Table (DB Name)	commConcept
Table	Community Concept
Field	Community Description
DB Field Name	commDescription
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The commDescription is a description of the community concept by the party that contributed the concept.

 

Table (DB Name)	commConcept
Table	Community Concept
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)	commCorrelation
Table	Community Correlation
Field	ID
DB Field Name	COMMCORRELATION_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Database assigned value to each unique record in the communityCorrelation table.

 

Table (DB Name)	commCorrelation
Table	Community Correlation
Field	Community Status
DB Field Name	COMMSTATUS_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	commStatus.COMMSTATUS_ID
List?	no
Notes	n/a
Definition	This is the foreign key into the CommStatus table "pointing" to a concept no longer viewed as standard by the party.

 

Table (DB Name)	commCorrelation
Table	Community Correlation
Field	Community Concept
DB Field Name	COMMCONCEPT_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	commConcept.COMMCONCEPT_ID
List?	no
Notes	n/a
Definition	This is the foreign key into the communityConcept table "pointing" to a concept recognized by the party as a "standard" concept.

 

Table (DB Name)	commCorrelation
Table	Community Correlation
Field	Community Convergence
DB Field Name	commConvergence
Req'd?	required
Data Type	varchar (20)
Misc Flag	n/a
References	n/a
List?	closed
Notes	n/a
Definition	This is the descriptive attribute that is used to relate the congruence between two concepts.
closed List of Values: Value Description Sorting equal The two concepts are exactly the same. 1 greater than The reference concept (referenced in table:Status) fully contains the correlated concept (referenced in table:Concept), but also includes additional entities. 2 less than The reference concept is fully included in the correlated concept, but the latter concept contains additional entities. 3 not equal The two concepts are not exactly the same. This leaves the possibilities that the reference concept is greater than, less than, overlapping, similar, or disjunct relative to the correlated concept. 4 overlapping The two concepts contain at least one common entity, and each concept also contains at least one entity that the other does not contain. Neither concept is fully contained in the other. 5 similar The two concepts contain at least one common individual. 6 disjunct The two concepts in question contain no common entities. 7 undetermined Although some correlation is likely, the party responsible for the this correlation has not made a determination. 8

 

Table (DB Name)	commCorrelation
Table	Community Correlation
Field	Correlation Start
DB Field Name	correlationStart
Req'd?	required
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This is the start date for recognition by a party of a correlation between two concepts.