Stats Weekly table / stats_weekly - Moodle LMS 3.9 Database schema / Zoola Analytics

stats_weekly 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_weekly table indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
statweek_cou_ix	Performance	Asc	courseid
statweek_rol_ix	Performance	Asc	roleid
statweek_tim_ix	Performance	Asc	timeend

Showing 1 to 4 of 4 entries

Stats Weekly Table Schema (stats_weekly)

Description

stats_weekly table columns

stats_weekly table indexes

stats_weekly table relationships

Close relationships within degrees of separation