Block Recentlyaccesseditems Table Schema (block_recentlyaccesseditems)


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

Course id the item belongs to

cmid BIGINT 19 null blocrece_cmi2_fk R

Item course module id

userid BIGINT 19 null 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