599rows
9 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 | — | — |
notes | | yes | — | — |
SID | | yes | — | — |
View definition
CREATE VIEW "customer_list" AS SELECT cu.customer_id AS ID, (cu.first_name || ' ' || cu.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, CASE WHEN cu.active THEN 'active' ELSE '' END AS notes, cu.store_id AS SID FROM customer AS cu JOIN address AS a ON cu.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 | MARY SMITH | 1913 Hanoi Way | 35200 | 28303384290 | Sasebo | Japan |
| 2 | PATRICIA JOHNSON | 1121 Loja Avenue | 17886 | 838635286649 | San Bernardino | United States |
| 3 | LINDA WILLIAMS | 692 Joliet Street | 83579 | 448477190408 | Athenai | Greece |
| 4 | BARBARA JONES | 1566 Inegöl Manor | 53561 | 705814003527 | Myingyan | Myanmar |
| 5 | ELIZABETH BROWN | 53 Idfu Parkway | 42399 | 10655648674 | Nantou | Taiwan |
| 6 | JENNIFER DAVIS | 1795 Santiago de Compostela Way | 18743 | 860452626434 | Laredo | United States |
| 7 | MARIA MILLER | 900 Santiago de Compostela Parkway | 93896 | 716571220373 | Kragujevac | Yugoslavia |
| 8 | SUSAN WILSON | 478 Joliet Way | 77948 | 657282285970 | Hamilton | New Zealand |