Database improvement

[meomancer]

Problem

Currently our measurements is increasing fast, making our query getting slow
Currently we are saving the value in foreign key
[measurement] -> [quantity]

This query takes a lot ot time to execute it

Solution

• Make the measurements flat table [id], [time], [value], [parameter]
• We also need to consider partitions.
  - Partition makes query fast as it is create table per well, as 1 well can contains millions measurements
• Quantity concept also being done on the other model, we need to make it as flat table and remove it

[meomancer]

Strategy:

1. We need to move quantity concept as flat table
2. Change all code to use flat table (ignore quantity model)
3. Do a tests (create backend tests also)
4. Create partitions
5. Do a tests (create backend tests also)