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 10 null
courseid bigint 10 null
course.id Implied Constraint R

Course id

cmid bigint 10 null

Course module id

timecreated bigint 10 null
userid bigint 10 null
user.id Implied Constraint R

User performing the action

action BIT 1 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