User Tools

Site Tools


podoc:view_scanner_sql_view

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
podoc:view_scanner_sql_view [2007/04/13 05:10]
Luud
podoc:view_scanner_sql_view [2007/04/23 10:20] (current)
Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-  ​create view view_scanner as +<code sql> 
-    select scanner.identifier,​ manufacturer.name,​ model, variation, scanner.serial_number,​ scanner.users,​ date_of_purchase,​ scanner.purchased_new,​ manufacturer.url,​ (access_type.value) as access_rights +create view view_scanner as 
-      from scanner_type,​ scanner, manufacturer,​ access_type +  select scanner.identifier,​ manufacturer.name,​ model, variation, scanner.serial_number,​ scanner.users,​ date_of_purchase,​ scanner.purchased_new,​ manufacturer.url,​ (access_type.value) as access_rights 
-     ​where scanner_type.manufacturer = manufacturer.identifier +    from scanner_type,​ scanner, manufacturer,​ access_type 
-       ​and scanner_type.identifier = scanner.type +   ​where scanner_type.manufacturer = manufacturer.identifier 
-       ​and scanner.access_rights = access_type.identifier +     ​and scanner_type.identifier = scanner.type 
-     ​order by manufacturer.name,​ model, variation;+     ​and scanner.access_rights = access_type.identifier 
 +   ​order by manufacturer.name,​ model, variation; 
 +</​code>​
  
 === Related tables === === Related tables ===
Line 25: Line 27:
   * [[scanner_type sql table|scanner_type]]   * [[scanner_type sql table|scanner_type]]
   * [[manufacturer sql table|manufacturer]]   * [[manufacturer sql table|manufacturer]]
- 
-=== Related indexes === 
- 
-=== Related functions === 
- 
-=== Related sequences === 
- 
 === History === === History ===
  
Line 46: Line 41:
 = Version 2.5 = = Version 2.5 =
  
-  ​create view view_scanner as +<code sql> 
-    select scanner.identifier,​ manufacturer.name,​ model, variation, scanner.serial_number,​ scanner.users,​ date_of_purchase,​ scanner.purchased_new,​ manufacturer.url,​ (access_type.value) as access_rights +create view view_scanner as 
-      from scanner_type,​ scanner, manufacturer,​ access_type +  select scanner.identifier,​ manufacturer.name,​ model, variation, scanner.serial_number,​ scanner.users,​ date_of_purchase,​ scanner.purchased_new,​ manufacturer.url,​ (access_type.value) as access_rights 
-     ​where scanner_type.manufacturer = manufacturer.identifier +    from scanner_type,​ scanner, manufacturer,​ access_type 
-       ​and scanner_type.identifier = scanner.type +   ​where scanner_type.manufacturer = manufacturer.identifier 
-       ​and scanner.access_rights = access_type.identifier +     ​and scanner_type.identifier = scanner.type 
-     ​order by manufacturer.name,​ model, variation;+     ​and scanner.access_rights = access_type.identifier 
 +   ​order by manufacturer.name,​ model, variation; 
 +</​code>​
  
podoc/view_scanner_sql_view.txt · Last modified: 2007/04/23 10:20 by Luud