podoc:view_camera_sql_view
Database View Description of "view_camera"
Name
view_camera
Description
Purpose
Schema
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;
Related tables
History
Used first
Version 2.5
Used last
Still in use
Change history
= 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;
podoc/view_camera_sql_view.txt · Last modified: 2007/10/19 20:07 by Luud