podoc:view_support_sql_view
Database View Description of "view_support"
Name
view_support
Description
Purpose
Schema
CREATE VIEW view_support AS SELECT support.identifier, manufacturer.name, model, variation, support.serial_number, support.users, date_of_purchase, support.purchased_new, manufacturer.url, (access_type.value) AS access_rights FROM support_type, support, manufacturer, access_type WHERE support_type.manufacturer = manufacturer.identifier AND support_type.identifier = support.type AND support.access_rights = access_type.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_support AS SELECT support.identifier, manufacturer.name, model, variation, support.serial_number, support.users, date_of_purchase, support.purchased_new, manufacturer.url, (access_type.value) AS access_rights FROM support_type, support, manufacturer, access_type WHERE support_type.manufacturer = manufacturer.identifier AND support_type.identifier = support.type AND support.access_rights = access_type.identifier ORDER BY manufacturer.name, model, variation;
podoc/view_support_sql_view.txt · Last modified: 2007/04/23 14:22 by Luud