# 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