Block Recent Activity Table Schema (block_recent_activity)


Description

Recent activity block

block_recent_activity table columns

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

Course id

cmid BIGINT 19 null

Course module id

timecreated BIGINT 19 null
userid BIGINT 19 null
user.id Implied Constraint R

User performing the action

action BIT 0 null

0 created, 1 updated, 2 deleted

modname VARCHAR 20 null

module type name (for delete action)

Table contained -1 rows

block_recent_activity table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
blocreceacti_coutim_ix Performance Asc/Asc courseid + timecreated

block_recent_activity table relationships