User Tools

Site Tools


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
);

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
);
Data change history

= Version 2.8 =

None.

podoc/shop_order_sql_table.1176723963.txt.gz · Last modified: 2007/04/16 11:46 by Luud