Креирање на табели

---

create table users
(

id bigserial primary key,
first_name varchar(255),
last_name varchar(255),
phone_number varchar(255),
email varchar(255) unique,
password varchar(255),
role varchar(255)

);

---

create table address
(

id bigserial primary key,
address varchar(255),
user_id bigint,
foreign key (user_id) references users (id)

on delete cascade
on update cascade

);

---

create table category (

id bigserial primary key, name varchar(255), category_id bigint references category (id)

on delete cascade on update cascade

);

---

create table supplier (

id bigserial primary key, name varchar(255), location varchar(255), phone_number varchar(255)

);

---

create table product (

id bigserial primary key, name varchar(255), description varchar(255), image bytea, quantity integer, category_id bigint references category (id)

on delete set null on update cascade,

supplier_id bigint references supplier (id)

on delete set null on update cascade

);

---

create table product_price (

product_id bigint, price integer, start_date date, end_date date, foreign key (product_id) references product (id)

on delete cascade on update cascade,

primary key (product_id, price, start_date), check ( price > 0 ), check ( end_date >= start_date )

);

---

create table property (

id bigserial primary key, name varchar(255)

);

---

create table product_property (

product_id bigint, property_id bigint, value varchar(255), foreign key (product_id) references product (id)

on delete cascade on update cascade,

foreign key (property_id) references property (id)

on delete cascade on update cascade,

primary key (product_id, property_id)

);

---

create table orders (

id bigserial primary key, status varchar(255), date date, price integer, user_id bigint, foreign key (user_id) references users (id)

on delete set null on update cascade

);

---

create table order_details (

order_id bigint, product_id bigint, quantity integer, foreign key (order_id) references orders (id)

on delete cascade on update cascade,

foreign key (product_id) references product (id)

on delete cascade on update cascade,

primary key (order_id, product_id)

);