Table

topics

Each row represents an individual learning item inside a lesson (page, video, quiz, SCORM, etc.) with settings such as timers and grading.

statusgroupRedshift

Each row represents an individual learning item inside a lesson (page, video, quiz, SCORM, etc.) with settings such as timers and grading.

Full schema

Yes, this table includes a statusgroup column. See Status Group for details.

Column	Type
`companyid`	varchar(36)
`id`	varchar(36)
`sectionid`	varchar(36)
`lessonid`	varchar(36)
`courseid`	varchar(36)
`title`	varchar(255)
`type`	varchar(32)
`slug`	varchar(32)
`updatedat`	timestamp
`minpassingpercent`	float8
`continueaftertimerexpires`	bool
`hidequestionresults`	bool
`timeperquestioninseconds`	int4
`completiontimeseconds`	int4
`maxattempts`	int4
`timelimitinseconds`	int4
`randomizechoices`	bool
`preventprogression`	bool
`timerenabled`	bool
`hintcontrolenabled`	bool
`questionskipenabled`	bool
`displayallhints`	bool
`navigationdisabled`	bool
`isgraded`	bool
`sidebarishidden`	bool
`statusgroup`	varchar(256)
`statusgroupupdatedat`	timestamp

Column names and types come from the Redshift analytics schema. SchemaSpy is authoritative for nullability, defaults, keys, and relationships.

select
  t.sectionid,
  t.lessonid,
  t.courseid,
  t.title,
  t.type
from topics as t
limit 100