view_filter

CREATE VIEW view_filter AS
  SELECT filter.identifier, manufacturer.name, model, variation, users, 
  date_of_purchase, purchased_new, manufacturer.url, (access_type.value) 
  AS access_rights, serial_number
    FROM filter_type, filter, manufacturer, access_type
   WHERE filter_type.manufacturer = manufacturer.identifier
     AND filter_type.identifier = filter.type
     AND filter.access_rights = access_type.identifier
   ORDER BY manufacturer.name, model, variation;

• access_type
• filter
• filter_type
• manufacturer

Version 2.5

Still in use

= Version 2.5 =

CREATE VIEW view_filter AS
  SELECT filter.identifier, manufacturer.name, model, variation, users, date_of_purchase, purchased_new, manufacturer.url, (access_type.value) AS access_rights
    FROM filter_type, filter, manufacturer, access_type
   WHERE filter_type.manufacturer = manufacturer.identifier
     AND filter_type.identifier = filter.type
     AND filter.access_rights = access_type.identifier
   ORDER BY manufacturer.name, model, variation;

= Version 2.33 =

DROP VIEW view_filter;
 
CREATE VIEW view_filter AS
  SELECT filter.identifier, manufacturer.name, model, variation, users, 
  date_of_purchase, purchased_new, manufacturer.url, (access_type.value) 
  AS access_rights, serial_number
    FROM filter_type, filter, manufacturer, access_type
   WHERE filter_type.manufacturer = manufacturer.identifier
     AND filter_type.identifier = filter.type
     AND filter.access_rights = access_type.identifier
   ORDER BY manufacturer.name, model, variation;