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
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
foruread_disuse_ix Performance Asc/Asc discussionid + userid
foruread_foruse_ix Performance Asc/Asc forumid + userid
foruread_posuse_ix Performance Asc/Asc postid + userid
foruread_use_ix Performance Asc userid

Relationships