Stats Monthly table / stats_monthly - Moodle LMS 3.9 Database schema / Zoola Analytics

stats_monthly table columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

courseid

BIGINT

19

0

course.id

Implied Constraint R

timeend

BIGINT

19

0

roleid

BIGINT

19

0

role.id

Implied Constraint R

id of role for the aggregates

stattype

VARCHAR

20

activity

type of stat

stat1

BIGINT

19

0

stat1. usually used for reads

stat2

BIGINT

19

0

stat2. usually used for writes.

Showing 1 to 7 of 7 entries

Table contained -1 rows

stats_monthly table indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
statmont_cou_ix	Performance	Asc	courseid
statmont_rol_ix	Performance	Asc	roleid
statmont_tim_ix	Performance	Asc	timeend

Showing 1 to 4 of 4 entries

Stats Monthly Table Schema (stats_monthly)

Description

stats_monthly table columns

stats_monthly table indexes

stats_monthly table relationships

Close relationships within degrees of separation