public.customer_list

Documentation	Pagila
Schema	public
Name	customer_list
Module	Views

The customer_list view provides a list of customers, with first name and last name concatenated together and address information combined into a single view.

The customer_list view incorporates data from the customer, address, city, and country tables.

Columns

		Name	Data type	Description
	1	id	integer	The customer ID.
The customer ID.
	2	name	text	The customer's full name.
The customer's full name.
	3	address	character varying(50)	The customer's address.
The customer's address.
	4	zip code	character varying(10)	The postal code or ZIP code of the address.
The postal code or ZIP code of the address.
	5	phone	character varying(20)	The telephone number for the address.
The telephone number for the address.
	6	city	character varying(50)	Name of the city.
Name of the city.
	7	country	character varying(50)	The name of the country.
The name of the country.
	8	notes	text	Indicates whether the customer is an active customer.
Indicates whether the customer is an active customer.
	9	sid	smallint	The ID of customer's “home store.”
The ID of customer's “home store.”

Uses

Name
public.customer_list
public.address
public.city
public.country
public.customer

Script

SELECT cu.customer_id AS id, (((cu.first_name)::text \|\| ' '::text) \|\| (cu.last_name)::text) AS name, a.address, a.postal_code AS "zip code", a.phone, city.city, country.country, CASE WHEN cu.activebool THEN 'active'::text ELSE ''::text END AS notes, cu.store_id AS sid FROM (((customer cu JOIN address 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_id)));

SELECT cu.customer_id AS id,
    (((cu.first_name)::text || ' '::text) || (cu.last_name)::text) AS name,
    a.address,
    a.postal_code AS "zip code",
    a.phone,
    city.city,
    country.country,
        CASE
            WHEN cu.activebool THEN 'active'::text
            ELSE ''::text
        END AS notes,
    cu.store_id AS sid
   FROM (((customer cu
     JOIN address 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_id)));

Exported: 2018-10-12 17:07, Last imported: 2018-08-06 09:25