Forum Discussions Table Schema (forum_discussions)


Description

Forums are composed of discussions

forum_discussions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
forum_discussion_subs.discussion forudiscsubs_dis2_fk R
forum_posts.discussion forupost_dis2_fk R
forum_queue.discussionid foruqueu_dis2_fk R
course bigint 10 0
forum bigint 10 0
forum.id forudisc_for2_fk R
name varchar 255
firstpost bigint 10 0
userid bigint 10 0
user.id Implied Constraint R
groupid bigint 10 -1
assessed BIT 1 1
timemodified bigint 10 0
usermodified bigint 10 0
timestart bigint 10 0
timeend bigint 10 0
pinned BIT 1 0

Table contained -1 rows

forum_discussions table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
forudisc_cou_ix Performance Asc course
forudisc_for_ix Performance Asc forum
forudisc_use_ix Performance Asc userid

forum_discussions table relationships