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 place
Table Place
Notes This table is the intersection between the plot table and the namedPlace table and is used for querying for plots located in a named place or named region in which a plot or group of plots is located.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID PLOTPLACE_ID no serial PK no Database generated identifier assigned to each unique plot occurrence at a place.
Plot PLOT_ID required Integer FK no Link to a specific plot.
Calculated? calculated no Boolean n/a no TRUE If occurrence is calculated based on geo-coordinates, FALSE if assigned by the author (If, both methods used, the author assigned value takes priority).
Place Name NAMEDPLACE_ID required Integer FK no Link to a specific named place or region