User Tools

Site Tools


podoc:camera_metering_sql_table

Database Table Description of "camera_metering"

Name

camera_metering

Description

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.

Purpose

Referential integrity.

Schema

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

References tables

None.

Is referenced by tables

  • photo_tech(camera_metering) references identifier

None.

None.

None.

History

Used first

Version 2.5

Used last

Still in use

Schema change history

= Version 2.5 =

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

= 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');
podoc/camera_metering_sql_table.txt · Last modified: 2007/04/20 10:23 by Luud