camera

A listing of all *specific* cameras that the users owns, 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),
  ignore_comment        BOOLEAN NOT NULL
);

• type references camera_type(identifier)
• users references users(identifier)
• access_rights references access_type(identifier)

• photo_tech(camera) references identifier

• camera_id_sequence

• camera_type_idx
• camera_users_idx

• count_equipment_by_user
• number_of_camera_references

• view_camera

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

= Version 2.34 =

-- Add a flag to ignore the camera's user comments
 
ALTER TABLE camera ADD ignore_comment BOOLEAN;

ALTER TABLE camera ALTER ignore_comment SET NOT NULL;

= Version 2.34 =

UPDATE camera SET ignore_comment = 'f';