Table: collection_resources

Connected to

This table references:

• collections(id) via column collection_id
• assets(id) via column asset_id

Columns

Column	Type	Nullable	Notes
collection_id	uuid	no	References collections(id)
asset_id	uuid	no	References assets(id)
sort_order	integer	no	Default 0
pinned	boolean	no	Default true
expires_at	timestamp	yes	—
added_at	timestamp	no	Default now()

Full DDL

CREATE TABLE public.collection_resources (
    collection_id uuid NOT NULL,
    asset_id uuid NOT NULL,
    sort_order integer DEFAULT 0 NOT NULL,
    pinned boolean DEFAULT true NOT NULL,
    expires_at timestamp with time zone,
    added_at timestamp with time zone DEFAULT now() NOT NULL
);

---

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