User Tools

Site Tools


podoc:view_scanner_type_sql_view

This is an old revision of the document!


Database View Description of "view_scanner_type"

Name

view_scanner_type

Description

Purpose

Schema

create view view_scanner_type as
  select scanner_type.identifier, manufacturer.name, model, variation, manufacturer.url
    from scanner_type, manufacturer
   where scanner_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_scanner_type as
  select scanner_type.identifier, manufacturer.name, model, variation, manufacturer.url
    from scanner_type, manufacturer
   where scanner_type.manufacturer = manufacturer.identifier
   order by manufacturer.name, model, variation;
podoc/view_scanner_type_sql_view.1176455388.txt.gz · Last modified: 2007/04/13 09:09 by Luud