Table: federation_directories

Connected to

Referenced by:

• federation_directory_entries — column directory_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
directory_url	text	no	—
operator_name	text	no	Default ''::text
operator_public_key	text	no	—
operator_fingerprint	text	no	—
operator_contact	text	no	Default ''::text
subscribed_at	timestamp	no	Default now()
subscribed_by_user_ref	bigint	no	—
enabled	boolean	no	Default true
last_polled_at	timestamp	yes	—
last_poll_status	text	no	Default 'never_polled'::text
last_poll_error	text	no	Default ''::text
poll_interval_seconds	integer	no	Default 21600
notes	text	no	Default ''::text
publish_status	text	no	Default 'not_published'::text
publish_pending_token	text	no	Default ''::text
publish_token_expires_at	timestamp	yes	—
publish_record_name	text	no	Default ''::text
publish_record_value	text	no	Default ''::text
publish_listing_id	text	no	Default ''::text
publish_last_attempt_at	timestamp	yes	—
publish_last_error	text	no	Default ''::text
publish_display_name	text	no	Default ''::text
publish_region	text	no	Default ''::text
publish_description	text	no	Default ''::text
publish_tags	jsonb	no	Default '[]'::jsonb
created_at	timestamp	no	Default now()
updated_at	timestamp	no	Default now()

Constraints

• CONSTRAINT federation_directories_last_poll_status_check CHECK ((last_poll_status = ANY (ARRAY['never_polled'::text, 'ok'::text, 'unreachable'::text, 'signature_failed'::text, 'malformed'::text, 'spec_version_mismatch'::text])))
• CONSTRAINT federation_directories_poll_interval_seconds_check CHECK ((poll_interval_seconds >= 300))
• CONSTRAINT federation_directories_publish_status_check CHECK ((publish_status = ANY (ARRAY['not_published'::text, 'pending_dns'::text, 'pending_register'::text, 'listed'::text, 'failed'::text])))

Full DDL

CREATE TABLE public.federation_directories (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    directory_url text NOT NULL,
    operator_name text DEFAULT ''::text NOT NULL,
    operator_public_key text NOT NULL,
    operator_fingerprint text NOT NULL,
    operator_contact text DEFAULT ''::text NOT NULL,
    subscribed_at timestamp with time zone DEFAULT now() NOT NULL,
    subscribed_by_user_ref bigint NOT NULL,
    enabled boolean DEFAULT true NOT NULL,
    last_polled_at timestamp with time zone,
    last_poll_status text DEFAULT 'never_polled'::text NOT NULL,
    last_poll_error text DEFAULT ''::text NOT NULL,
    poll_interval_seconds integer DEFAULT 21600 NOT NULL,
    notes text DEFAULT ''::text NOT NULL,
    publish_status text DEFAULT 'not_published'::text NOT NULL,
    publish_pending_token text DEFAULT ''::text NOT NULL,
    publish_token_expires_at timestamp with time zone,
    publish_record_name text DEFAULT ''::text NOT NULL,
    publish_record_value text DEFAULT ''::text NOT NULL,
    publish_listing_id text DEFAULT ''::text NOT NULL,
    publish_last_attempt_at timestamp with time zone,
    publish_last_error text DEFAULT ''::text NOT NULL,
    publish_display_name text DEFAULT ''::text NOT NULL,
    publish_region text DEFAULT ''::text NOT NULL,
    publish_description text DEFAULT ''::text NOT NULL,
    publish_tags jsonb DEFAULT '[]'::jsonb NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    updated_at timestamp with time zone DEFAULT now() NOT NULL,
    CONSTRAINT federation_directories_last_poll_status_check CHECK ((last_poll_status = ANY (ARRAY['never_polled'::text, 'ok'::text, 'unreachable'::text, 'signature_failed'::text, 'malformed'::text, 'spec_version_mismatch'::text]))),
    CONSTRAINT federation_directories_poll_interval_seconds_check CHECK ((poll_interval_seconds >= 300)),
    CONSTRAINT federation_directories_publish_status_check CHECK ((publish_status = ANY (ARRAY['not_published'::text, 'pending_dns'::text, 'pending_register'::text, 'listed'::text, 'failed'::text])))
);

---

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