Photo Organizer

Database View Description of "view_flash"

Name

view_flash

Description

Purpose

Schema

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

Related tables

History

Used first

Version 2.5

Used last

Still in use

Change history

= Version 2.5 =

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