User Tools

Site Tools


podoc:view_photo_sql_view

This is an old revision of the document!


Database View Description of "view_photo"

Name

view_photo

Description

Purpose

Schema

create view view_photo as
  select photo.identifier, caption, users, date_of_exposure, date_of_creation,
         storage_location, storage_index, small_image_path, medium_image_path,
         large_image_path, folder, (access_type.value) as access_rights
    from photo, photo_dupe, access_type
   where photo.identifier = photo_dupe.photo
     and photo.access_rights = access_type.identifier
   order by photo.identifier;

History

Used first

Version 2.5

Used last

Still in use

Change history

= Version 2.5 =

create view view_photo as
  select photo.identifier, caption, users, date_of_exposure, date_of_creation,
         storage_location, storage_index, small_image_path, medium_image_path,
         large_image_path, folder, (access_type.value) as access_rights
    from photo, photo_dupe, access_type
   where photo.identifier = photo_dupe.photo
     and photo.access_rights = access_type.identifier
   order by photo.identifier;
podoc/view_photo_sql_view.1176450887.txt.gz · Last modified: 2007/04/13 07:54 by Luud