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

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