Photo Organizer

This is an old revision of the document!

Database Table Description of "focal_length"

Name

focal_length

Description

Purpose

Schema

create table focal_length (
  identifier            integer not null primary key,
  value                 varchar(10)
);

Related sequences

focal_length_id_sequence

Related indexes

Related functions

Related views

History

Used first

Version 2.5

Used last

Still in use

Schema change history

= Version 2.5 =

ccreate table focal_length (
  identifier            integer not null primary key,
  value                 varchar(10)
);

Data change history

= Version 2.5 =

insert into focal_length values (nextval('focal_length_id_sequence'), '5');
insert into focal_length values (nextval('focal_length_id_sequence'), '6');
insert into focal_length values (nextval('focal_length_id_sequence'), '7');
insert into focal_length values (nextval('focal_length_id_sequence'), '8');
insert into focal_length values (nextval('focal_length_id_sequence'), '9');
insert into focal_length values (nextval('focal_length_id_sequence'), '10');
insert into focal_length values (nextval('focal_length_id_sequence'), '11');
insert into focal_length values (nextval('focal_length_id_sequence'), '12');
insert into focal_length values (nextval('focal_length_id_sequence'), '13');
insert into focal_length values (nextval('focal_length_id_sequence'), '14');
insert into focal_length values (nextval('focal_length_id_sequence'), '15');
insert into focal_length values (nextval('focal_length_id_sequence'), '16');
insert into focal_length values (nextval('focal_length_id_sequence'), '17');
insert into focal_length values (nextval('focal_length_id_sequence'), '18');
insert into focal_length values (nextval('focal_length_id_sequence'), '19');
insert into focal_length values (nextval('focal_length_id_sequence'), '20');
insert into focal_length values (nextval('focal_length_id_sequence'), '24');
insert into focal_length values (nextval('focal_length_id_sequence'), '28');
insert into focal_length values (nextval('focal_length_id_sequence'), '35');
insert into focal_length values (nextval('focal_length_id_sequence'), '40');
insert into focal_length values (nextval('focal_length_id_sequence'), '45');
insert into focal_length values (nextval('focal_length_id_sequence'), '50');
insert into focal_length values (nextval('focal_length_id_sequence'), '55');
insert into focal_length values (nextval('focal_length_id_sequence'), '60');
insert into focal_length values (nextval('focal_length_id_sequence'), '70');
insert into focal_length values (nextval('focal_length_id_sequence'), '80');
insert into focal_length values (nextval('focal_length_id_sequence'), '85');
insert into focal_length values (nextval('focal_length_id_sequence'), '90');
insert into focal_length values (nextval('focal_length_id_sequence'), '105');
insert into focal_length values (nextval('focal_length_id_sequence'), '120');
insert into focal_length values (nextval('focal_length_id_sequence'), '135');
insert into focal_length values (nextval('focal_length_id_sequence'), '150');
insert into focal_length values (nextval('focal_length_id_sequence'), '180');
insert into focal_length values (nextval('focal_length_id_sequence'), '200');
insert into focal_length values (nextval('focal_length_id_sequence'), '210');
insert into focal_length values (nextval('focal_length_id_sequence'), '300');
insert into focal_length values (nextval('focal_length_id_sequence'), '400');
insert into focal_length values (nextval('focal_length_id_sequence'), '500');
insert into focal_length values (nextval('focal_length_id_sequence'), '600');
insert into focal_length values (nextval('focal_length_id_sequence'), '800');
insert into focal_length values (nextval('focal_length_id_sequence'), '1000');
insert into focal_length values (nextval('focal_length_id_sequence'), '1100');
insert into focal_length values (nextval('focal_length_id_sequence'), '1200');
insert into focal_length values (nextval('focal_length_id_sequence'), '1300');
insert into focal_length values (nextval('focal_length_id_sequence'), '2000');

= Version 2.32 =

-- Add more focal lengths.
insert into focal_length values (nextval('focal_length_id_sequence'), 75);
insert into focal_length values (nextval('focal_length_id_sequence'), 240);