Stats Weekly Table Schema (stats_weekly)


Description

To accumulate weekly stats

stats_weekly table columns

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.

Table contained -1 rows

stats_weekly table indexes

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

stats_weekly table relationships