public - Schema
HomeTablesSchemasDiagramsForeign KeysIndexes

Schema: public

Tables

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