Table: federation_peers

Connected to

Referenced by:

• comments — column peer_id
• federation_inbox — column peer_id
• federation_outbox — column peer_id
• federation_peer_suggestions — column source_peer_id
• federation_remote_actors — column peer_id
• federation_shares — column peer_id
• likes — column peer_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
instance_url	text	no	—
display_name	text	no	—
instance_public_key	text	no	—
trust_tier	text	no	Default 'connected'::text
encryption_policy	text	no	Default 'plaintext'::text
enabled	boolean	no	Default true
status	text	no	Default 'connected'::text
handshake_at	timestamp	no	Default now()
handshake_by_user_ref	bigint	no	—
last_seen_at	timestamp	yes	—
notes	text	no	Default ''::text
share_in_visible_list	boolean	no	Default false
created_at	timestamp	no	Default now()
updated_at	timestamp	no	Default now()
capabilities	jsonb	no	Default '[]'::jsonb
capabilities_negotiated_at	timestamp	yes	—

Constraints

• CONSTRAINT federation_peers_encryption_policy_check CHECK ((encryption_policy = ANY (ARRAY['plaintext'::text, 'e2e-encrypted'::text])))
• CONSTRAINT federation_peers_status_check CHECK ((status = ANY (ARRAY['pending_outbound'::text, 'pending_inbound'::text, 'connected'::text])))
• CONSTRAINT federation_peers_trust_tier_check CHECK ((trust_tier = ANY (ARRAY['connected'::text, 'directory-listed'::text, 'auto-sync'::text])))

Full DDL

CREATE TABLE public.federation_peers (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    instance_url text NOT NULL,
    display_name text NOT NULL,
    instance_public_key text NOT NULL,
    trust_tier text DEFAULT 'connected'::text NOT NULL,
    encryption_policy text DEFAULT 'plaintext'::text NOT NULL,
    enabled boolean DEFAULT true NOT NULL,
    status text DEFAULT 'connected'::text NOT NULL,
    handshake_at timestamp with time zone DEFAULT now() NOT NULL,
    handshake_by_user_ref bigint NOT NULL,
    last_seen_at timestamp with time zone,
    notes text DEFAULT ''::text NOT NULL,
    share_in_visible_list boolean DEFAULT false NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    updated_at timestamp with time zone DEFAULT now() NOT NULL,
    capabilities jsonb DEFAULT '[]'::jsonb NOT NULL,
    capabilities_negotiated_at timestamp with time zone,
    CONSTRAINT federation_peers_encryption_policy_check CHECK ((encryption_policy = ANY (ARRAY['plaintext'::text, 'e2e-encrypted'::text]))),
    CONSTRAINT federation_peers_status_check CHECK ((status = ANY (ARRAY['pending_outbound'::text, 'pending_inbound'::text, 'connected'::text]))),
    CONSTRAINT federation_peers_trust_tier_check CHECK ((trust_tier = ANY (ARRAY['connected'::text, 'directory-listed'::text, 'auto-sync'::text])))
);

---

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