filter_type

CREATE TABLE filter_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)
);

• manufacturer references manufacturer(identifier)
• last_modifying_users references users(identifier)

• filter(users) references identifier

• filter_type_id_sequence

• filter_type_manufacturer_idx

None.

• view_filter
• view_filter_type

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE filter_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)
);