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