Table
registrationcodes
Each row represents a shareable code that grants access for a number of days with usage limits.
statusgroupRedshift
All tables
registrationcodes
Each row represents a shareable code that grants access for a number of days with usage limits.
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) |
createdat | timestamp |
updatedat | timestamp |
maxredemptions | int4 |
accessdays | int4 |
timesredeemed | int4 |
code | varchar(65535) |
label | varchar(65535) |
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.maxredemptions,
t.accessdays,
t.timesredeemed,
t.code,
t.label
from registrationcodes as t
limit 100