shop_transaction

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

• status references shop_transaction_status(identifier)

• shop_order(transaction) references identifier

• shop_transaction_id_sequence

None.

None.

None.

Version 2.8

Version 2.33

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