User Tools

Site Tools


podoc:view_film_type_sql_view

Database View Description of "view_film_type"

Name

view_film_type

Description

Purpose

Schema

CREATE VIEW view_film_type AS
  SELECT film_type.identifier, manufacturer.name, model, film_iso.VALUE AS iso, film_format.VALUE AS format, manufacturer.url
    FROM film_type, manufacturer, film_iso, film_format
   WHERE film_type.manufacturer = manufacturer.identifier
     AND film_type.iso = film_iso.identifier
     AND film_type.format = film_format.identifier
   ORDER BY manufacturer.name, model, film_iso.VALUE;

History

Used first

Version 2.5

Used last

Still in use

Change history

= Version 2.5 =

CREATE VIEW view_film_type AS
  SELECT film_type.identifier, manufacturer.name, model, film_iso.VALUE AS iso, film_format.VALUE AS format, manufacturer.url
    FROM film_type, manufacturer, film_iso, film_format
   WHERE film_type.manufacturer = manufacturer.identifier
     AND film_type.iso = film_iso.identifier
     AND film_type.format = film_format.identifier
   ORDER BY manufacturer.name, model, film_iso.VALUE;

= Version 2.27 =

DROP VIEW view_film_type;
 
CREATE VIEW view_film_type AS
  SELECT film_type.identifier, manufacturer.name, model, film_iso.VALUE AS iso, film_format.VALUE AS format, manufacturer.url
    FROM film_type, manufacturer, film_iso, film_format
   WHERE film_type.manufacturer = manufacturer.identifier
     AND film_type.iso = film_iso.identifier
     AND film_type.format = film_format.identifier
   ORDER BY manufacturer.name, model, film_iso.VALUE;
podoc/view_film_type_sql_view.txt · Last modified: 2007/04/20 11:41 by Luud