Table
testimonials
Each row represents a learner rating and written review of a course group, with approval state.
statusgroupRedshift
All tables
testimonials
Each row represents a learner rating and written review of a course group, with approval state.
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) |
userid | varchar(36) |
userfirstname | varchar(255) |
userlastname | varchar(255) |
useremail | varchar(255) |
coursegroupid | varchar(36) |
coursegrouptitle | varchar(1024) |
rating | int4 |
approved | bool |
body | varchar(65535) |
createdat | timestamp |
updatedat | timestamp |
licenseid | varchar(36) |
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.userid,
t.coursegroupid,
t.coursegrouptitle,
t.rating,
t.approved
from testimonials as t
limit 100