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
- film_type(format) references identifier
Related sequences
Related indexes
None.
Related functions
None.
Related views
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 12:45 by Luud