Photo Organizer

lens_type

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
);

• 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)

• lens(type) references identifier

• lens_type_id_sequence

• lens_type_manufacturer_idx

• number_of_manufacturer_ref

• view_lens
• view_lens_type

Version 2.5

Still in use

= 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;