public.film_list

Documentation	Pagila
Schema	public
Name	film_list
Module	Views

The film_list view contains a formatted view of the film table, with a comma-separated list of the film's actors.

The film_list view incorporates data from the film, category, film_category, actor, and film_actor tables.

Columns

		Name	Data type	Description
	1	fid	integer	The film ID.
The film ID.
	2	title	character varying(255)	The title of the film.
The title of the film.
	3	description	text	A short description or plot summary of the film.
A short description or plot summary of the film.
	4	category	character varying(25)	The film category.
The film category.
	5	price	numeric(4, 2)	The cost to rent the film.
The cost to rent the film.
	6	length	smallint	The duration of the film.
The duration of the film.
	7	rating	USER-DEFINED	The rating assigned to the film.
The rating assigned to the film.
	8	actors	text	The actor's full names.
The actor's full names.

Uses

Name
public.film_list
public.actor
public.category
public.film
public.film_actor
public.film_category

Script

SELECT film.film_id AS fid, film.title, film.description, category.name AS category, film.rental_rate AS price, film.length, film.rating, group_concat((((actor.first_name)::text \|\| ' '::text) \|\| (actor.last_name)::text)) AS actors FROM ((((category LEFT JOIN film_category ON ((category.category_id = film_category.category_id))) LEFT JOIN film ON ((film_category.film_id = film.film_id))) JOIN film_actor ON ((film.film_id = film_actor.film_id))) JOIN actor ON ((film_actor.actor_id = actor.actor_id))) GROUP BY film.film_id, film.title, film.description, category.name, film.rental_rate, film.length, film.rating;

SELECT film.film_id AS fid,
    film.title,
    film.description,
    category.name AS category,
    film.rental_rate AS price,
    film.length,
    film.rating,
    group_concat((((actor.first_name)::text || ' '::text) || (actor.last_name)::text)) AS actors
   FROM ((((category
     LEFT JOIN film_category ON ((category.category_id = film_category.category_id)))
     LEFT JOIN film ON ((film_category.film_id = film.film_id)))
     JOIN film_actor ON ((film.film_id = film_actor.film_id)))
     JOIN actor ON ((film_actor.actor_id = actor.actor_id)))
  GROUP BY film.film_id, film.title, film.description, category.name, film.rental_rate, film.length, film.rating;

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