Table
creditbatches
Each row represents a named batch of prepaid credit with balances and expiry dates.
statusgroupRedshift
All tables
creditbatches
Each row represents a named batch of prepaid credit with balances and expiry dates.
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) |
expireson | timestamp |
clientid | varchar(36) |
companyid | varchar(36) |
status | varchar(65535) |
createdat | timestamp |
updatedat | timestamp |
startingbalance | float8 |
currentbalance | float8 |
creditbatchname | varchar(256) |
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.expireson,
t.clientid,
t.startingbalance,
t.currentbalance,
t.creditbatchname
from creditbatches as t
limit 100