Table
redemptioncodes
Each row represents an individual redeemable code with redemption state and who redeemed it.
statusgroupRedshift
All tables
redemptioncodes
Each row represents an individual redeemable code with redemption state and who redeemed it.
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) |
createdat | timestamp |
companyid | varchar(36) |
redeemedbyuserid | varchar(36) |
redemptioncodegroupid | varchar(36) |
redeemed | bool |
redeemedat | timestamp |
code | varchar(65535) |
statusgroup | varchar(256) |
statusgroupupdatedat | timestamp |
updatedat | timestamp |
Column names and types come from the Redshift analytics schema. SchemaSpy is authoritative for nullability, defaults, keys, and relationships.
Sample query
select
t.redeemedbyuserid,
t.redemptioncodegroupid,
t.redeemed,
t.redeemedat,
t.code
from redemptioncodes as t
limit 100