Photo Organizer

lens

CREATE TABLE lens (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  TYPE                  INTEGER NOT NULL REFERENCES lens_type(identifier),
  users                 INTEGER NOT NULL 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)
);

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

• photo_tech(lens) references identifier

• lens_id_sequence

• lens_type_idx
• lens_users_idx

• count_equipment_by_user
• number_of_lens_references

• view_lens

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE lens (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  TYPE                  INTEGER NOT NULL REFERENCES lens_type(identifier),
  users                 INTEGER NOT NULL 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)
);