podoc:view_film_sql_view
This is an old revision of the document!
Database View Description of "view_film"
Name
view_film
Description
Purpose
Schema
create view view_film as select film.identifier, manufacturer.name, model, film_iso.value as iso, film_format.value as format, film.users, manufacturer.url, (access_type.value) as access_rights from film_type, film, manufacturer, film_iso, film_format, access_type where film_type.manufacturer = manufacturer.identifier and film_type.identifier = film.type and film_type.iso = film_iso.identifier and film_type.format = film_format.identifier and film.access_rights = access_type.identifier order by manufacturer.name, model, film_iso.value;
Related tables
Related indexes
Related functions
Related views
History
Used first
Version 2.5
Used last
Still in use
Change history
= Version 2.5 =
create view view_film as select film.identifier, manufacturer.name, model, film_iso.value as iso, film_format.value as format, film.users, manufacturer.url, (access_type.value) as access_rights from film_type, film, manufacturer, film_iso, film_format, access_type where film_type.manufacturer = manufacturer.identifier and film_type.identifier = film.type and film_type.iso = film_iso.identifier and film_type.format = film_format.identifier and film.access_rights = access_type.identifier order by manufacturer.name, model, film_iso.value;
podoc/view_film_sql_view.1176450142.txt.gz · Last modified: 2007/04/13 07:42 by Luud