Turboveg 3 Tables
HomeTablesSchemasDiagramsForeign KeysIndexes

Tables

Table NameCommentSchema
associaTable with results of Associa analysispublic
covercodesTable with cover codes and their percentage representation public
custodiansTable with data on custodianspublic
datasetgroupsTable with names of dataset groupspublic
datasetsTablel with information on datasets. public
datatypesTable with data types. The types are TEXT, INTEGER, REAL, DATE, BOOLEAN. Dates are internally stored as reals.public
fielddomainsTable with names of field domains (adminstrative data, species attributes, species trait data) public
fieldgroupsTable 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
fieldsTable with basic information on fields. This information is linked to many other tables in the database.public
locationsTable with spation information stored as geometries in WKT formatpublic
lookupcaptionsTable with caption of lookup tablespublic
lookupdataTable with data of all lookup tablespublic
lookuptablesTable with name s of lookup tablespublic
metadataTable with global metadatab. Pairs of keys/values are stored here.public
picturesTable with information of and links to photographs related to vegetation plotspublic
plotobservationheaderdataTable 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
plotobservationsTable with basic information on plot observationspublic
plotsTable with basic information of vegetation plots. A vegetation plot can be linked to multiple plot observationspublic
profiledataTable 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
profilesTable with names of profiles. A profile is a collection of fields that forms a datasetpublic
projectdatasetsTable with links of dataset id's and project id'spublic
projectsTable ith project names. Datasets kan be linked to specific projectspublic
speciesobservationdataTable with additional species attribute data like sociability or phenology. public
speciesobservationsTable with species observations (species name, vegetation layer, cover code, original species concept)public
taxaTable with scientific and vernacular names of taxa, verious codes and the taxon represents a synonym or an accepted namepublic
taxongroupsTable with names of taxon groups (vascular plants, mosses, lichens, etc)public
taxonlistsTable with names of taxonomiespublic
taxonranksTable with names of taxon ranks (Genus, Aggregate, Species, Subspecies, Hybride, etc)public
traitdataTable holding specie straits (e.g. ecological indiactor values)public
unitsTable with units (e.g. m, dm, cm, mm, %)public
vegetationlayersTable with vegetation layers (tree layers, shrub layers, herb layer, etc)public