Views to query metadata

Universal export views

If the data project has an individual database schema (see here) a number of views are automatically available. These provide the metadata of the loggers managed in the data project for (read) retrieval.

The retrievable data varies depending on the used database user name (schema).

Data schema

Keys for relations

UNI_EXP_LOGGER:                 LOGGER_ID
UNI_EXP_INVESTIGATION_AREA:     INVESTIGATION_AREA_ID
UNI_EXP_SENSOR_CONFIGURATION:   SENSOR_CONFIGURATION_ID
UNI_EXP_SENSOR:                 SENSOR_ID
UNI_EXP_SAMPLING_MEDIA:         SAMPLING_MEDIA_NAME
UNI_EXP_PHYSICAL_PROPERTY:      PHYSICAL_PROPERTY_NAME
UNI_EXP_UNIT:                   UNIT_NAME
UNI_EXP_LOCATION:               LOCATION_ID