Table
companies
Each row represents a tenant site with subdomain, branding names, organization link, and status.
statusgroupRedshift
All tables
companies
Each row represents a tenant site with subdomain, branding names, organization link, and status.
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) |
name | varchar(255) |
customhost | varchar(255) |
subdomain | varchar(255) |
organizationid | varchar(36) |
updatedat | timestamp |
rdbgroup | varchar(255) |
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.name,
t.customhost,
t.subdomain,
t.organizationid,
t.copyrightname
from companies as t
limit 100