User Tools

Site Tools


podoc:view_scanner_type_sql_view

Differences

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

Link to this comparison view

Next revision
Previous revision
podoc:view_scanner_type_sql_view [2007/04/12 08:23]
Luud created
podoc:view_scanner_type_sql_view [2007/04/23 10:21]
Luud
Line 1: Line 1:
-===== Database View Description =====+===== Database View Description ​of "​view_scanner_type" ​=====
  
 === Name === === Name ===
 +
 +view_scanner_type
  
 === Description === === Description ===
Line 9: Line 11:
 === Schema === === Schema ===
  
-=== Related tables===+<code sql> 
 +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;​ 
 +</​code>​
  
-=== Related ​sequences ​===+=== Related ​tables ​===
  
-=== Related indexes === +  * [[scanner_type sql table|scanner_type]] 
- +  * [[manufacturer sql table|manufacturer]]
-=== Related functions ===+
  
 === History === === History ===
Line 31: Line 38:
 = Version 2.5 = = Version 2.5 =
  
-  ​create view ... ( +<​code>​ 
-    ...  ​ +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; 
 +</​code>​ 
podoc/view_scanner_type_sql_view.txt · Last modified: 2007/04/23 10:21 by Luud