view_camera

CREATE VIEW view_camera AS
  SELECT camera.identifier, manufacturer.name, model, variation, 
      camera.serial_number, camera.users, date_of_purchase,
      camera.purchased_new,
      manufacturer.url, (access_type.value) AS access_rights, raw_icc_profile, ignore_comment
    FROM camera_type, camera, manufacturer, access_type
   WHERE camera_type.manufacturer = manufacturer.identifier
     AND camera_type.identifier = camera.type
     AND camera.access_rights = access_type.identifier
   ORDER BY manufacturer.name, model, variation;

• access_type
• camera
• camera_type
• manufacturer

Version 2.5

Still in use

= Version 2.5 =

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

= Version 2.29 =

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

= Version 2.34 =

DROP VIEW view_camera;
 
CREATE VIEW view_camera AS
  SELECT camera.identifier, manufacturer.name, model, variation, 
      camera.serial_number, camera.users, date_of_purchase,
      camera.purchased_new,
      manufacturer.url, (access_type.value) AS access_rights, raw_icc_profile, ignore_comment
    FROM camera_type, camera, manufacturer, access_type
   WHERE camera_type.manufacturer = manufacturer.identifier
     AND camera_type.identifier = camera.type
     AND camera.access_rights = access_type.identifier
   ORDER BY manufacturer.name, model, variation;