Stats User Weekly Table Schema (stats_user_weekly)


Description

To accumulate weekly stats per course/user

stats_user_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
userid BIGINT 19 0
user.id Implied Constraint R
roleid BIGINT 19 0
role.id Implied Constraint R
timeend BIGINT 19 0
statsreads BIGINT 19 0
statswrites BIGINT 19 0
stattype VARCHAR 30

Table contained -1 rows

stats_user_weekly table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
statuserweek_cou_ix Performance Asc courseid
statuserweek_rol_ix Performance Asc roleid
statuserweek_tim_ix Performance Asc timeend
statuserweek_use_ix Performance Asc userid

stats_user_weekly table relationships

Close relationships within degrees of separation