Block Recentlyaccesseditems Table Schema (block_recentlyaccesseditems)


Description

Most recently accessed items accessed by a user

block_recentlyaccesseditems table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
courseid BIGINT 19 null
course.id blocrece_cou2_fk R

Course id the item belongs to
cmid BIGINT 19 null
course_modules.id blocrece_cmi2_fk R

Item course module id
userid BIGINT 19 null
user.id blocrece_use2_fk R

User id that accessed the item
timeaccess BIGINT 19 null

Time the user accessed the last time an item

Table contained -1 rows

block_recentlyaccesseditems table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
blocrece_cmi_ix Performance Asc cmid
blocrece_cou_ix Performance Asc courseid
blocrece_use_ix Performance Asc userid
blocrece_usecoucmi_uix Must be unique Asc/Asc/Asc userid + courseid + cmid

block_recentlyaccesseditems table relationships

Close relationships within degrees of separation