Turboveg 3
Table Name | Comment | Schema |
associa | Table with results of Associa analysis | public |
covercodes | Table with cover codes and their percentage representation | public |
custodians | Table with data on custodians | public |
datasetgroups | Table with names of dataset groups | public |
datasets | Tablel with information on datasets. | public |
datatypes | Table with data types. The types are TEXT, INTEGER, REAL, DATE, BOOLEAN. Dates are internally stored as reals. | public |
fielddomains | Table with names of field domains (adminstrative data, species attributes, species trait data) | public |
fieldgroups | Table with names of groups of fields. Groups allow a structured presentation of fields in the data entry froms. Each group appear as a seperate tab on a form. | public |
fields | Table with basic information on fields. This information is linked to many other tables in the database. | public |
locations | Table with spation information stored as geometries in WKT format | public |
lookupcaptions | Table with caption of lookup tables | public |
lookupdata | Table with data of all lookup tables | public |
lookuptables | Table with name s of lookup tables | public |
metadata | Table with global metadatab. Pairs of keys/values are stored here. | public |
pictures | Table with information of and links to photographs related to vegetation plots | public |
plotobservationheaderdata | Table with header data of observation plots. A record in the table can have a reference to a value in a lookup table, or text string, an integer value or a real. Dates are also stored as reals. Booleans are stored as integer value o or 1 | public |
plotobservations | Table with basic information on plot observations | public |
plots | Table with basic information of vegetation plots. A vegetation plot can be linked to multiple plot observations | public |
profiledata | Table with reference to fields and profiles. Fields can be shown or hidden and can be made mandatory and read only. The order of the fields in which they appear in a profile can also be set | public |
profiles | Table with names of profiles. A profile is a collection of fields that forms a dataset | public |
projectdatasets | Table with links of dataset id's and project id's | public |
projects | Table ith project names. Datasets kan be linked to specific projects | public |
speciesobservationdata | Table with additional species attribute data like sociability or phenology. | public |
speciesobservations | Table with species observations (species name, vegetation layer, cover code, original species concept) | public |
taxa | Table with scientific and vernacular names of taxa, verious codes and the taxon represents a synonym or an accepted name | public |
taxongroups | Table with names of taxon groups (vascular plants, mosses, lichens, etc) | public |
taxonlists | Table with names of taxonomies | public |
taxonranks | Table with names of taxon ranks (Genus, Aggregate, Species, Subspecies, Hybride, etc) | public |
traitdata | Table holding specie straits (e.g. ecological indiactor values) | public |
units | Table with units (e.g. m, dm, cm, mm, %) | public |
vegetationlayers | Table with vegetation layers (tree layers, shrub layers, herb layer, etc) | public |