Table
courses
Each row represents an individual course offering with pricing, enrollment windows, seats, progress aggregates, and linkage to a course group.
statusgroupRedshift
All tables
courses
Each row represents an individual course offering with pricing, enrollment windows, seats, progress aggregates, and linkage to a course group.
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) |
clientid | varchar(36) |
status | varchar(16) |
totalviews | int4 |
title | varchar(1024) |
slug | varchar(1024) |
coursegroupid | varchar(36) |
parentcourseid | varchar(36) |
kind | varchar(32) |
contenttype | varchar(32) |
createdat | timestamp |
author | varchar(512) |
source | varchar(512) |
updatedat | timestamp |
seatslimit | int4 |
seatsused | int4 |
priceincents | float8 |
balancerequirement | float8 |
graceperiodenddate | timestamp |
enrollmentenddate | timestamp |
enrollmentstartdate | timestamp |
startdate | timestamp |
enddate | timestamp |
sku | varchar(65535) |
totaltime | int8 |
statusgroup | varchar(256) |
statusgroupupdatedat | timestamp |
Column names and types come from the Redshift analytics schema. SchemaSpy is authoritative for nullability, defaults, keys, and relationships.
Platform Documentation
Sample query
select
t.clientid,
t.totalviews,
t.title,
t.slug,
t.coursegroupid
from courses as t
limit 100