Stats Daily table / stats_daily - Totara Learn 12 Database schema / Zoola Analytics

stats_daily 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_daily table indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
statdail_cou_ix	Performance	Asc	courseid
statdail_rol_ix	Performance	Asc	roleid
statdail_tim_ix	Performance	Asc	timeend

Showing 1 to 4 of 4 entries

Stats Daily Table Schema (stats_daily)

Description

stats_daily table columns

stats_daily table indexes

stats_daily table relationships

Close relationships within degrees of separation