Forums Schema

forums

Top-level forum containers.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
owner_id	uuid	NO	—
course_id	uuid	YES	—
title	text	NO	—
slug	text	NO	—
description	text	YES	—
topic_count	integer	NO	0
post_count	integer	NO	0
sort_order	integer	NO	0
status	text	NO	'active'
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

topics

Discussion threads within a forum.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
forum_id	uuid	NO	—
user_id	uuid	NO	—
title	text	NO	—
slug	text	NO	—
content	text	NO	—
is_pinned	boolean	NO	false
is_locked	boolean	NO	false
reply_count	integer	NO	0
like_count	integer	NO	0
view_count	integer	NO	0
last_reply_at	timestamptz	YES	—
last_reply_by	uuid	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

posts

Replies within a topic (threaded via parent_id).

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
topic_id	uuid	NO	—
user_id	uuid	NO	—
parent_id	uuid	YES	—
content	text	NO	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

topic_likes

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
topic_id	uuid	NO	—
user_id	uuid	NO	—
created_at	timestamptz	NO	now()

topic_bookmarks

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
topic_id	uuid	NO	—
user_id	uuid	NO	—
created_at	timestamptz	NO	now()