Block Recent Activity table / block_recent_activity - Moodle LMS 3.9 Database schema / Zoola Analytics

block_recent_activity table columns

Related columns Constraint Comments

Search:

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

blocreceacti_use_fk 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)

Showing 1 to 7 of 7 entries

Table contained -1 rows

block_recent_activity table indexes

Search:

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

Showing 1 to 3 of 3 entries

Block Recent Activity Table Schema (block_recent_activity)

Description

block_recent_activity table columns

block_recent_activity table indexes

block_recent_activity table relationships

Close relationships within degrees of separation