---

create table "ПОСТАВЩИК" (
"id_поставщика" int generated always as identity primary key,
"наименование" varchar(100) not null,
"ИНН" varchar(12) not null unique ,
"телефон" varchar(15) unique 
);

create table "ПРОДУКТ" (
"id_продукта" int generated always as identity primary key,
"наименование" varchar(100) not null,
"единица_измерения" varchar(20) not null
);

create table "СОТРУДНИК" (
"id_сотрудника" int generated always as identity primary key,
"ФИО" varchar(100) not null,
"телефон" varchar(15) unique,
"должность" varchar(100) not null
);

create table "КУЛИНАРНОЕ_ИЗДЕЛИЕ" (
"id_изделия" int generated always as identity primary key,
"наименование" varchar(100) not null,
"цена" decimal(10,2) not null check ("цена" >=0),
"id_сотрудника" int not null,
constraint "fk_сотрудник" 
foreign key ("id_сотрудника")
references "СОТРУДНИК" ("id_сотрудника")
on delete restrict on update cascade
);

create table "КЛИЕНТ" (
"id_клиента" int generated always as identity primary key,
"ФИО" varchar(100) not null,
"телефон" varchar(15) unique 
);

create table "ЗАКАЗ" (
"id_заказа" int generated always as identity primary key,
"количество" int not null check ("количество" >=0),
"цена" decimal(10,2) not null check ("цена" >=0),
"сумма" decimal(10,2) not null check ("сумма" >=0),
"id_клиента" int not null,
"id_изделия" int not null,
constraint "fk_клиент"
foreign key "id_клиента"
references "КЛИЕНТ"("id_клиента")
on delete restrict on update cascade,
constraint "fk_изделия"
foreign key "id_изделия"
references "КУЛИНАРНОЕ_ИЗДЕЛИЕ"("id_изделия")
in delete restrict on update cascade
);

create table "ПОСТАВКА" (
"id_поставки" INT generated always as identity primary key,
"id_поставщика" int not null,
"id_продукта" int not null,
"дата_поставки" date not null default current date,
"количество" int not null check "количество" >0,
constraint "fk_поставщик"
foreign key "id_поставщика"
references "ПОСТАВЩИК" ("id_поставщика")
on delete restrict on update cascade,
constraint "fk_продукт"
foreign key "id_продукта"
references "ПРОДУКТ" ("id_продукта")
on delete restrict on update cascade
);

> create table "ПОСТАВЩИК" (
"id_поставщика" int generated always as identity primary key,
"наименование" varchar(100) not null,
"ИНН" varchar(12) not null unique ,
"телефон" varchar(15) unique 
)

SQL Error [42P07]: ERROR: relation "ПОСТАВЩИК" already exists

> create table "ПРОДУКТ" (
"id_продукта" int generated always as identity primary key,
"наименование" varchar(100) not null,
"единица_измерения" varchar(20) not null
)

SQL Error [42P07]: ERROR: relation "ПРОДУКТ" already exists

> create table "СОТРУДНИК" (
"id_сотрудника" int generated always as identity primary key,
"ФИО" varchar(100) not null,
"телефон" varchar(15) unique,
"должность" varchar(100) not null
)

SQL Error [42P07]: ERROR: relation "СОТРУДНИК" already exists

> create table "КУЛИНАРНОЕ_ИЗДЕЛИЕ" (
"id_изделия" int generated always as identity primary key,
"наименование" varchar(100) not null,
"цена" decimal(10,2) not null check ("цена" >=0),
"id_сотрудника" int not null,
constraint "fk_сотрудник" 
foreign key ("id_сотрудника")
references "СОТРУДНИК" ("id_сотрудника")
on delete restrict on update cascade
)

SQL Error [42P07]: ERROR: relation "КУЛИНАРНОЕ_ИЗДЕЛИЕ" already exists

> create table "КЛИЕНТ" (
"id_клиента" int generated always as identity primary key,
"ФИО" varchar(100) not null,
"телефон" varchar(15) unique 
)

SQL Error [42P07]: ERROR: relation "КЛИЕНТ" already exists

> create table "ЗАКАЗ" (
"id_заказа" int generated always as identity primary key,
"количество" int not null check ("количество" >=0),
"цена" decimal(10,2) not null check ("цена" >=0),
"сумма" decimal(10,2) not null check ("сумма" >=0),
"id_клиента" int not null,
"id_изделия" int not null,
constraint "fk_клиент"
foreign key "id_клиента"
references "КЛИЕНТ"("id_клиента")
on delete restrict on update cascade,
constraint "fk_изделия"
foreign key "id_изделия"
references "КУЛИНАРНОЕ_ИЗДЕЛИЕ"("id_изделия")
in delete restrict on update cascade
)

SQL Error [42601]: ERROR: syntax error at or near ""id_клиента""
  Позиция: 325

> create table "ПОСТАВКА" (
"id_поставки" INT generated always as identity primary key,
"id_поставщика" int not null,
"id_продукта" int not null,
"дата_поставки" date not null default current date,
"количество" int not null check "количество" >0,
constraint "fk_поставщик"
foreign key "id_поставщика"
references "ПОСТАВЩИК" ("id_поставщика")
on delete restrict on update cascade,
constraint "fk_продукт"
foreign key "id_продукта"
references "ПРОДУКТ" ("id_продукта")
on delete restrict on update cascade
)

SQL Error [42601]: ERROR: syntax error at or near "date"
  Позиция: 191

> create table "ПОСТАВЩИК" (
"id_поставщика" int generated always as identity primary key,
"наименование" varchar(100) not null,
"ИНН" varchar(12) not null unique ,
"телефон" varchar(15) unique 
)

SQL Error [42P07]: ERROR: relation "ПОСТАВЩИК" already exists