Skip to content

Forums Schema

Top-level forum containers.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
owner_iduuidNO—
course_iduuidYES—
titletextNO—
slugtextNO—
descriptiontextYES—
topic_countintegerNO0
post_countintegerNO0
sort_orderintegerNO0
statustextNO'active'
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Discussion threads within a forum.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
forum_iduuidNO—
user_iduuidNO—
titletextNO—
slugtextNO—
contenttextNO—
is_pinnedbooleanNOfalse
is_lockedbooleanNOfalse
reply_countintegerNO0
like_countintegerNO0
view_countintegerNO0
last_reply_attimestamptzYES—
last_reply_byuuidYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Replies within a topic (threaded via parent_id).

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
topic_iduuidNO—
user_iduuidNO—
parent_iduuidYES—
contenttextNO—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
topic_iduuidNO—
user_iduuidNO—
created_attimestamptzNOnow()
ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
topic_iduuidNO—
user_iduuidNO—
created_attimestamptzNOnow()