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), exif text, iptc text );
References tables
- aperture references aperture(identifier)
- camera references camera(identifier)
- camera_metering references camera_metering(identifier)
- camera_program references camera_program(identifier)
- ev_difference references ev_comp(identifier)
- exposure_comp references ev_comp(identifier)
- film references film(identifier)
- filter references filter(identifier)
- flash references flash(identifier)
- flash_mode references flash_mode(identifier)
- flash_comp references ev_comp(identifier)
- focal_length focal_length(identifier)
- iso_override references film_iso(identifier)
- lens references lens(identifier)
- photo references photo(identifier)
- scan_bitdepth references scan_bitdepth(identifier)
- scan_multiscan references scan_multiscan(identifier)
- scan_resolution references scan_resolution(identifier)
- scanner references scanner(identifier)
- shutter references shutter(identifier)
- support references support(identifier)
Is referenced by tables
None.
Related sequences
Related indexes
Related functions
Related views
None.
History
Used first
Version 2.5
Used last
Still in use
Schema 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.9 =
ALTER TABLE photo_tech ADD COLUMN exif text; ALTER TABLE photo_tech ADD COLUMN iptc text;
= Data change history =
= 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.1177078686.txt.gz · Last modified: 2007/04/20 14:18 by Luud