User Tools

Site Tools


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

None.

None.

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 11:24 by Luud