===== Database Table Description of "manufacturer" =====

=== Name ===

manufacturer

=== Description ===

=== Purpose ===

=== Schema ===

<code sql>
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>

=== References tables ===

  * last_modifying_users references [[users sql table|users]](identifier)

=== Is referenced by tables ===

  * [[camera_type sql table|camera_type]](manufacturer) references identifier
  * [[film_type sql table|film_type]](manufacturer) references identifier
  * [[filter_type sql table|filter_type]](manufacturer) references identifier
  * [[flash_type sql table|flash_type]](manufacturer) references identifier
  * [[label sql table|label]](manufacturer) references identifier
  * [[lens_type sql table|lens_type]](manufacturer) references identifier
  * [[scanner_type sql table|scanner_type]](manufacturer) references identifier
  * [[support_type sql table|support_type]](manufacturer) references identifier

=== Related sequences ===

  * [[manufacturer_id_sequence sql sequence|manufacturer_id_sequence]]

=== Related indexes ===

None.

=== Related functions ===

None.

=== Related views ===

  * [[view_camera sql view|view_camera]]
  * [[view_camera_type sql view|view_camera_type]]
  * [[view_film sql view|view_film]]
  * [[view_film_type sql view|view_film_type]]
  * [[view_filter sql view|view_filter]]
  * [[view_filter_type sql view|view_filter_type]]
  * [[view_flash sql view|view_flash]]
  * [[view_flash_type sql view|view_flash_type]]
  * [[view_lens sql view|view_lens]]
  * [[view_lens_type sql view|view_lens_type]]
  * [[view_scanner sql view|view_scanner]]
  * [[view_scanner_type sql view|view_scanner_type]]
  * [[view_support sql view|view_support]]
  * [[view_support_type sql view|view_support_type]]

=== History ===

== Used first ==

Version 2.5

== Used last ==

Still in use

== Schema change history ==

= Version 2.5 =

<code sql>
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);
</code>