User Tools

Site Tools


podoc:view_flash_type_sql_view

Differences

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

Link to this comparison view

Last revisionBoth sides next revision
podoc:view_flash_type_sql_view [2007/04/12 12:23] – created Luudpodoc:view_flash_type_sql_view [2007/04/13 07:48] Luud
Line 1: Line 1:
-===== Database View Description =====+===== Database View Description of "view_flash_type" =====
  
 === Name === === Name ===
 +
 +view_flash_type
  
 === Description === === Description ===
Line 9: Line 11:
 === Schema === === Schema ===
  
-=== Related tables===+  create view view_flash_type as 
 +    select flash_type.identifier, manufacturer.name, model, variation, manufacturer.url 
 +      from flash_type, manufacturer 
 +     where flash_type.manufacturer manufacturer.identifier 
 +     order by manufacturer.name, model, variation;
  
-=== Related sequences ===+=== Related tables === 
 + 
 +  * [[flash_type sql table|flash_type]] 
 +  * [[manufacturer sql table|manufacturer]]
  
 === Related indexes === === Related indexes ===
  
 === Related functions === === Related functions ===
 +
 +=== Related views ===
  
 === History === === History ===
Line 31: Line 42:
 = Version 2.5 = = Version 2.5 =
  
-  create view ... ( +  create view view_flash_type as 
-    ...   +    select flash_type.identifier, manufacturer.name, model, variation, manufacturer.url 
-  );+      from flash_type, manufacturer 
 +     where flash_type.manufacturer = manufacturer.identifier 
 +     order by manufacturer.name, model, variation; 
podoc/view_flash_type_sql_view.txt · Last modified: 2007/04/20 15:43 by Luud