Table
ltiattempts
Each row represents an external-tool assessment attempt linked to a course topic, with score and timing.
Redshift
All tables
ltiattempts
Each row represents an external-tool assessment attempt linked to a course topic, with score and timing.
Full schema
View all columns and table relationships (SchemaSpy)Status group
No, this table does not include a statusgroup column.
Column details
| Column | Type |
|---|---|
companyid | varchar(36) |
id | varchar(36) |
courseid | varchar(36) |
userid | varchar(36) |
topicid | varchar(36) |
topictype | varchar(32) |
resultscore | float8 |
createdat | timestamp |
updatedat | 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.topictype,
t.resultscore
from ltiattempts as t
limit 100