migrations/202610150003_add_measurement.sql


1
2
3
4
5
6
7

CREATE TABLE IF NOT EXISTS measurement (
    id UUID PRIMARY KEY,
    measured_at TIMESTAMPTZ NOT NULL,
    metric_type metric_type NOT NULL,
    value DOUBLE PRECISION NOT NULL,
    unit unit NOT NULL
);