podoc:shop_transaction_sql_table
Database Table Description of "shop_transaction"
Name
shop_transaction
Description
Purpose
Schema
CREATE TABLE shop_transaction ( identifier INTEGER NOT NULL PRIMARY KEY, STATUS INTEGER NOT NULL REFERENCES shop_transaction_status(identifier), remark text, date_of_creation TIMESTAMP, date_of_last_edit TIMESTAMP );
References tables
- status references shop_transaction_status(identifier)
Is referenced by tables
- shop_order(transaction) references identifier
Related sequences
Related indexes
None.
Related functions
None.
Related views
None.
History
Used first
Version 2.8
Used last
Version 2.33
Schema change history
= Version 2.8 =
CREATE TABLE shop_transaction ( identifier INTEGER NOT NULL PRIMARY KEY, STATUS INTEGER NOT NULL REFERENCES shop_transaction_status(identifier), remark text, date_of_creation TIMESTAMP, date_of_last_edit TIMESTAMP );
= Version 2.34 =
DROP TABLE shop_transaction;
Data change history
podoc/shop_transaction_sql_table.txt · Last modified: 2007/10/19 15:51 by Luud