Table: federation_outbox

Connected to

This table references:

• activities(id) via column activity_id
• federation_peers(id) via column peer_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
activity_id	uuid	no	References activities(id)
peer_id	uuid	no	References federation_peers(id)
target_user_url	text	yes	—
status	text	no	Default 'queued'::text
attempts	smallint	no	Default 0
next_attempt_at	timestamp	no	Default now()
last_attempt_at	timestamp	yes	—
last_error	text	no	Default ''::text
sent_at	timestamp	yes	—
delivered_with_key_id	text	yes	—
created_at	timestamp	no	Default now()
updated_at	timestamp	no	Default now()
was_encrypted	boolean	no	Default false
sensitivity	text	yes	—
refused_reason	text	yes	—

Constraints

• CONSTRAINT federation_outbox_status_check CHECK ((status = ANY (ARRAY['queued'::text, 'sent'::text, 'failed'::text, 'cancelled'::text, 'refused'::text])))

Full DDL

CREATE TABLE public.federation_outbox (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    activity_id uuid NOT NULL,
    peer_id uuid NOT NULL,
    target_user_url text,
    status text DEFAULT 'queued'::text NOT NULL,
    attempts smallint DEFAULT 0 NOT NULL,
    next_attempt_at timestamp with time zone DEFAULT now() NOT NULL,
    last_attempt_at timestamp with time zone,
    last_error text DEFAULT ''::text NOT NULL,
    sent_at timestamp with time zone,
    delivered_with_key_id text,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    updated_at timestamp with time zone DEFAULT now() NOT NULL,
    was_encrypted boolean DEFAULT false NOT NULL,
    sensitivity text,
    refused_reason text,
    CONSTRAINT federation_outbox_status_check CHECK ((status = ANY (ARRAY['queued'::text, 'sent'::text, 'failed'::text, 'cancelled'::text, 'refused'::text])))
);

---

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