User Tools

Site Tools


podoc:camera_program_sql_table

Database Table Description of "camera_program"

Name

camera_program

Description

Contains a listing of all program modes.

Note that this table will likely go away in the future, as it's not easily internationalized and lacks several modes.

Purpose

Referential Integrity.

Schema

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

References tables

None.

Is referenced by tables

  • photo_tech(camera_program) 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_program (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(40)
);
Data change history

= Version 2.5 =

INSERT INTO camera_program VALUES (NEXTVAL('camera_program_id_sequence'), 'Camera Program Automatic');
INSERT INTO camera_program VALUES (NEXTVAL('camera_program_id_sequence'), 'Aperture Priority');
INSERT INTO camera_program VALUES (NEXTVAL('camera_program_id_sequence'), 'Shutter Priority');
INSERT INTO camera_program VALUES (NEXTVAL('camera_program_id_sequence'), 'Manual');
podoc/camera_program_sql_table.txt · Last modified: 2007/04/20 14:23 by Luud