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 10 null
userid bigint 10 0
user.id Implied Constraint R
forumid bigint 10 0
forum.id Implied Constraint R
discussionid bigint 10 0
postid bigint 10 0
post.id Implied Constraint R
firstread bigint 10 0
lastread bigint 10 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