forum_discussion_subs

0 rows


Description

Users may choose to subscribe and unsubscribe from specific discussions.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
forum BIGINT 19 null
forum.id forudiscsubs_for2_fkR
userid BIGINT 19 null
user.id forudiscsubs_use2_fkR
discussion BIGINT 19 null
forum_discussions.id forudiscsubs_dis2_fkR
preference BIGINT 19 1

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

Relationships