forum_read

0 rows


Description

Tracks each users read posts

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 0
user.id Implied ConstraintR
forumid BIGINT 19 0
forum.id forum_read_erd_forum_idR
discussionid BIGINT 19 0
forum_discussions.id forum_read_erd_discussions_idR
postid BIGINT 19 0
forum_posts.id forum_read_erd_post_idR
firstread BIGINT 19 0
lastread BIGINT 19 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
forum_read_erd_discussions_id Performance Asc discussionid
forum_read_erd_forum_id Performance Asc forumid
foruread_posuse2_ix Performance Asc/Asc postid + userid
foruread_usedis2_ix Performance Asc/Asc userid + discussionid
foruread_usefor2_ix Performance Asc/Asc userid + forumid

Relationships