===== 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 ===

<code sql>
create table camera_program (
  identifier            integer not null primary key,
  value                 varchar(40)
);
</code>

=== References tables ===

None.

=== Is referenced by tables ===

  * [[photo_tech sql table|photo_tech]](camera_program) references identifier

=== Related sequences ===

  * [[camera_program_id_sequence sql sequence|camera_program_id_sequence]]

=== 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 =

<code sql>
create table camera_program (
  identifier            integer not null primary key,
  value                 varchar(40)
);
</code>

== Data change history ==

= Version 2.5 =

<code sql>
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');
</code>