Forum Read table / forum_read - Totara Learn 12 Database schema / Zoola Analytics

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 Schema (forum_read)

Description

forum_read table columns

forum_read table indexes

forum_read table relationships

Close relationships within degrees of separation