podoc:shop_item_generator_rule_sql_table
Database Table Description of "shop_item_generator_rule"
Name
shop_item_generator_rule
Description
Purpose
Schema
CREATE TABLE shop_item_generator_rule ( identifier INTEGER NOT NULL PRIMARY KEY, users INTEGER NOT NULL REFERENCES users(identifier), shop_item INTEGER NOT NULL REFERENCES shop_item(identifier), price NUMERIC, currency INTEGER REFERENCES currency(identifier), comment text, date_of_creation TIMESTAMP, date_of_last_edit TIMESTAMP );
References tables
Is referenced by tables
None.
Related sequences
Related indexes
None.
Related functions
None.
Related views
History
Used first
Version 2.26
Used last
Version 2.33
Schema change history
= Version 2.26 =
CREATE TABLE shop_item_generator_rule ( identifier INTEGER NOT NULL PRIMARY KEY, users INTEGER NOT NULL REFERENCES users(identifier), shop_item INTEGER NOT NULL REFERENCES shop_item(identifier), price NUMERIC, currency INTEGER REFERENCES currency(identifier), comment text, date_of_creation TIMESTAMP, date_of_last_edit TIMESTAMP );
= Version 2.34 =
DROP TABLE shop_item_generator_rule;
Data change history
podoc/shop_item_generator_rule_sql_table.txt · Last modified: 2007/10/19 15:51 by Luud