photo_item

CREATE TABLE photo_item (
  identifier            integer NOT NULL PRIMARY KEY,
  photo                 integer NOT NULL REFERENCES photo(identifier),
  shop_item             integer NOT NULL REFERENCES shop_item(identifier),
  price                 numeric,
  currency              integer REFERENCES currency(identifier),
  comment               text,
  date_of_creation      timestamp,
  date_of_last_edit     timestamp
  deleted               char(1) CHECK (deleted IN ('t', 'f'));
);

• currency references currency(identifier)
• photo references photo(identifier)
• shop_item references shop_item(identifier)

• shop_order(item) references identifier

• photo_item_id_sequence

None.

• is_photo_for_sale
• photo_shop_transaction_references

None.

Version 2.8

Version 2.33

= Version 2.8 =

CREATE TABLE photo_item (
  identifier            integer NOT NULL PRIMARY KEY,
  photo                 integer NOT NULL REFERENCES photo(identifier),
  format                integer NOT NULL REFERENCES photo_format(identifier),
  price                 numeric,
  currency              integer REFERENCES currency(identifier),
  comment               text,
  date_of_creation      timestamp,
  date_of_last_edit     timestamp
);

= Version 2.19 =

ALTER TABLE photo_item RENAME COLUMN format TO shop_item;

= Version 2.29 =

ALTER TABLE photo_item ADD deleted char(1) CHECK (deleted IN ('t', 'f'));

= Version 2.34 =

DROP TABLE photo_item;

= Version 2.29 =

UPDATE photo_item SET deleted='f';