podoc:photo_tech_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:photo_tech_sql_table [2007/04/12 12:30] – Luud | podoc:photo_tech_sql_table [2007/10/19 20:31] (current) – Luud | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Database Table Description ===== | + | ===== Database Table Description |
=== Name === | === Name === | ||
+ | |||
+ | photo_tech | ||
=== Description === | === Description === | ||
Line 8: | Line 10: | ||
=== Schema === | === Schema === | ||
+ | |||
+ | <code sql> | ||
+ | create table photo_tech ( | ||
+ | identifier | ||
+ | photo | ||
+ | camera | ||
+ | lens integer references lens(identifier), | ||
+ | film integer references film(identifier), | ||
+ | flash | ||
+ | scanner | ||
+ | filter | ||
+ | scan_resolution | ||
+ | aperture | ||
+ | focal_length | ||
+ | shutter | ||
+ | camera_metering | ||
+ | camera_program | ||
+ | flash_mode | ||
+ | exposure_comp | ||
+ | flash_comp | ||
+ | ev_difference | ||
+ | iso_override | ||
+ | support | ||
+ | scan_bitdepth | ||
+ | scan_multiscan | ||
+ | exif text, | ||
+ | iptc text, | ||
+ | latitude | ||
+ | longitude | ||
+ | altitude | ||
+ | img_direction | ||
+ | rdf text | ||
+ | ); | ||
+ | </ | ||
+ | |||
+ | === 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 | + | == Schema change |
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | | + | create table photo_tech |
- | ); | + | |
+ | photo | ||
+ | camera | ||
+ | lens integer references lens(identifier), | ||
+ | film integer references film(identifier), | ||
+ | flash | ||
+ | scanner | ||
+ | filter | ||
+ | scan_resolution | ||
+ | aperture | ||
+ | focal_length | ||
+ | shutter | ||
+ | | ||
+ | camera_program | ||
+ | flash_mode | ||
+ | exposure_comp | ||
+ | flash_comp | ||
+ | ev_difference | ||
+ | iso_override | ||
+ | support | ||
+ | scan_bitdepth | ||
+ | scan_multiscan | ||
+ | ); | ||
+ | </ | ||
+ | |||
+ | = Version 2.9 = | ||
+ | |||
+ | <code sql> | ||
+ | alter table photo_tech add column exif text; | ||
+ | alter table photo_tech add column iptc text; | ||
+ | </ | ||
+ | |||
+ | = 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 sql> | ||
+ | -- Add an ' | ||
+ | alter table photo_tech add rdf text; | ||
+ | </ | ||
+ | |||
+ | == 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; | ||
+ | </ |
podoc/photo_tech_sql_table.1176381027.txt.gz · Last modified: 2007/04/12 12:30 by Luud