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;