Table
lessons
Each row represents a lesson within a course section, including title, slug, and hierarchy keys.
statusgroupRedshift
All tables
lessons
Each row represents a lesson within a course section, including title, slug, and hierarchy keys.
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) |
sectionid | varchar(36) |
courseid | varchar(36) |
slug | varchar(32) |
title | varchar(255) |
updatedat | 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.sectionid,
t.courseid,
t.slug,
t.title
from lessons as t
limit 100