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;
Related tables
Related indexes
Related functions
Related sequences
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