Photo Organizer

camera

A listing of all *specific* cameras that the users own, complete with serial number. A camera can be associated with a photo.

A user should be able to keep track of their cameras.

create table camera (
  identifier            integer not null primary key,
  type                  integer references camera_type(identifier),
  users                 integer references users(identifier),
  serial_number         varchar(20),
  date_of_purchase      timestamp,
  purchased_new         char(1) check (purchased_new in ('t', 'f')),
  access_rights         integer not null references access_type(identifier)
);

• camera_id_sequence

• camera_type_idx
• camera_users_idx

• count_equipment_by_user

Version 2.5

Still in use

= Version 2.5 =

create table camera (
  identifier            integer not null primary key,
  type                  integer references camera_type(identifier),
  users                 integer references users(identifier),
  serial_number         varchar(20),
  date_of_purchase      timestamp,
  purchased_new         char(1) check (purchased_new in ('t', 'f')),
  access_rights         integer not null references access_type(identifier)
);