Table
locations
Each row represents a physical or virtual venue for instructor-led training, including address, timezone, and room.
Redshift
All tables
locations
Each row represents a physical or virtual venue for instructor-led training, including address, timezone, and room.
Full schema
View all columns and table relationships (SchemaSpy)Status group
No, this table does not include a statusgroup column.
Column details
| Column | Type |
|---|---|
id | varchar(36) |
companyid | varchar(36) |
address1 | varchar(255) |
address2 | varchar(255) |
city | varchar(255) |
country | varchar(255) |
name | varchar(255) |
room | varchar(255) |
state | varchar(255) |
timezone | varchar(255) |
zipcode | varchar(255) |
updatedat | timestamp |
Column names and types come from the Redshift analytics schema. SchemaSpy is authoritative for nullability, defaults, keys, and relationships.
Sample query
select
t.address1,
t.address2,
t.city,
t.country,
t.name
from locations as t
limit 100