podoc:shop_order_sql_table
Database Table Description of "shop_order"
Name
shop_order
Description
Purpose
Schema
CREATE TABLE shop_order ( identifier INTEGER NOT NULL PRIMARY KEY, client INTEGER REFERENCES users(identifier), TRANSACTION INTEGER REFERENCES shop_transaction, item INTEGER NOT NULL REFERENCES photo_item, pieces NUMERIC, date_of_creation TIMESTAMP, date_of_last_edit TIMESTAMP, download_counter INTEGER, download_expiry_date DATE );
References tables
- client references users(identifier)
- item references photo_item(identifier)
- transaction references shop_transaction(identifier)
Is referenced by tables
None.
Related sequences
Related indexes
None.
Related functions
Related views
None.
History
Used first
Version 2.8
Used last
Version 2.33
Schema change history
= Version 2.8 =
CREATE TABLE shop_order ( identifier INTEGER NOT NULL PRIMARY KEY, client INTEGER REFERENCES users(identifier), TRANSACTION INTEGER REFERENCES shop_transaction, item INTEGER NOT NULL REFERENCES photo_item, pieces NUMERIC, date_of_creation TIMESTAMP, date_of_last_edit TIMESTAMP );
= Version 2.19 =
ALTER TABLE shop_order ADD COLUMN download_counter INTEGER; ALTER TABLE shop_order ADD COLUMN download_expiry_date DATE;
= Version 2.34 =
DROP TABLE shop_order;
Data change history
= Version 2.19 =
UPDATE shop_order SET download_counter = 0; UPDATE shop_order SET download_expiry_date = now();
podoc/shop_order_sql_table.txt · Last modified: 2007/10/19 15:52 by Luud