Table
awards
Each row represents a credit or recognition granted to a user for completing an activity or interacting with a catalog item, including amount and resource context.
statusgroupRedshift
All tables
awards
Each row represents a credit or recognition granted to a user for completing an activity or interacting with a catalog item, including amount and resource context.
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) |
awardwhen | varchar(32) |
deleted | bool |
userid | varchar(36) |
awardamount | float8 |
clientid | varchar(36) |
resourceid | varchar(36) |
resourcetype | varchar(32) |
idempotencykey | varchar(36) |
createdat | timestamp |
updatedat | timestamp |
rdbgroup | varchar(100) |
awardtypeid | 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.awardwhen,
t.userid,
t.awardamount,
t.clientid,
t.resourceid
from awards as t
limit 100