# Schema

    CREATE TABLE sm_by_day (
        device text,
        day text,
        timestamp timestamp,
        sensors list<frozen<tuple<int, int>>>,
        PRIMARY KEY (
            (device, day), 
            timestamp
        )
    );


# Create Schema

    $ bin/cqlsh
    cqlsh> create keyspace soil_moisture WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};
    cqlsh> use soil_moisture;
    cqlsh:soil_moisture>
        create table sm_by_day(
            device text,
            day text,
            timestamp timestamp,
            sensors list<frozen<tuple<int, int>>>,
            primary key(
                (device, day),
                timestamp
            )
        );