Photo Organizer

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