Photo Organizer

film_type

CREATE TABLE film_type (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  manufacturer          INTEGER NOT NULL REFERENCES manufacturer(identifier),
  model                 VARCHAR(100),
  iso                   INTEGER NOT NULL REFERENCES film_iso(identifier),
  format                INTEGER NOT NULL REFERENCES film_format(identifier),
  last_modified_date 	TIMESTAMP,
  last_modifying_users	INTEGER REFERENCES users(identifier)
);

• format references film_format(identifier)
• iso references film_iso(identifier)
• last_modifying_users references users(identifier)
• manufacturer references manufacturer(identifier)

• film(type) references identifier

• film_type_id_sequence

• film_type_manufacturer_idx

• number_of_manufacturer_ref

• view_film
• view_film_type

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE film_type (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  manufacturer          INTEGER NOT NULL REFERENCES manufacturer(identifier),
  model                 VARCHAR(100),
  iso                   INTEGER NOT NULL REFERENCES film_iso(identifier),
  format                INTEGER NOT NULL REFERENCES film_format(identifier),
  last_modified_date 	TIMESTAMP,
  last_modifying_users	INTEGER REFERENCES users(identifier)
);