@@ -201,6 +201,8 @@ Data between different tables are connected by id-columns, so called foreign key
...
@@ -201,6 +201,8 @@ Data between different tables are connected by id-columns, so called foreign key
1. Finally the tables
1. Finally the tables
- xxx.measurements
- xxx.measurements
** NOTE ** After importing or updating a row, you might be asked to select a key. Please select ** Custom Key ** and choose the id column
# Technical aspects not important for basic users
# Technical aspects not important for basic users
## Table partitioning and use of composite primary keys
## Table partitioning and use of composite primary keys
The tables with measurements and samples are using "table partitioning" in the background to store data from different environmental compartments in different sub tables and thus reduce time for data retrieval. For this reason the compartment column is included in the primary key together with the generated id column.
The tables with measurements and samples are using "table partitioning" in the background to store data from different environmental compartments in different sub tables and thus reduce time for data retrieval. For this reason the compartment column is included in the primary key together with the generated id column.
