podoc:manufacturer_sql_table
Database Table Description of "manufacturer"
Name
manufacturer
Description
Purpose
Schema
CREATE TABLE manufacturer ( identifier INTEGER NOT NULL PRIMARY KEY, name VARCHAR(100), url VARCHAR(100), last_modified_date TIMESTAMP, last_modifying_users INTEGER REFERENCES users(identifier) );
References tables
- last_modifying_users references users(identifier)
Is referenced by tables
- camera_type(manufacturer) references identifier
- film_type(manufacturer) references identifier
- filter_type(manufacturer) references identifier
- flash_type(manufacturer) references identifier
- label(manufacturer) references identifier
- lens_type(manufacturer) references identifier
- scanner_type(manufacturer) references identifier
- support_type(manufacturer) 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 manufacturer ( identifier INTEGER NOT NULL PRIMARY KEY, name VARCHAR(100), url VARCHAR(100), last_modified_date TIMESTAMP, last_modifying_users INTEGER REFERENCES users(identifier) ); <code> == DATA CHANGE history == = Version 2.5 = <code sql> INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Avery', 'http://www.avery.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Canon', 'http://www.canon.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Fuji Film', 'http://www.fujifilm.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Hasselblad', 'http://www.hasselblad.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Kodak', 'http://www.kodak.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Mamiya', 'http://www.mamiya.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Minolta', 'http://www.minolta.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Nikon', 'http://www.nikon-image.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Olympus', 'http://www.olympus.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Pentax', 'http://www.pentax.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Rollei', 'http://www.rollei.de', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Sinar', 'http://www.sinar.ch', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Sony', 'http://www.sony.com', now(), 1);
podoc/manufacturer_sql_table.txt · Last modified: 2007/04/20 15:24 by Luud