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/18 14:33] Luudpodoc:photo_tech_sql_table [2007/10/19 20:31] (current) Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-<code>+<code sql>
 create table photo_tech ( create table photo_tech (
   identifier            integer not null primary key,   identifier            integer not null primary key,
Line 36: Line 36:
   scan_multiscan        integer references scan_multiscan(identifier),   scan_multiscan        integer references scan_multiscan(identifier),
   exif                  text,   exif                  text,
-  iptc                  text+  iptc                  text, 
 +  latitude              numeric,                                        -- GPS information... 
 +  longitude             numeric, 
 +  altitude              numeric, 
 +  img_direction         numeric, 
 +  rdf                   text
 ); );
 </code> </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 ===
Line 54: Line 87:
   * [[number_of_film_references sql function|number_of_film_references]]   * [[number_of_film_references sql function|number_of_film_references]]
   * [[number_of_filter_references sql function|number_of_filter_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 71: Line 110:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 create table photo_tech ( create table photo_tech (
   identifier            integer not null primary key,   identifier            integer not null primary key,
Line 100: Line 139:
 = Version 2.9 = = Version 2.9 =
  
-<code>+<code sql>
 alter table photo_tech add column exif text; alter table photo_tech add column exif text;
 alter table photo_tech add column iptc text; alter table photo_tech add column iptc text;
 </code> </code>
  
-= Data change history =+= 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 = = Version 2.6 =
  
-<code>+<code sql>
 -- shift all existing ev comensation references -- shift all existing ev comensation references
 update photo_tech set exposure_comp=exposure_comp+4 where exposure_comp >21; update photo_tech set exposure_comp=exposure_comp+4 where exposure_comp >21;
podoc/photo_tech_sql_table.1176906818.txt.gz · Last modified: 2007/04/18 14:33 by Luud