filter

CREATE TABLE filter (
  identifier            integer NOT NULL PRIMARY KEY,
  type                  integer NOT NULL REFERENCES filter_type(identifier),
  users                 integer NOT NULL REFERENCES users(identifier),
  date_of_purchase      timestamp,
  purchased_new         char(1) CHECK (purchased_new IN ('t', 'f')),
  access_rights         integer NOT NULL REFERENCES access_type(identifier),
  serial_number         varchar(20);
);

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

• photo_tech(filter) references identifier

• filter_id_sequence

• filter_type_idx
• filter_users_idx

• number_of_filter_references

• view_filter

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE filter (
  identifier            integer NOT NULL PRIMARY KEY,
  type                  integer NOT NULL REFERENCES filter_type(identifier),
  users                 integer NOT NULL REFERENCES users(identifier),
  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.33 =

-- Add another column to the filters
ALTER TABLE filter ADD serial_number varchar(20);