public.staff_list

Documentation	Pagila
Schema	public
Name	staff_list
Module	Views

The staff_list view provides a list of all staff members, including address and store information.

The staff_list view incorporates data from the staff and address tables.

Columns

		Name	Data type	Description
	1	id	integer	The staff member ID.
The staff member ID.
	2	name	text	The staff member full name.
The staff member full name.
	3	address	character varying(50)	The staff member address.
The staff member 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.
The telephone number.
	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	sid	smallint	The store ID.
The store ID.

Uses

Name
public.staff_list
public.address
public.city
public.country
public.staff

Script

SELECT s.staff_id AS id, (((s.first_name)::text \|\| ' '::text) \|\| (s.last_name)::text) AS name, a.address, a.postal_code AS "zip code", a.phone, city.city, country.country, s.store_id AS sid FROM (((staff s JOIN address 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_id)));

SELECT s.staff_id AS id,
    (((s.first_name)::text || ' '::text) || (s.last_name)::text) AS name,
    a.address,
    a.postal_code AS "zip code",
    a.phone,
    city.city,
    country.country,
    s.store_id AS sid
   FROM (((staff s
     JOIN address 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_id)));

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