Photo Organizer

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;