Table: federation_directory_entries

Connected to

This table references:

• federation_directories(id) via column directory_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
directory_id	uuid	no	References federation_directories(id)
instance_url	text	no	—
display_name	text	no	—
instance_public_key	text	no	—
fingerprint	text	no	—
region	text	no	Default ''::text
description	text	no	Default ''::text
tags	jsonb	no	Default '[]'::jsonb
verified_at	timestamp	no	—
verified_via	text	no	—
listing_id	text	no	Default ''::text
cached_at	timestamp	no	Default now()

Full DDL

CREATE TABLE public.federation_directory_entries (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    directory_id uuid NOT NULL,
    instance_url text NOT NULL,
    display_name text NOT NULL,
    instance_public_key text NOT NULL,
    fingerprint text NOT NULL,
    region text DEFAULT ''::text NOT NULL,
    description text DEFAULT ''::text NOT NULL,
    tags jsonb DEFAULT '[]'::jsonb NOT NULL,
    verified_at timestamp with time zone NOT NULL,
    verified_via text NOT NULL,
    listing_id text DEFAULT ''::text NOT NULL,
    cached_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.