Table: collections

Connected to

Referenced by:

• collection_acls — column collection_id
• collection_field_value — column collection_id
• collection_field_value_history — column collection_id
• collection_posts — column collection_id
• collection_resources — column collection_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
owner_user_ref	bigint	no	—
name	text	no	—
description	text	no	Default ''::text
visibility	text	no	Default 'private'::text
membership	text	no	Default 'manual'::text
expires_at	timestamp	yes	—
purpose	text	yes	—
origin_server_id	uuid	yes	—
created_at	timestamp	no	Default now()
updated_at	timestamp	no	Default now()
search_text	tsvector	yes	—
smart_query	text	yes	—
deleted_at	timestamp	yes	—
deleted_reason	text	yes	—

Constraints

• CONSTRAINT collections_membership_check CHECK ((membership = ANY (ARRAY['manual'::text, 'query'::text, 'hybrid'::text])))
• CONSTRAINT collections_visibility_check CHECK ((visibility = ANY (ARRAY['private'::text, 'org-only'::text, 'followers'::text, 'explicit-share'::text, 'public'::text])))

Full DDL

CREATE TABLE public.collections (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    owner_user_ref bigint NOT NULL,
    name text NOT NULL,
    description text DEFAULT ''::text NOT NULL,
    visibility text DEFAULT 'private'::text NOT NULL,
    membership text DEFAULT 'manual'::text NOT NULL,
    expires_at timestamp with time zone,
    purpose text,
    origin_server_id uuid,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    updated_at timestamp with time zone DEFAULT now() NOT NULL,
    search_text tsvector,
    smart_query text,
    deleted_at timestamp with time zone,
    deleted_reason text,
    CONSTRAINT collections_membership_check CHECK ((membership = ANY (ARRAY['manual'::text, 'query'::text, 'hybrid'::text]))),
    CONSTRAINT collections_visibility_check CHECK ((visibility = ANY (ARRAY['private'::text, 'org-only'::text, 'followers'::text, 'explicit-share'::text, 'public'::text])))
);

---

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