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_tabledescriptionplantcorrelationwhere_tablenameplantcorrelation

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