Totara Learn 12
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
Forum Read Table Schema (forum_read)
Description
Tracks each users read posts
forum_read table columns
Related columns
Constraint
Comments
Search:
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
foruread_for_fk
R
discussionid
BIGINT
19
0
forum_discussions
.id
foruread_dis_fk
R
postid
BIGINT
19
0
forum_posts
.id
foruread_pos_fk
R
firstread
BIGINT
19
0
lastread
BIGINT
19
0
Showing 1 to 7 of 7 entries
Table contained
-1
rows
forum_read table indexes
Search:
Constraint Name
Type
Sort
Column(s)
PRIMARY
Primary key
Asc
id
foruread_dis_fk
Performance
Asc
discussionid
foruread_for_fk
Performance
Asc
forumid
foruread_posuse_ix
Performance
Asc
/
Asc
postid + userid
foruread_usedis_ix
Performance
Asc
/
Asc
userid + discussionid
foruread_usefor_ix
Performance
Asc
/
Asc
userid + forumid
Showing 1 to 6 of 6 entries
forum_read table relationships
Close relationships within degrees of separation
One
Two degrees
One implied
Two implied