CREATE TABLE IF NOT EXISTS watchdogs ( id UUID PRIMARY KEY NOT NULL, project_id UUID UNIQUE NOT NULL REFERENCES projects (id) ON DELETE RESTRICT, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), last_set_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), expiration TIMESTAMPTZ NOT NULL, notified BOOLEAN NOT NULL DEFAULT FALSE ); CREATE INDEX ON watchdogs (project_id); CREATE INDEX ON watchdogs (expiration);