Database Schema

Navigating the Database

Navigating the Database #

The tables in the AKVEG Database can be broadly classified into data tables, referenced tables, and metadata tables.

Data tables contain information on vegetation, environmental, and soils characteristics, as well as information about the plots at which these data were collected (e.g., plot coordinates, dimensions).

Referenced tables are referenced by the data tables to constrain the set of allowable values in a field. For example, the cover type id field in the vegetation_cover table references the cover_type table. The cover_type table specifies the types of methods that can be used to collect cover data.