Table: collections

Connected to

This table references:

• assets(id) via column cover_asset_id
• assets(id) via column featured_cover_asset_id

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	—
deleted_by_user_ref	bigint	yes	—
cover_asset_id	uuid	yes	References assets(id)
featured_cover_asset_id	uuid	yes	References assets(id)
featured_cover_focal_x	double	yes	—
featured_cover_focal_y	double	yes	—
cover_focal_x	double	yes	—
cover_focal_y	double	yes	—
featured_cover_zoom	double	yes	—
cover_zoom	double	yes	—

Constraints

• CONSTRAINT collections_cover_focal_check CHECK ((((cover_focal_x IS NULL) AND (cover_focal_y IS NULL)) OR (((cover_focal_x >= (0)::double precision) AND (cover_focal_x <= (1)::double precision)) AND ((cover_focal_y >= (0)::double precision) AND (cover_focal_y <= (1)::double precision)))))
• CONSTRAINT collections_cover_zoom_check CHECK (((cover_zoom IS NULL) OR ((cover_zoom >= (1)::double precision) AND (cover_zoom <= (4)::double precision))))
• CONSTRAINT collections_featured_cover_focal_check CHECK ((((featured_cover_focal_x IS NULL) AND (featured_cover_focal_y IS NULL)) OR (((featured_cover_focal_x >= (0)::double precision) AND (featured_cover_focal_x <= (1)::double precision)) AND ((featured_cover_focal_y >= (0)::double precision) AND (featured_cover_focal_y <= (1)::double precision)))))
• CONSTRAINT collections_featured_cover_zoom_check CHECK (((featured_cover_zoom IS NULL) OR ((featured_cover_zoom >= (1)::double precision) AND (featured_cover_zoom <= (4)::double precision))))
• 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,
    deleted_by_user_ref bigint,
    cover_asset_id uuid,
    featured_cover_asset_id uuid,
    featured_cover_focal_x double precision,
    featured_cover_focal_y double precision,
    cover_focal_x double precision,
    cover_focal_y double precision,
    featured_cover_zoom double precision,
    cover_zoom double precision,
    CONSTRAINT collections_cover_focal_check CHECK ((((cover_focal_x IS NULL) AND (cover_focal_y IS NULL)) OR (((cover_focal_x >= (0)::double precision) AND (cover_focal_x <= (1)::double precision)) AND ((cover_focal_y >= (0)::double precision) AND (cover_focal_y <= (1)::double precision))))),
    CONSTRAINT collections_cover_zoom_check CHECK (((cover_zoom IS NULL) OR ((cover_zoom >= (1)::double precision) AND (cover_zoom <= (4)::double precision)))),
    CONSTRAINT collections_featured_cover_focal_check CHECK ((((featured_cover_focal_x IS NULL) AND (featured_cover_focal_y IS NULL)) OR (((featured_cover_focal_x >= (0)::double precision) AND (featured_cover_focal_x <= (1)::double precision)) AND ((featured_cover_focal_y >= (0)::double precision) AND (featured_cover_focal_y <= (1)::double precision))))),
    CONSTRAINT collections_featured_cover_zoom_check CHECK (((featured_cover_zoom IS NULL) OR ((featured_cover_zoom >= (1)::double precision) AND (featured_cover_zoom <= (4)::double precision)))),
    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-09-23T03:23:00.434Z.