Table
courseactions
Each row represents a time-stamped learning event in a course (such as a view or progress milestone) with user and license context.
statusgroupRedshift
All tables
courseactions
Each row represents a time-stamped learning event in a course (such as a view or progress milestone) with user and license context.
Full schema
View all columns and table relationships (SchemaSpy)Status group
Yes, this table includes a statusgroup column. See Status Group for details.
Column details
| Column | Type |
|---|---|
companyid | varchar(36) |
id | varchar(36) |
courseid | varchar(36) |
source | varchar(32) |
type | varchar(32) |
userid | varchar(36) |
timestamp | timestamp |
migrated | int4 |
updatedat | timestamp |
licenseid | varchar(36) |
createdat | timestamp |
statusgroup | varchar(256) |
statusgroupupdatedat | timestamp |
Column names and types come from the Redshift analytics schema. SchemaSpy is authoritative for nullability, defaults, keys, and relationships.
Sample query
select
t.courseid,
t.source,
t.type,
t.userid,
t.licenseid
from courseactions as t
limit 100