Photo Organizer

aperture

This table contains a list of all valid apertures (eg f/2, f/5.6, etc).

To enforce referential integrity.

Note: This table will likely be eliminated in the future in favor of direct aperture representation – this is an unnecessary abstraction.

CREATE TABLE aperture (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(10)
); 

None.

• lens_type(max_aperture) references identifier
• lens_type(min_aperture) references identifier

• aperture_id_sequence

None.

None.

• view_lens
• view_lens_type

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE aperture (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 NUMERIC
);

= Version 2.32 =

-- Convert aperture from a varchar to a numeric type
ALTER TABLE aperture ADD value_num NUMERIC;
UPDATE aperture SET value_num = VALUE::text::NUMERIC;
ALTER TABLE aperture DROP VALUE;
ALTER TABLE aperture RENAME value_num TO VALUE;

= Version 2.5 =

INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '0.5');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '0.75');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '1.0');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '1.2');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '1.3');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '1.4');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '1.6');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '1.8');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '2.0');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '2.2');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '2.5');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '2.8');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '3.2');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '3.5');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '4.0');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '4.5');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '5.0');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '5.6');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '6.3');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '7.1');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '8.0');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '9.0');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '10');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '11');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '13');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '14');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '16');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '18');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '20');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '22');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '25');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '28');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '32');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '36');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '40');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '45');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '51');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '57');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '64');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '72');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '81');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '90');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '103');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '115');
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '128');