podoc:shop_order_sql_table
This is an old revision of the document!
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 );
Related tables
Related sequences
Related indexes
None.
Related functions
Related views
History
Used first
Version 2.8
Used last
Still in use
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;
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.1176908350.txt.gz · Last modified: 2007/04/18 14:59 by Luud