User Tools

Site Tools


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

Is referenced by tables

None.

None.

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 11:51 by Luud