Photo Organizer

film_format

CREATE TABLE film_format (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(10)
);

None.

• film_type(format) references identifier

• film_format_id_sequence

None.

None.

• view_film
• view_film_type

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE film_format (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(10)
);

= version 2.5 =

INSERT INTO film_format VALUES (NEXTVAL('film_format_id_sequence'), 'APS');
INSERT INTO film_format VALUES (NEXTVAL('film_format_id_sequence'), '24x35 mm');
INSERT INTO film_format VALUES (NEXTVAL('film_format_id_sequence'), '24x65 mm');
INSERT INTO film_format VALUES (NEXTVAL('film_format_id_sequence'), '40x40 mm');
INSERT INTO film_format VALUES (NEXTVAL('film_format_id_sequence'), '45x60 mm');
INSERT INTO film_format VALUES (NEXTVAL('film_format_id_sequence'), '60x60 mm');
INSERT INTO film_format VALUES (NEXTVAL('film_format_id_sequence'), '60x70 mm');
INSERT INTO film_format VALUES (NEXTVAL('film_format_id_sequence'), '4x5 inch');
INSERT INTO film_format VALUES (NEXTVAL('film_format_id_sequence'), '8x10 inch');
INSERT INTO film_format VALUES (NEXTVAL('film_format_id_sequence'), '20x24 inch');
INSERT INTO film_format VALUES (NEXTVAL('film_format_id_sequence'), 'Digital');