Differences

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

--- podoc:view_scanner_type_sql_view [2007/04/12 12:23] – created Luud
+++ podoc:view_scanner_type_sql_view [2007/04/23 14:21] (current) – Luud
@@ Line 1: / Line 1: @@
-===== Database View Description =====
+===== Database View Description of "view_scanner_type" =====
 === Name ===
+view_scanner_type
 === Description ===
@@ Line 9: / Line 11: @@
 === 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 ===
@@ Line 31: / Line 38: @@
 = 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>