Table

quizattempts

Each row represents a single quiz sitting by a learner, including score, pass/fail, duration, and topic linkage.

statusgroupRedshift

Each row represents a single quiz sitting by a learner, including score, pass/fail, duration, and topic linkage.

Full schema

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

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.topictype,
  t.grade
from quizattempts as t
limit 100