Table: federation_remote_actors

Connected to

This table references:

• federation_peers(id) via column peer_id

Columns

Column	Type	Nullable	Notes
actor_uri	text	no	—
peer_id	uuid	no	References federation_peers(id)
display_name	text	no	Default ''::text
avatar_url	text	no	Default ''::text
first_seen_at	timestamp	no	Default now()
last_seen_at	timestamp	no	Default now()
updated_at	timestamp	no	Default now()
encryption_public_key	bytea	yes	—
encryption_public_key_version	integer	yes	—
encryption_public_key_updated_at	timestamp	yes	—

Constraints

• CONSTRAINT federation_remote_actors_encryption_key_atomic CHECK ((((encryption_public_key IS NULL) AND (encryption_public_key_version IS NULL) AND (encryption_public_key_updated_at IS NULL)) OR ((encryption_public_key IS NOT NULL) AND (octet_length(encryption_public_key) = 32) AND (encryption_public_key_version IS NOT NULL) AND (encryption_public_key_version >= 1) AND (encryption_public_key_updated_at IS NOT NULL))))

Full DDL

CREATE TABLE public.federation_remote_actors (
    actor_uri text NOT NULL,
    peer_id uuid NOT NULL,
    display_name text DEFAULT ''::text NOT NULL,
    avatar_url text DEFAULT ''::text NOT NULL,
    first_seen_at timestamp with time zone DEFAULT now() NOT NULL,
    last_seen_at timestamp with time zone DEFAULT now() NOT NULL,
    updated_at timestamp with time zone DEFAULT now() NOT NULL,
    encryption_public_key bytea,
    encryption_public_key_version integer,
    encryption_public_key_updated_at timestamp with time zone,
    CONSTRAINT federation_remote_actors_encryption_key_atomic CHECK ((((encryption_public_key IS NULL) AND (encryption_public_key_version IS NULL) AND (encryption_public_key_updated_at IS NULL)) OR ((encryption_public_key IS NOT NULL) AND (octet_length(encryption_public_key) = 32) AND (encryption_public_key_version IS NOT NULL) AND (encryption_public_key_version >= 1) AND (encryption_public_key_updated_at IS NOT NULL))))
);

---

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