@@ -24,6 +24,7 @@ The environmental compartments foreseen at the moment (extension is possible) an
...
@@ -24,6 +24,7 @@ The environmental compartments foreseen at the moment (extension is possible) an
- sediment (sed): Substance content in bottom sediment samples.
- sediment (sed): Substance content in bottom sediment samples.
## Structure
## Structure
### Schemata
The database is structured into different schemata, which hold the tables for the different environmental compartments and some schema for general information:
The database is structured into different schemata, which hold the tables for the different environmental compartments and some schema for general information:
| schema name | description |
| schema name | description |
| ------ | ------ |
| ------ | ------ |
...
@@ -42,6 +43,8 @@ The database is structured into different schemata, which hold the tables for th
...
@@ -42,6 +43,8 @@ The database is structured into different schemata, which hold the tables for th
| wastew | Wastewater: Wastewater from municipal or industrial sources, treated or untreated. |
| wastew | Wastewater: Wastewater from municipal or industrial sources, treated or untreated. |
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.
### Views
The same data are presented in different views for different purpose:
The same data are presented in different views for different purpose:
- For data import purpose only the columns which can be filled during data import are shown, additional columns filled automatically during data import are hidden here (e.g. the numerical id, the time of import and the user importing the data). Here only data created by the user itself are visible and only Data are visible in this views as long as they have not gone through the quality assessment workflow. These views are appended with the suffix __import_.
- For data import purpose only the columns which can be filled during data import are shown, additional columns filled automatically during data import are hidden here (e.g. the numerical id, the time of import and the user importing the data). Here only data created by the user itself are visible and only Data are visible in this views as long as they have not gone through the quality assessment workflow. These views are appended with the suffix __import_.
- A different view on the data is available for the quality assessment for quality assessors. here some additional data are included (like the user who created the data set) and only the two columns regarding quality assessment (quality_check_passed, comments_quality_assessment) can be updated. These views are appended with the suffix __qa_.
- A different view on the data is available for the quality assessment for quality assessors. here some additional data are included (like the user who created the data set) and only the two columns regarding quality assessment (quality_check_passed, comments_quality_assessment) can be updated. These views are appended with the suffix __qa_.
