Table
assignmentsubmissions
Each row represents a single learner submission to a graded assignment, including grade, comment count, and license context.
statusgroupRedshift
All tables
assignmentsubmissions
Each row represents a single learner submission to a graded assignment, including grade, comment count, and license context.
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 |
|---|---|
id | varchar(36) |
companyid | varchar(36) |
companysubdomain | varchar(255) |
companyhost | varchar(255) |
courseid | varchar(36) |
userid | varchar(36) |
assignmentid | varchar(36) |
grade | varchar(16) |
commentscount | int4 |
createdat | timestamp |
migrated | int4 |
updatedat | timestamp |
licenseid | varchar(36) |
numericgrade | float8 |
statusgroup | varchar(256) |
statusgroupupdatedat | timestamp |
Column names and types come from the Redshift analytics schema. SchemaSpy is authoritative for nullability, defaults, keys, and relationships.
Platform Documentation
Sample query
select
t.courseid,
t.userid,
t.assignmentid,
t.grade,
t.commentscount
from assignmentsubmissions as t
limit 100