forum_read

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 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

Showing 1 to 7 of 7 entries

Indexes

Search:

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

Showing 1 to 6 of 6 entries

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation