Table

quizattemptresponses

Each row represents a per-question outcome within a quiz attempt, including selected answers, correctness, and question text.

statusgroupRedshift

Each row represents a per-question outcome within a quiz attempt, including selected answers, correctness, and question text.

Full schema

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

Column	Type
`companyid`	varchar(36)
`id`	varchar(36)
`courseid`	varchar(36)
`userid`	varchar(36)
`topicid`	varchar(36)
`quizattemptid`	varchar(36)
`question`	varchar(65535)
`answer`	varchar(65535)
`correct`	bool
`createdat`	timestamp
`updatedat`	timestamp
`questionid`	varchar(36)
`quizquestiontype`	varchar(36)
`mustselectallcorrectchoices`	bool
`licenseid`	varchar(36)
`order`	int4
`topictype`	varchar(65535)
`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.courseid,
  t.userid,
  t.topicid,
  t.quizattemptid,
  t.question
from quizattemptresponses as t
limit 100