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_tabledescriptionplacewhere_tablenameplace

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