Table
coursegroups
Each row represents a catalog grouping for courses, including titles, descriptions, and merchandising metadata.
statusgroupRedshift
All tables
coursegroups
Each row represents a catalog grouping for courses, including titles, descriptions, and merchandising metadata.
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) |
contenttype | varchar(65535) |
metatitle | varchar(65535) |
kind | varchar(65535) |
authors | varchar(65535) |
isbn | varchar(13) |
metadescription | varchar(65535) |
description | varchar(65535) |
ribbon | varchar(65535) |
companyid | varchar(36) |
slug | varchar(65535) |
title | varchar(65535) |
source | varchar(65535) |
updatedat | timestamp |
rating | float8 |
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.contenttype,
t.metatitle,
t.kind,
t.authors,
t.isbn
from coursegroups as t
limit 100