Photo Organizer

camera_type

A listing of all known camera types in the system.

We could have several cameras of the same type, so this is a way of specifiying the common stuff.

For example, I could have several 'Nikon D70' cameras, which are otherwise identical – but the specifics (like serial number) are stored in the camera table.

CREATE TABLE camera_type (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  manufacturer          INTEGER NOT NULL REFERENCES manufacturer(identifier),
  model                 VARCHAR(100),
  variation             VARCHAR(100),
  last_modified_date 	TIMESTAMP,
  last_modifying_users	INTEGER REFERENCES users(identifier),
  raw_icc_profile       INTEGER
);

• manufacturer references manufacturer(identifier)
• users references users(identifier)

• camera(type) references identifier

• camera

• camera_type_id_sequence

• camera_type_manufacturer_idx

• number_of_manufacturer_ref

• view_camera
• view_camera_type

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE camera_type (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  manufacturer          INTEGER NOT NULL REFERENCES manufacturer(identifier),
  model                 VARCHAR(100),
  variation             VARCHAR(100),
  last_modified_date 	TIMESTAMP,
  last_modifying_users	INTEGER REFERENCES users(identifier)
);

= Version 2.29 =

ALTER TABLE camera_type ADD raw_icc_profile INTEGER;

= Version 2.29 =

UPDATE camera_type SET raw_icc_profile=NULL;