view_scanner

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

• access_type
• scanner
• scanner_type
• manufacturer

Version 2.5

Still in use

= Version 2.5 =

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