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
Related sequences
Related indexes
None.
Related functions
None.
Related views
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