User Tools

Site Tools


podoc:photo_tech_sql_table

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
podoc:photo_tech_sql_table [2007/04/12 12:30] Luudpodoc:photo_tech_sql_table [2007/10/19 20:31] (current) Luud
Line 1: Line 1:
-===== Database Table Description =====+===== Database Table Description of "photo_tech" =====
  
 === Name === === Name ===
 +
 +photo_tech
  
 === Description === === Description ===
Line 8: Line 10:
  
 === Schema === === Schema ===
 +
 +<code sql>
 +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,
 +  latitude              numeric,                                        -- GPS information...
 +  longitude             numeric,
 +  altitude              numeric,
 +  img_direction         numeric,
 +  rdf                   text
 +);
 +</code>
 +
 +=== References tables ===
 +
 +  * aperture references [[aperture sql table|aperture]](identifier)
 +  * camera references [[camera sql table|camera]](identifier)
 +  * camera_metering references [[camera_metering sql table|camera_metering]](identifier)
 +  * camera_program references [[camera_program sql table|camera_program]](identifier)
 +  * ev_difference references [[ev_comp sql table|ev_comp]](identifier)
 +  * exposure_comp references [[ev_comp sql table|ev_comp]](identifier)
 +  * film references [[film sql table|film]](identifier)
 +  * filter references [[filter sql table|filter]](identifier)
 +  * flash references [[flash sql table|flash]](identifier)
 +  * flash_mode references [[flash_mode sql table|flash_mode]](identifier)
 +  * flash_comp references [[ev_comp sql table|ev_comp]](identifier)
 +  * focal_length [[focal_length sql table|focal_length]](identifier)
 +  * iso_override references [[film_iso sql table|film_iso]](identifier)
 +  * lens references [[lens sql table|lens]](identifier)
 +  * photo references [[photo sql table|photo]](identifier)
 +  * scan_bitdepth references [[scan_bitdepth sql table|scan_bitdepth]](identifier)
 +  * scan_multiscan references [[scan_multiscan sql table|scan_multiscan]](identifier)
 +  * scan_resolution references [[scan_resolution sql table|scan_resolution]](identifier)
 +  * scanner references [[scanner sql table|scanner]](identifier)
 +  * shutter references [[shutter sql table|shutter]](identifier)
 +  * support references [[support sql table|support]](identifier)
 +
 +=== Is referenced by tables ===
 +
 +None.
  
 === Related sequences === === Related sequences ===
 +
 +  * [[photo_tech_id_sequence sql sequence|photo_tech_id_sequence]]
  
 === Related indexes === === Related indexes ===
 +
 +  * [[photo_tech_id_idx sql index|photo_tech_id_idx]]
 +  * [[photo_tech_photo_idx sql index|photo_tech_photo_idx]]
  
 === Related functions === === Related functions ===
 +
 +  * [[number_of_camera_references sql function|number_of_camera_references]]
 +  * [[number_of_film_references sql function|number_of_film_references]]
 +  * [[number_of_filter_references sql function|number_of_filter_references]]
 +  * [[number_of_flash_references sql function|number_of_flash_references]]
 +  * [[number_of_lens_references sql function|number_of_lens_references]]
 +  * [[number_of_scanner_references sql function|number_of_scanner_references]]
 +  * [[number_of_support_references sql function|number_of_support_references]]
  
 === Related views === === Related views ===
 +
 +None.
  
 === History === === History ===
Line 27: Line 106:
 Still in use Still in use
  
-== Change history ==+== Schema change history ==
  
 = Version 2.5 = = Version 2.5 =
  
-  create table ... +<code sql> 
-    ...   +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) 
 +); 
 +</code> 
 + 
 += Version 2.9 = 
 + 
 +<code sql> 
 +alter table photo_tech add column exif text; 
 +alter table photo_tech add column iptc text; 
 +</code> 
 + 
 += Version 2.34 = 
 + 
 +<code sql> 
 +-- GPS information... 
 +alter table photo_tech add latitude numeric; 
 +alter table photo_tech add longitude numeric; 
 +alter table photo_tech add altitude numeric; 
 +alter table photo_tech add img_direction numeric; 
 +</code> 
 + 
 +<code sql> 
 +-- Add an 'rdf' column to store all XMP data. 
 +alter table photo_tech add rdf text; 
 +</code> 
 + 
 +== Data change history == 
 + 
 += Version 2.6 = 
 + 
 +<code sql> 
 +-- 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; 
 +</code> 
podoc/photo_tech_sql_table.1176381027.txt.gz · Last modified: 2007/04/12 12:30 by Luud