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 19 √ null
forum_discussion_subs.discussion forudiscsubs_dis2_fk R
forum_posts.discussion forupost_dis2_fk R
forum_queue.discussionid foruqueu_dis2_fk R
forum_read.discussionid foruread_dis_fk R
course BIGINT 19 0
forum BIGINT 19 0
forum.id forudisc_for2_fk R
name VARCHAR 255
firstpost BIGINT 19 0
userid BIGINT 19 0
user.id Implied Constraint R
groupid BIGINT 19 -1
assessed BIT 1 1
timemodified BIGINT 19 0
usermodified BIGINT 19 0
timestart BIGINT 19 0
timeend BIGINT 19 0
pinned BIT 1 0
archived BIT 1 0

If archived, then exclude this from the completion criteria

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

Close relationships within degrees of separation