Table: posts

Connected to

This table references:

• assets(id) via column cover_asset_id
• workflow_states(id) via column state_id
• teams(id) via column team_id
• assets(id) via column cover_thumbnail_asset_id

Referenced by:

• collection_posts — column post_id
• post_acls — column post_id
• post_assets — column post_id
• post_tags — column post_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
author_user_ref	bigint	no	—
title	text	no	Default ''::text
description	text	no	Default ''::text
visibility	text	no	Default 'org-only'::text
cover_asset_id	uuid	yes	References assets(id)
posted_at	timestamp	no	Default now()
like_count	bigint	no	Default 0
comment_count	bigint	no	Default 0
search_text	tsvector	yes	—
origin_server_id	uuid	yes	—
deleted_at	timestamp	yes	—
created_at	timestamp	no	Default now()
updated_at	timestamp	no	Default now()
state_id	uuid	yes	References workflow_states(id)
team_id	uuid	yes	References teams(id)
cover_thumbnail_asset_id	uuid	yes	References assets(id)
subtitle_track_override	jsonb	yes	—
deleted_reason	text	yes	—

Constraints

• CONSTRAINT posts_visibility_check CHECK ((visibility = ANY (ARRAY['private'::text, 'org-only'::text, 'followers'::text, 'explicit-share'::text, 'public'::text])))

Full DDL

CREATE TABLE public.posts (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    author_user_ref bigint NOT NULL,
    title text DEFAULT ''::text NOT NULL,
    description text DEFAULT ''::text NOT NULL,
    visibility text DEFAULT 'org-only'::text NOT NULL,
    cover_asset_id uuid,
    posted_at timestamp with time zone DEFAULT now() NOT NULL,
    like_count bigint DEFAULT 0 NOT NULL,
    comment_count bigint DEFAULT 0 NOT NULL,
    search_text tsvector,
    origin_server_id uuid,
    deleted_at timestamp with time zone,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    updated_at timestamp with time zone DEFAULT now() NOT NULL,
    state_id uuid,
    team_id uuid,
    cover_thumbnail_asset_id uuid,
    subtitle_track_override jsonb,
    deleted_reason text,
    CONSTRAINT posts_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-07-26T08:25:29.520Z.