forum_discussion_subs

0 rows


Description

Users may choose to subscribe and unsubscribe from specific

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_dis2_ix Performance Asc discussion
forudiscsubs_for2_ix Performance Asc forum
forudiscsubs_use2_ix Performance Asc userid
forudiscsubs_usedis2_uix Must be unique Asc/Asc userid + discussion

Relationships

Close relationships within degrees of separation