stats_monthly

0 rows


Description

To accumulate monthly stats

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
courseid BIGINT 19 0
course.id stats_monthly_erd_courseidR
timeend BIGINT 19 0
roleid BIGINT 19 0
role.id Implied ConstraintR
stattype VARCHAR 20 activity
stat1 BIGINT 19 0
stat2 BIGINT 19 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
statmont_cou2_ix Performance Asc courseid
statmont_rol2_ix Performance Asc roleid
statmont_tim2_ix Performance Asc timeend

Relationships

Close relationships within degrees of separation