Photo Organizer

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
===== Database View Description of "view_shop_item_generator_rule" =====

=== Name ===

view_shop_item_generator_rule

=== Description ===

=== Purpose ===

=== Schema ===

<code>
create view view_shop_item_generator_rule as
  select shop_item_generator_rule.identifier,
         shop_category.caption as shop_category,
         shop_item.description as shop_item,
         currency.alpha_code as currency,
         shop_item_generator_rule.price,
         shop_item_generator_rule.comment,
         shop_item_generator_rule.date_of_creation,
         shop_item_generator_rule.date_of_last_edit,
         shop_item_generator_rule.users
    from shop_item_generator_rule, shop_category, shop_item, currency
   where shop_item_generator_rule.shop_item = shop_item.identifier
     and shop_item.category = shop_category.identifier
     and shop_item_generator_rule.currency = currency.identifier
   order by shop_item_generator_rule.date_of_creation;
</code>

=== Related tables ===

  * [[currency sql table|currency]]
  * [[shop_category sql table|shop_category]]
  * [[shop_item sql table|shop_item]]
  * [[shop_item_generator_rule sql table|shop_item_generator_rule]]

=== Related indexes ===

=== Related functions ===

=== Related sequences ===

=== History ===

== Used first ==

Version 2.26

== Used last ==

Version 2.34

== Change history ==

= Version 2.26 =

<code>
create view view_shop_item_generator_rule as
  select shop_item_generator_rule.identifier,
         shop_category.caption as shop_category,
         shop_item.description as shop_item,
         currency.alpha_code as currency,
         shop_item_generator_rule.price,
         shop_item_generator_rule.comment,
         shop_item_generator_rule.date_of_creation,
         shop_item_generator_rule.date_of_last_edit,
         shop_item_generator_rule.users
    from shop_item_generator_rule, shop_category, shop_item, currency
   where shop_item_generator_rule.shop_item = shop_item.identifier
     and shop_item.category = shop_category.identifier
     and shop_item_generator_rule.currency = currency.identifier
   order by shop_item_generator_rule.date_of_creation;
</code>

= Version 2.34 =

<code sql>
drop view view_shop_item_generator_rule;
</code>