Table
organizations
Each row represents a top-level organization entity that can own multiple company sites.
Redshift
All tables
organizations
Each row represents a top-level organization entity that can own multiple company sites.
Full schema
View all columns and table relationships (SchemaSpy)Status group
No, this table does not include a statusgroup column.
Column details
| Column | Type | Nullable |
|---|---|---|
id | varchar(36) | Yes |
name | varchar(255) | Yes |
updatedat | timestamp | Yes |
Column names and types come from the Redshift analytics schema. SchemaSpy is authoritative for nullability, defaults, keys, and relationships.
Sample query
select
t.name
from organizations as t
limit 100