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  | 1 | 2 | 3 | 4 | page 5 | 6 | 7 | 8 | 9 | 10 |  next»
records 41 through 50 of 503

more pages»»

show labels | show db fields
Table Field DB Field Name Req'd? Data Type Misc Flag List? Definition
Plant 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).
Plant Correlation ID PLANTCORRELATION_ID no serial PK no Database assigned value to each unique record in the plantCorrelation table.
Plant Correlation 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 Correlation 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 Correlation 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).
Plant 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.
Plant Correlation Correlation Stop correlationStop no Date n/a no This is the stop date for recognition by a party of a correlation between two concepts.
Plant Lineage ID PLANTLINEAGE_ID no serial PK no Database assigned value to each unique record in the plantLineage table.
Plant Lineage Child Plant Status childPlantStatus_ID required Integer FK no This is the foreign key into the plantStatus table "pointing" to a child concept.
Plant Lineage Parent Plant Status parentPlantStatus_ID required Integer FK no This is the foreign key into the plantStatus table "pointing" to a parent concept.

««more pages

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

more pages»»