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 Implied Constraint R
discussionid BIGINT 19 0
postid BIGINT 19 0
post.id Implied Constraint 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_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