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;
Related tables
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;
