Home.md

@@ -134,7 +134,7 @@ The following procedures are implemented to ascertain data quality in the databa
   - Not Null: Ensures that a not-null condition of a column entry or a combination of column entries are satisfied. In the \__column_definition\_ view those columns are marked in the \_mandatory\_ column.
   - Check: Ensures the satisfaction of certain conditions based on logical queries or the existence of other column entries in this row. 
   
-<details><summary>Click to expand</summary>
+  - <details><summary>Example2</summary>
 Check constraints for numeric values: Wherever possible numeric 
 values are checked on insertion for their plausibility (e.g.areas, discharges, inhabitants) to be 
 within a meaningful range, usually \> 0 and smaller a maximum value. The catchment area of a river must 
@@ -142,7 +142,7 @@ be larger than 0 km² and smaller than 7000000 km² (size of the Amazon river ba
 check_catchment_area_range CHECK ( catchment_area_km2 \> 0 AND catchment_area_km2 \< 7000000 )
 </details>
 
-<details><summary>Click to expand</summary>
+  - <details><summary>Example2</summary>
 Values are checked based on values in other columns: If a measurement is marked as below an analytical limit, the value of the limit must be given in the corresponding column. If a measurement is marked as below the analytical limit of detection (LOD), the LOD must be given in the corresponding column.CONSTRAINT check_lod_available CHECK ((lod \> 0 AND value_below_lod IS TRUE) OR (value_below_lod IS NOT TRUE))
 </details>
 
@@ -152,8 +152,7 @@ Values are checked based on values in other columns: If a measurement is marked
 
 - Controlled vocabulary: Those are a special version of foreign keys, here used for qualitative attributes: Whenever a qualitative attribute is recorded, controlled vocabularies (a list of allowed values for that column) are used. These assure, that the same thing is always called the same (and without typos) and no further data cleaning is necessary before data evaluation. Controlled vocabularies are stored in separate tables. These tables can not be changed by the ordinary user, but only by admins. Deletion in controlled vocabularies are not recorded in the database itself (no soft delete mechanism), here the admin is responsible to keep a backup. In the \__column_definition\_ view those columns are marked in the \__controlled_vocabulary\_ and. Possible entries for those columns can be seen in the \__controlled_vocabularies\_ view.
 
-  <details>
-<summary>Example</summary>
+- <details><summary>Example</summary>
 The Accreditation status of measurements are managed by a boolean 
   column with controlled vocabulary used according to the following 
   schema: