Table: post_assets

Connected to

This table references:

• posts(id) via column post_id
• assets(id) via column asset_id

Columns

Column	Type	Nullable	Notes
post_id	uuid	no	References posts(id)
asset_id	uuid	no	References assets(id)
sort_order	integer	no	Default 0
added_at	timestamp	no	Default now()

Full DDL

CREATE TABLE public.post_assets (
    post_id uuid NOT NULL,
    asset_id uuid NOT NULL,
    sort_order integer DEFAULT 0 NOT NULL,
    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.