stats_user_daily

0 rows


Description

To accumulate daily stats per course/user

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
courseid BIGINT 19 0
course.id stats_user_daily_erd_courseidR
userid BIGINT 19 0
roleid BIGINT 19 0
role.id Implied ConstraintR
timeend BIGINT 19 0
statsreads BIGINT 19 0
statswrites BIGINT 19 0
stattype VARCHAR 30

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
statuserdail_cou2_ix Performance Asc courseid
statuserdail_rol2_ix Performance Asc roleid
statuserdail_tim2_ix Performance Asc timeend
statuserdail_use2_ix Performance Asc userid

Relationships

Close relationships within degrees of separation