@@ -46,9 +46,14 @@ All data are stored in the schema _hidden_, for user interaction they are presen
### Views
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_.
- 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_.
- The data which were not accepted by the quality assessor are presented in a further view to the tethys_user for correction or deletion. These views are appended with the suffix __qa_rejected_.
- To check all imported data independently of their quality assessment status, views without a suffix are available for every table. These Views are read-only, for changing or deleting data, please use the aforementioned views.
At the top of every schemata beside public are three support views starting with a __.
- The _column__definition conatins comprehensive information about a columns properties regarding its description, data type, constraints or keys and should therefore serve as a tool for importing activities.
- The __controlled_vocabularies contains predefined column entries originally stored in hidden and only maintained by tethys__ca. They serve as foreign key for __import views and are marked as such in the __column__definition view. The reason to limit their creation rights lies in their low diversity but simultaneously high number of references, which therefore enables the tethys_ca to preserve data integrity from below.
- The __table__definition view contains information about all views and tables of its schema and should therefore enhance your knowledge about the database.
- View for data evaluation and extraction: In the schema _public_ quality checked data are combined to wide tables combining 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.
