Table: digest_queue

Connected to

This table references:

• user(ref) via column user_ref
• notifications(id) via column notification_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
user_ref	bigint	no	References user(ref)
topic	text	no	—
cadence	text	no	—
notification_id	uuid	no	References notifications(id)
queued_at	timestamp	no	Default now()
sent_at	timestamp	yes	—

Constraints

• CONSTRAINT digest_queue_cadence_check CHECK ((cadence = ANY (ARRAY['hourly'::text, 'daily'::text, 'weekly'::text])))

Full DDL

CREATE TABLE public.digest_queue (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    user_ref bigint NOT NULL,
    topic text NOT NULL,
    cadence text NOT NULL,
    notification_id uuid NOT NULL,
    queued_at timestamp with time zone DEFAULT now() NOT NULL,
    sent_at timestamp with time zone,
    CONSTRAINT digest_queue_cadence_check CHECK ((cadence = ANY (ARRAY['hourly'::text, 'daily'::text, 'weekly'::text])))
);

---

Please see the schema overview for context. This document was last regenerated on 2026-07-26T08:25:29.520Z.