Table
comments
Each row represents a discussion post or reply on a course or other commentable content, including threading and moderation fields.
statusgroupRedshift
All tables
comments
Each row represents a discussion post or reply on a course or other commentable content, including threading and moderation fields.
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) |
asset | varchar(256) |
body | varchar(256) |
commentable | varchar(36) |
commentabletype | varchar(256) |
companyid | varchar(36) |
createdat | timestamp |
notifcationsenabled | bool |
updatedat | timestamp |
userid | varchar(36) |
videoasset | varchar(256) |
childrencount | int4 |
clientid | varchar(36) |
parentcommentid | varchar(36) |
courseid | 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.asset,
t.body,
t.commentable,
t.commentabletype,
t.notifcationsenabled
from comments as t
limit 100