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

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)
);