block_recentlyaccesseditems

0 rows


Description

Most recently accessed items accessed by a user

Columns

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

Course id the item belongs to

cmid BIGINT 19 null
course_modules.id blocrece_cmi2_fkR

Item course module id

userid BIGINT 19 null
user.id blocrece_use2_fkR

User id that accessed the item

timeaccess BIGINT 19 null

Time the user accessed the last time an item

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

Relationships