5ar6BCQt

1create table if not exists product (
2                                       product_id serial primary key,
3                                       shop_id int4 REFERENCES shop (shop_id),
4                                       article varchar(30),
5                                       name varchar(30),
6                                       description text,
7                                       price float8,
8                                       count int4
9);
10
11create table if not exists shop (
12                                    shop_id serial primary key,
13                                    address_id varchar(30),
14                                    name varchar(30)
15);