CREATE TABLE notifications_log (

    id          BIGSERIAL PRIMARY KEY,

    drop_id     BIGINT REFERENCES drops(id) ON DELETE SET NULL,

    channel     TEXT NOT NULL CHECK (channel IN ('ntfy','telegram','email','browser')),

    title       TEXT NOT NULL,

    body        TEXT NOT NULL,

    priority    TEXT NOT NULL CHECK (priority IN ('min','low','default','high','urgent')),

    sent_at     TIMESTAMPTZ NOT NULL DEFAULT NOW(),

    success     BOOLEAN NOT NULL,

    response    TEXT,

    topic       TEXT

);

CREATE INDEX idx_notif_sent_desc ON notifications_log(sent_at DESC);

CREATE INDEX idx_notif_drop      ON notifications_log(drop_id);