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
Key | Name | Data type | Null | Attributes | References | 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
|
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))); |
Exported: 2018-10-12 17:07, Last imported: 2018-08-06 09:25