create table soil_sample(
    id              integer     not null primary key autoincrement,
    soil_monitor    integer     not null references soil_monitor(id),
    value           integer
);