Photo Organizer

shop_category

CREATE TABLE shop_category (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  users                 INTEGER NOT NULL REFERENCES users(identifier),
  caption               VARCHAR(300),
  date_of_creation      TIMESTAMP
);

• users references users(identifier)

• shop_item(category) references identifier

• shop_category_id_sequence

None.

None.

None.

Version 2.19

Version 2.33

= Version 2.19 =

CREATE TABLE shop_category (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  users                 INTEGER NOT NULL REFERENCES users(identifier),
  caption               VARCHAR(300),
  date_of_creation      TIMESTAMP
);

= Version 2.34 =

DROP TABLE shop_category;