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 observationSynonym
Table Observation Synonym
Notes This table stores opinions as to whether one observation record is a synonym of another owing to double entry into the database.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID OBSERVATIONSYNONYM_ID no serial PK no Database generated identifier assigned to each unique interpretation of an observation as a synonym.
Synonym Observation synonymObservation_ID required Integer FK no Link to the observation table identifying which observation is being reduced to synonymy.
Primary Observation primaryObservation_ID required Integer FK no Link to the observation table identifying which observation is the preferred synonym for the observation being reduced to synonym.
Party PARTY_ID required Integer FK no Foreign key pointing to the specific party that made the reduction to synonym.
Role ROLE_ID required Integer FK no Foreign key that identifies the role that the party had in the plot synonomization (e.g., plot author, data manager, publication author, researcher, generic user, etc.).
Start Date classStartDate required Date n/a no Start date for the synonymization event.
Stop Date classStopDate no Date n/a no Stop date for the synonymization event.
Synonym Comment synonymComment no text n/a no Notes about the reason for the synonymization.
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).