Table: collection_posts

Connected to

This table references:

• collections(id) via column collection_id
• posts(id) via column post_id

Columns

Column	Type	Nullable	Notes
collection_id	uuid	no	References collections(id)
post_id	uuid	no	References posts(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_posts (
    collection_id uuid NOT NULL,
    post_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.