User Tools

Site Tools


podoc:view_shop_item_generator_rule_sql_view

Database View Description of "view_shop_item_generator_rule"

Name

view_shop_item_generator_rule

Description

Purpose

Schema

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;

History

Used first

Version 2.26

Used last

Version 2.34

Change history

= Version 2.26 =

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;

= Version 2.34 =

DROP VIEW view_shop_item_generator_rule;
podoc/view_shop_item_generator_rule_sql_view.txt · Last modified: 2007/10/19 15:53 by Luud