Table
userlearningpaths
Each row represents a user's assignment to a learning path with status, due dates, and related program identifiers.
statusgroupRedshift
All tables
userlearningpaths
Each row represents a user's assignment to a learning path with status, due dates, and related program identifiers.
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 |
|---|---|
id | varchar(36) |
companyid | varchar(36) |
userid | varchar(36) |
learningpathid | varchar(36) |
programid | varchar(36) |
bundleid | varchar(36) |
status | varchar(65535) |
updatedat | timestamp |
duedate | 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.userid,
t.learningpathid,
t.programid,
t.bundleid,
t.duedate
from userlearningpaths as t
limit 100