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.