Our default database structure included in the standard package is based on a normalized architecture.
This makes the database very flexible with almost no database engineering or programming effort when the demands are changing.
The downside of this is that it is not very easy to overlook at a glance.
In order to look up data, you can Create a view. Where you define which parameters to monitor.
We have made an Excel document “SQL View generator.xlsm”, to create a SQL View with columns for each parameter you want to monitor.
This enables you to design the query for building a view, with up to 20 columns parameters. This should then give a hint on how to get data out of the database.