zGrid-api/sql/homes.sql

CREATE TABLE IF NOT EXISTS homes (
    id UUID PRIMARY KEY,
    api_key UUID NOT NULL UNIQUE,
    name TEXT NOT NULL,
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE INDEX api_key_idx ON homes (api_key);