Table
clients
Each row represents a client account with name, slug, balances, and lifecycle flags.
statusgroupRedshift
All tables
clients
Each row represents a client account with name, slug, balances, and lifecycle flags.
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) |
name | varchar(255) |
slug | varchar(255) |
updatedat | timestamp |
deleted | bool |
disabled | bool |
createdat | timestamp |
currentbalance | float8 |
startingbalance | float8 |
sku | 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.
Platform Documentation
Sample query
select
t.name,
t.slug,
t.currentbalance,
t.startingbalance,
t.sku
from clients as t
limit 100