CREATE TABLE watchlist (

    id          BIGSERIAL PRIMARY KEY,

    kind        TEXT NOT NULL CHECK (kind IN ('artist','team','venue','sport','category','keyword','twitter_account')),

    pattern     TEXT NOT NULL,

    label       TEXT NOT NULL CHECK (length(label) BETWEEN 1 AND 128),

    active      BOOLEAN NOT NULL DEFAULT TRUE,

    priority    TEXT NOT NULL DEFAULT 'normal' CHECK (priority IN ('low','normal','high','critical')),

    created_at  TIMESTAMPTZ NOT NULL DEFAULT NOW(),

    updated_at  TIMESTAMPTZ NOT NULL DEFAULT NOW(),

    UNIQUE (kind, pattern)

);

CREATE INDEX idx_watchlist_active_kind ON watchlist(active, kind);

CREATE TRIGGER watchlist_set_updated_at

    BEFORE UPDATE ON watchlist

    FOR EACH ROW EXECUTE FUNCTION set_updated_at();