Photo Organizer

manufacturer

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)
);

• last_modifying_users references users(identifier)

• 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

• manufacturer_id_sequence

None.

None.

• view_camera
• view_camera_type
• view_film
• view_film_type
• view_filter
• view_filter_type
• view_flash
• view_flash_type
• view_lens
• view_lens_type
• view_scanner
• view_scanner_type
• view_support
• view_support_type

Version 2.5

Still in use

= 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);