Table: notifications

Connected to

Referenced by:

• digest_queue — column notification_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
recipient_user_ref	bigint	no	—
actor_user_ref	bigint	yes	—
verb	text	no	—
target_kind	text	yes	—
target_id	text	yes	—
payload	jsonb	no	Default '{}'::jsonb
read_at	timestamp	yes	—
delivered_at	timestamp	no	Default now()
email_sent_at	timestamp	yes	—
origin_server_id	uuid	yes	—
created_at	timestamp	no	Default now()

Full DDL

CREATE TABLE public.notifications (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    recipient_user_ref bigint NOT NULL,
    actor_user_ref bigint,
    verb text NOT NULL,
    target_kind text,
    target_id text,
    payload jsonb DEFAULT '{}'::jsonb NOT NULL,
    read_at timestamp with time zone,
    delivered_at timestamp with time zone DEFAULT now() NOT NULL,
    email_sent_at timestamp with time zone,
    origin_server_id uuid,
    created_at timestamp with time zone DEFAULT now() NOT NULL
);

---

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