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  | page 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 |  next»
records 301 through 310 of 503

more pages»»

show labels | show db fields
Table Field DB Field Name Req'd? Data Type Misc Flag List? Definition
Observation Synonym 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.
Observation Synonym Party PARTY_ID required Integer FK no Foreign key pointing to the specific party that made the reduction to synonym.
Observation 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.).
Observation Synonym Start Date classStartDate required Date n/a no Start date for the synonymization event.
Observation Synonym Stop Date classStopDate no Date n/a no Stop date for the synonymization event.
Observation Synonym Synonym Comment synonymComment no text n/a no Notes about the reason for the synonymization.
Observation Synonym 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).
Party ID PARTY_ID no serial PK no Database generated identifier assigned to each unique party.
Party Salutation salutation no varchar (20) n/a no Salutation preceding one's given name.
Party Given Name givenName no varchar (50) n/a no One's first name.

««more pages

«previous  | page 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 |  next»
records 301 through 310 of 503

more pages»»