podoc:photo_tech_sql_table
This is an old revision of the document!
Database Table Description of "photo_tech"
Name
photo_tech
Description
Purpose
Schema
create table photo_tech ( identifier integer not null primary key, photo integer not null references photo(identifier), camera integer references camera(identifier), lens integer references lens(identifier), film integer references film(identifier), flash integer references flash(identifier), scanner integer references scanner(identifier), filter integer references filter(identifier), scan_resolution integer references scan_resolution(identifier), aperture integer references aperture(identifier), -- key from aperture, must be within the lens limits focal_length integer references focal_length(identifier), -- key from focal length, must be within the lens limits shutter integer references shutter(identifier), camera_metering integer references camera_metering(identifier), camera_program integer references camera_program(identifier), flash_mode integer references flash_mode(identifier), exposure_comp integer references ev_comp(identifier), flash_comp integer references ev_comp(identifier), ev_difference integer references ev_comp(identifier), iso_override integer references film_iso(identifier), support integer references support(identifier), scan_bitdepth integer references scan_bitdepth(identifier), scan_multiscan integer references scan_multiscan(identifier) );
Related sequences
Related indexes
Related functions
Related views
History
Used first
Version 2.5
Used last
Still in use
Change history
= Version 2.5 =
create table photo_tech ( identifier integer not null primary key, photo integer not null references photo(identifier), camera integer references camera(identifier), lens integer references lens(identifier), film integer references film(identifier), flash integer references flash(identifier), scanner integer references scanner(identifier), filter integer references filter(identifier), scan_resolution integer references scan_resolution(identifier), aperture integer references aperture(identifier), -- key from aperture, must be within the lens limits focal_length integer references focal_length(identifier), -- key from focal length, must be within the lens limits shutter integer references shutter(identifier), camera_metering integer references camera_metering(identifier), camera_program integer references camera_program(identifier), flash_mode integer references flash_mode(identifier), exposure_comp integer references ev_comp(identifier), flash_comp integer references ev_comp(identifier), ev_difference integer references ev_comp(identifier), iso_override integer references film_iso(identifier), support integer references support(identifier), scan_bitdepth integer references scan_bitdepth(identifier), scan_multiscan integer references scan_multiscan(identifier) );
= Version 2.6 =
-- shift all existing ev comensation references update photo_tech set exposure_comp=exposure_comp+4 where exposure_comp >21; update photo_tech set flash_comp=flash_comp+4 where flash_comp >21; update photo_tech set ev_difference=ev_difference+4 where ev_difference >21;
podoc/photo_tech_sql_table.1176453364.txt.gz · Last modified: 2007/04/13 08:36 by Luud