zGrid-api/sql/devices.sql

CREATE TYPE device_type AS ENUM (
    'on_off_switch'
);

CREATE TABLE IF NOT EXISTS devices (
    id UUID PRIMARY KEY,
    home_id UUID NOT NULL,

    name TEXT NOT NULL,
    description TEXT
    device_type device_type NOT NULL
);