Table
questionchoices
Each row represents an answer option for a quiz question, including correctness, points, and order.
statusgroupRedshift
All tables
questionchoices
Each row represents an answer option for a quiz question, including correctness, points, and order.
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) |
questionid | varchar(36) |
correct | bool |
points | int4 |
order | int4 |
deleted | bool |
value | varchar(65535) |
response | varchar(65535) |
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.
Sample query
select
t.questionid,
t.correct,
t.points,
t.order,
t.value
from questionchoices as t
limit 100