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 plantCorrelation
Table Plant Correlation
Notes This table correlates multiple plant concepts as they change through time.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID PLANTCORRELATION_ID no serial PK no Database assigned value to each unique record in the plantCorrelation table.
Plant Status PLANTSTATUS_ID required Integer FK no This is the foreign key into the plantStatus table "pointing" to a concept no longer viewed as standard by the party.
Plant Concept PLANTCONCEPT_ID required Integer FK no This is the foreign key into the plantConcept table "pointing" to a concept recognized by the party as a "standard" concept.
Plant Convergence plantConvergence required varchar (20) n/a closed This is the descriptive attribute that is used to relate the congruence between two concepts. The concept that is represented in the party perspective, via the Status_ID field is [this field, i.e. <,>,=] the concept represented in Concept_ID field. As normally used, (no Longer Valid Concept) [convergence] (Valid Concept). For example, if a concept is split, the convergence would be 'greater than' (The old concept is 'greater than' the new concept).
Correlation Start correlationStart required Date n/a no This is the start date for recognition by a party of a correlation between two concepts.
Correlation Stop correlationStop no Date n/a no This is the stop date for recognition by a party of a correlation between two concepts.