forum_discussions

0 rows


Description

Forums are composed of discussions

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
forum_discussion_subs.discussion forudiscsubs_dis2_fkR
forum_posts.discussion forupost_dis2_fkR
forum_queue.discussionid foruqueu_dis2_fkR
forum_read.discussionid forum_read_erd_discussions_idR
course BIGINT 19 0
forum BIGINT 19 0
forum.id forudisc_for2_fkR
name VARCHAR 255
firstpost BIGINT 19 0
userid BIGINT 19 0
user.id Implied ConstraintR
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
timelocked BIGINT 19 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
forudisc_cou2_ix Performance Asc course
forudisc_for2_ix Performance Asc forum
forudisc_use2_ix Performance Asc userid

Relationships

Close relationships within degrees of separation