Forum Read Table Schema (forum_read)


Description

Tracks each users read posts

forum_read table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
userid BIGINT 19 0
user.id Implied Constraint R
forumid BIGINT 19 0
forum.id foruread_for_fk R
discussionid BIGINT 19 0
forum_discussions.id foruread_dis_fk R
postid BIGINT 19 0
forum_posts.id foruread_pos_fk R
firstread BIGINT 19 0
lastread BIGINT 19 0

Table contained -1 rows

forum_read table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
foruread_dis_fk Performance Asc discussionid
foruread_for_fk Performance Asc forumid
foruread_posuse_ix Performance Asc/Asc postid + userid
foruread_usedis_ix Performance Asc/Asc userid + discussionid
foruread_usefor_ix Performance Asc/Asc userid + forumid

forum_read table relationships

Close relationships within degrees of separation