@@ -57,7 +57,7 @@ At the top of every schemata are three support views starting with a underscore
...
@@ -57,7 +57,7 @@ At the top of every schemata are three support views starting with a underscore
### Views in public
### Views in public
- Views for data evaluation and extraction: The views, with the same name of the environmental compartments from which its data originates, conatin quality checked data, that was combined to wide tables displayng all collected information. They only miss columns which are recorded for data traceability, e.g. columns with the originally reported text strings, which were mapped on the controlled vocabularies.
- Views for data evaluation and extraction: The views, with the same name of the environmental compartments from which its data originates, conatin quality checked data, that was combined to wide tables displayng all collected information. They only miss columns which are recorded for data traceability, e.g. columns with the originally reported text strings, which were mapped on the controlled vocabularies.
- Views to support the quality assessment workflow: The two views __qa_awaiting_ and __rejected_data_ should provide an overview of not yet either quality assessed or corrected data. They aggregate information about data recently imported or unsuccessful quality assessed regarding its schema, view, number of rows ad its importer respectively its quality assesor.
- Views to support the quality assessment workflow: The two views __qa_awaiting_ and __rejected_data_ should provide an overview of not yet either quality assessed or corrected data. They aggregate information about data recently imported or unsuccessfully assessed regarding its schema, view, number of rows and its importer or respectively its quality assessor.
## User rights management
## User rights management
User rights for working with the database depend on PostgreSQL roles. The following roles were defined:
User rights for working with the database depend on PostgreSQL roles. The following roles were defined:
