User Tools

Site Tools


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;

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 10:22 by Luud