Forum Discussion Subs Table Schema (forum_discussion_subs)


Description

Users may choose to subscribe and unsubscribe from specific discussions.

forum_discussion_subs table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
forum bigint 10 null
forum.id forudiscsubs_for2_fk R
userid bigint 10 null
user.id forudiscsubs_use2_fk R
discussion bigint 10 null
forum_discussions.id forudiscsubs_dis2_fk R
preference bigint 10 1

Table contained -1 rows

forum_discussion_subs table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
forudiscsubs_dis_ix Performance Asc discussion
forudiscsubs_for_ix Performance Asc forum
forudiscsubs_use_ix Performance Asc userid
forudiscsubs_usedis_uix Must be unique Asc/Asc userid + discussion

forum_discussion_subs table relationships