podoc:lens_type_sql_table
Database Table Description of "lens_type"
Name
lens_type
Description
Purpose
Schema
CREATE TABLE lens_type ( identifier INTEGER NOT NULL PRIMARY KEY, manufacturer INTEGER NOT NULL REFERENCES manufacturer(identifier), model VARCHAR(100), variation VARCHAR(100), min_focal_length INTEGER NOT NULL REFERENCES focal_length(identifier), max_focal_length INTEGER NOT NULL REFERENCES focal_length(identifier), min_aperture INTEGER NOT NULL REFERENCES aperture(identifier), max_aperture INTEGER NOT NULL REFERENCES aperture(identifier), last_modified_date TIMESTAMP, last_modifying_users INTEGER REFERENCES users(identifier), exiftool_lens_id text );
References tables
- last_modifying_users references users(identifier)
- manufacturer references manufacturer(identifier)
- max_aperture references aperture(identifier)
- max_focal_length focal_length(identifier)
- min_aperture references aperture(identifier)
- min_focal_length references focal_length(identifier)
Is referenced by tables
- lens(type) references identifier
Related sequences
Related indexes
Related functions
Related views
History
Used first
Version 2.5
Used last
Still in use
Schema change history
= Version 2.5 =
CREATE TABLE lens_type ( identifier INTEGER NOT NULL PRIMARY KEY, manufacturer INTEGER NOT NULL REFERENCES manufacturer(identifier), model VARCHAR(100), variation VARCHAR(100), min_focal_length INTEGER NOT NULL REFERENCES focal_length(identifier), max_focal_length INTEGER NOT NULL REFERENCES focal_length(identifier), min_aperture INTEGER NOT NULL REFERENCES aperture(identifier), max_aperture INTEGER NOT NULL REFERENCES aperture(identifier), last_modified_date TIMESTAMP, last_modifying_users INTEGER REFERENCES users(identifier) );
= Version 2.34 =
-- Add 'lens_id' to the lens types. ALTER TABLE lens_type ADD exiftool_lens_id text;
Data change history
podoc/lens_type_sql_table.txt · Last modified: 2007/10/19 20:09 by Luud