Description

Table: measurements

+-------------------+---------+
| Column Name       | Type    |
+-------------------+---------+
| measurement_id    | integer |
| measurement_value | decimal |
| measurement_time  | datetime|
+-------------------+---------+

measurement_id is the unique identifier. Within each calendar day, measurements are numbered 1st, 2nd, 3rd, … in chronological order by measurement_time. The 1st, 3rd, and 5th are odd numbered; the 2nd, 4th, and 6th are even numbered.