view_film

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;

• access_type
• film
• film_format
• film_iso
• film_type
• manufacturer

Version 2.5

Still in use

= 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;

= Version 2.27 =

DROP VIEW view_film_type;
DROP VIEW view_film;
 
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '64');
ALTER TABLE film_iso ADD COLUMN value_2 integer;
UPDATE film_iso SET value_2 = to_number(value, '9999');
ALTER TABLE film_iso DROP COLUMN value;
ALTER TABLE film_iso RENAME COLUMN value_2 TO value;
 
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;
 
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;