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;
Related tables
Related indexes
Related functions
Related sequences
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.1176455420.txt.gz · Last modified: 2007/04/13 09:10 by Luud