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 photo_format(identifier),
  price                 numeric,
  currency              integer references currency(identifier),
  comment               text,
  date_of_creation      timestamp,
  date_of_last_edit     timestamp
);

• photo

• photo_item_id_sequence

Version 2.8

Still in use

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

None.