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
Last revision Both sides next revision
podoc:view_scanner_type_sql_view [2007/04/12 08:23]
Luud created
podoc:view_scanner_type_sql_view [2007/04/13 05:09]
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===+  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 ​sequences ​===+=== Related ​tables ​=== 
 + 
 +  * [[scanner_type sql table|scanner_type]] 
 +  * [[manufacturer sql table|manufacturer]]
  
 === Related indexes === === Related indexes ===
  
 === Related functions === === Related functions ===
 +
 +=== Related sequences ===
  
 === History === === History ===
Line 31: Line 42:
 = Version 2.5 = = Version 2.5 =
  
-  create view ... ( +  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; 
podoc/view_scanner_type_sql_view.txt · Last modified: 2007/04/23 10:21 by Luud