block_recent_activity

0 rows


Description

Recent activity block

Columns

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

Course id

cmid BIGINT 19 null

Course module id

timecreated BIGINT 19 null
userid BIGINT 19 null
user.id block_recent_activity_erd_user_idR

User performing the action

action BIT 1 null

0 created, 1 updated, 2 deleted

modname VARCHAR 20 null

module type name (for delete action)

Indexes

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

Relationships