Table
competencyassessmentresponses
Each row represents one question within a competency assessment attempt, including question text, answer, and correctness.
statusgroupRedshift
All tables
competencyassessmentresponses
Each row represents one question within a competency assessment attempt, including question text, answer, and correctness.
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) |
userid | varchar(36) |
competencyassessmentid | varchar(36) |
competencyassessmentattemptid | varchar(36) |
questionid | varchar(36) |
question | varchar(65535) |
type | varchar(256) |
answer | varchar(65535) |
correct | bool |
createdat | timestamp |
updatedat | timestamp |
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.userid,
t.competencyassessmentid,
t.competencyassessmentattemptid,
t.questionid,
t.question
from competencyassessmentresponses as t
limit 100