User Tools

Site Tools


podoc:view_filter_type_sql_view

Database View Description of "view_filter_type"

Name

view_filter_type

Description

Purpose

Schema

CREATE VIEW view_filter_type AS
  SELECT filter_type.identifier, manufacturer.name, model, variation, manufacturer.url
    FROM filter_type, manufacturer
   WHERE filter_type.manufacturer = manufacturer.identifier
   ORDER BY manufacturer.name, model, variation;

History

Used first

Version 2.5

Used last

Still in use

Change history

= Version 2.5 =

CREATE VIEW view_filter_type AS
  SELECT filter_type.identifier, manufacturer.name, model, variation, manufacturer.url
    FROM filter_type, manufacturer
   WHERE filter_type.manufacturer = manufacturer.identifier
   ORDER BY manufacturer.name, model, variation;
podoc/view_filter_type_sql_view.txt · Last modified: 2007/04/20 15:42 by Luud