2rows
8 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
ID | | yes | — | — |
name | | yes | — | — |
address | | yes | — | — |
zip code | | yes | — | — |
phone | | yes | — | — |
city | | yes | — | — |
country | | yes | — | — |
SID | | yes | — | — |
View definition
CREATE VIEW "staff_list" AS SELECT s.staff_id AS ID, (s.first_name || ' ' || s.last_name) AS name, a.address AS address, a.postal_code AS "zip code", a.phone AS phone, city.city AS city, country.country AS country, s.store_id AS SID FROM staff AS s JOIN address AS a ON s.address_id = a.address_id JOIN city ON a.city_id = city.city_id JOIN country ON city.country_id = country.country_idData preview
Sample records
| ID | name | address | zip code | phone | city | country |
|---|---|---|---|---|---|---|
| 1 | Mike Hillyer | 23 Workhaven Lane | 14033335568 | Lethbridge | Canada | |
| 2 | Jon Stephens | 1411 Lillydale Drive | 6172235589 | Woodridge | Australia |