Table

usercourseprogresses

Each row represents roll-up progress for a user on a course, including percent complete, time, and views.

statusgroupRedshift

Each row represents roll-up progress for a user on a course, including percent complete, time, and views.

Full schema

Yes, this table includes a statusgroup column. See Status Group for details.

Column names and types come from the Redshift analytics schema. SchemaSpy is authoritative for nullability, defaults, keys, and relationships.

select
  t.userid,
  t.courseid,
  t.totaltime,
  t.totalviews,
  t.percentcomplete
from usercourseprogresses as t
limit 100