@@ -35,12 +35,10 @@ The database is structured into different schemata, which hold the tables for th
...
@@ -35,12 +35,10 @@ The database is structured into different schemata, which hold the tables for th
| hidden | Schema containing all the data table itself. Only accessible for administrators.|
| hidden | Schema containing all the data table itself. Only accessible for administrators.|
| public | The default schema created by PostgreSQl where all users have certain rights. If objects are created without assigning them a dedicated schema, they will be stored here. In this schema the quality checked data are presented for download. |
| public | The default schema created by PostgreSQl where all users have certain rights. If objects are created without assigning them a dedicated schema, they will be stored here. In this schema the quality checked data are presented for download. |
| sed | Sediments: Concentrations in solid layers below the water column.|
| sed | Sediments: Concentrations in solid layers below the water column.|
| sewsl | Sewage sludge: Concentration in sludge resulting from wastewater treatment.|
| soil | Soil: Concentrations in samples from (top)soil contributing to surface water pollution via soil erosion and via washout to groundwater. |
| soil | Soil: Concentrations in samples from (top)soil contributing to surface water pollution via soil erosion and via washout to groundwater. |
| spm | Suspended particulate matter: Substance content measured in solid samples taken from suspended material transported by surface waters. |
| stormw | Stormwater runoff: Concentration in runnoff generated mainly by precipitation events. Either as runoff from specific urban surfaces, as runoff in the storm sewer in separate sewer systems or as combined sewer overflow (CSO) in the combined sewer system.|
| stormw | Stormwater runoff: Concentration in runnoff generated mainly by precipitation events. Either as runoff from specific urban surfaces, as runoff in the storm sewer in separate sewer systems or as combined sewer overflow (CSO) in the combined sewer system.|
| surfw | Surfacewater: Concentrations measured in the liquid phase of surface waters: rivers, lakes, reservoirs, coastal waters ... |
| surfw | Surfacewater: Concentrations measured in the liquid phase, biota or suspended particulate matter in surface waters: rivers, lakes, reservoirs, coastal waters ... |
| wastew | Wastewater: Wastewater from municipal or industrial sources, treated or untreated. |
| wastew | Wastewater: Wastewater from municipal or industrial sources, treated or untreated. Including also concentration in sludge resulting from wastewater treatment. |
All data are stored in the schema _hidden_, for user interaction they are presented in the different schemata via database views.
All data are stored in the schema _hidden_, for user interaction they are presented in the different schemata via database views.
