Table: federation_inbox

Connected to

This table references:

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

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
activity_uri	text	no	—
peer_id	uuid	no	References federation_peers(id)
actor_uri	text	no	—
activity_type	text	no	—
object_kind	text	yes	—
object_id	uuid	yes	—
envelope_json	jsonb	no	—
http_sig_key	text	no	—
received_at	timestamp	no	Default now()
status	text	no	Default 'pending'::text
reject_reason	text	yes	—
dispatch_attempts	integer	no	Default 0
last_attempt_at	timestamp	yes	—
last_error	text	no	Default ''::text
processed_at	timestamp	yes	—
correlation_activity_id	uuid	yes	References activities(id)
created_at	timestamp	no	Default now()
updated_at	timestamp	no	Default now()
was_encrypted	boolean	no	Default false
decrypted_with_key_version	integer	yes	—

Constraints

• CONSTRAINT federation_inbox_status_check CHECK ((status = ANY (ARRAY['pending'::text, 'processed'::text, 'rejected'::text, 'failed'::text])))

Full DDL

CREATE TABLE public.federation_inbox (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    activity_uri text NOT NULL,
    peer_id uuid NOT NULL,
    actor_uri text NOT NULL,
    activity_type text NOT NULL,
    object_kind text,
    object_id uuid,
    envelope_json jsonb NOT NULL,
    http_sig_key text NOT NULL,
    received_at timestamp with time zone DEFAULT now() NOT NULL,
    status text DEFAULT 'pending'::text NOT NULL,
    reject_reason text,
    dispatch_attempts integer DEFAULT 0 NOT NULL,
    last_attempt_at timestamp with time zone,
    last_error text DEFAULT ''::text NOT NULL,
    processed_at timestamp with time zone,
    correlation_activity_id uuid,
    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,
    decrypted_with_key_version integer,
    CONSTRAINT federation_inbox_status_check CHECK ((status = ANY (ARRAY['pending'::text, 'processed'::text, 'rejected'::text, 'failed'::text])))
);

---

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