===== Database Table Description of "filter_type" =====

=== Name ===

filter_type

=== Description ===

=== Purpose ===

=== Schema ===

<code sql>
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)
);
</code>

=== References tables ===

  * manufacturer references [[manufacturer sql table|manufacturer]](identifier)
  * last_modifying_users references [[users sql table|users]](identifier)

=== Is referenced by tables ===

  * [[filter sql table|filter]](users) references identifier

=== Related sequences ===

  * [[filter_type_id_sequence sql sequence|filter_type_id_sequence]]

=== Related indexes ===

  * [[filter_type_manufacturer_idx sql index|filter_type_manufacturer_idx]]

=== Related functions ===

None.

=== Related views ===

  * [[view_filter sql view|view_filter]]
  * [[view_filter_type sql view|view_filter_type]]

=== History ===

== Used first ==

Version 2.5

== Used last ==

Still in use

== Change history ==

= Version 2.5 =

<code sql>
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)
);
</code>