Photo Organizer

camera_metering

Contains a listing of the valid camera metering modes.

Note that this table will likely go away; the strings aren't internationalizable and specific to Nikons. AT the very least, additional types need to be added to correspond to the 'EXIF' types.

Referential integrity.

CREATE TABLE camera_metering (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(40)
);

None.

• photo_tech(camera_metering) references identifier

• camera_metering_id_sequence

None.

None.

None.

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE camera_metering (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(40)
);

= Version 2.5 =

INSERT INTO camera_metering VALUES (NEXTVAL('camera_metering_id_sequence'), 'Spot');
INSERT INTO camera_metering VALUES (NEXTVAL('camera_metering_id_sequence'), 'Center');
INSERT INTO camera_metering VALUES (NEXTVAL('camera_metering_id_sequence'), '3D Matrix');
INSERT INTO camera_metering VALUES (NEXTVAL('camera_metering_id_sequence'), '3D Color Matrix');
INSERT INTO camera_metering VALUES (NEXTVAL('camera_metering_id_sequence'), 'Zone');