User Tools

Site Tools


podoc:film_format_sql_table

Database Table Description of "film_format"

Name

film_format

Description

Purpose

Schema

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

References tables

None.

Is referenced by tables

None.

None.

History

Used first

Version 2.5

Used last

Still in use

Schema change history

= Version 2.5 =

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

= 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');
podoc/film_format_sql_table.txt · Last modified: 2007/04/20 08:45 by Luud