Photo Organizer

shop_transaction_status

CREATE TABLE shop_transaction_status (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(15)
);

None.

• shop_transaction(status) references identifier

• shop_transaction_status_id_sequence

None.

None.

None.

Version 2.8

Version 2.33

= Version 2.8 =

CREATE TABLE shop_transaction_status (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(15)
);

= Version 2.34 =

DROP TABLE shop_transaction_status;

= Version 2.8 =

INSERT INTO shop_transaction_status VALUES (NEXTVAL('shop_transaction_status_id_sequence'), 'Ordered');
INSERT INTO shop_transaction_status VALUES (NEXTVAL('shop_transaction_status_id_sequence'), 'Shipped');