Table
scormattemptresponses
Each row represents a SCORM interaction-level detail under an attempt, including prompt, learner response, and result.
statusgroupRedshift
All tables
scormattemptresponses
Each row represents a SCORM interaction-level detail under an attempt, including prompt, learner response, and result.
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 |
|---|---|
companyid | varchar(36) |
id | varchar(36) |
courseid | varchar(36) |
userid | varchar(36) |
topicid | varchar(36) |
scormattemptid | varchar(36) |
questiondescription | varchar(65535) |
studentresponse | varchar(65535) |
result | varchar(16) |
createdat | timestamp |
updatedat | timestamp |
licenseid | varchar(36) |
questionid | 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.
Sample query
select
t.courseid,
t.userid,
t.topicid,
t.scormattemptid,
t.questiondescription
from scormattemptresponses as t
limit 100