public.staff_list

Description

Table Definition

CREATE VIEW staff_list AS (
 SELECT s.staff_id AS id,
    ((s.first_name || ' '::text) || s.last_name) 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)))
)

Referenced Tables

• public.staff
• public.address
• public.city
• public.country

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	integer		true
name	text		true
address	text		true
zip code	text		true
phone	text		true
city	text		true
country	text		true
sid	integer		true

Relations