Table: federation_shares

Connected to

This table references:

• federation_peers(id) via column peer_id
• activities(id) via column granted_activity_id
• activities(id) via column revoked_activity_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
grantor_user_ref	bigint	no	—
object_kind	text	no	—
object_id	uuid	no	—
peer_id	uuid	no	References federation_peers(id)
target_user_url	text	yes	—
scope	text	no	Default 'view'::text
expires_at	timestamp	yes	—
notes	text	no	Default ''::text
granted_activity_id	uuid	no	References activities(id)
granted_at	timestamp	no	Default now()
revoked_at	timestamp	yes	—
revoked_activity_id	uuid	yes	References activities(id)
created_at	timestamp	no	Default now()
updated_at	timestamp	no	Default now()

Constraints

• CONSTRAINT federation_shares_object_kind_check CHECK ((object_kind = ANY (ARRAY['asset'::text, 'post'::text, 'collection'::text, 'workspace'::text, 'brand_kit'::text, 'user'::text])))
• CONSTRAINT federation_shares_scope_check CHECK ((scope = ANY (ARRAY['view'::text, 'comment'::text, 'annotate'::text, 'remix'::text])))

Full DDL

CREATE TABLE public.federation_shares (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    grantor_user_ref bigint NOT NULL,
    object_kind text NOT NULL,
    object_id uuid NOT NULL,
    peer_id uuid NOT NULL,
    target_user_url text,
    scope text DEFAULT 'view'::text NOT NULL,
    expires_at timestamp with time zone,
    notes text DEFAULT ''::text NOT NULL,
    granted_activity_id uuid NOT NULL,
    granted_at timestamp with time zone DEFAULT now() NOT NULL,
    revoked_at timestamp with time zone,
    revoked_activity_id uuid,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    updated_at timestamp with time zone DEFAULT now() NOT NULL,
    CONSTRAINT federation_shares_object_kind_check CHECK ((object_kind = ANY (ARRAY['asset'::text, 'post'::text, 'collection'::text, 'workspace'::text, 'brand_kit'::text, 'user'::text]))),
    CONSTRAINT federation_shares_scope_check CHECK ((scope = ANY (ARRAY['view'::text, 'comment'::text, 'annotate'::text, 'remix'::text])))
);

---

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