Changes between Initial Version and Version 1 of phase0

Timestamp:

03/06/24 23:52:10 (10 months ago)

Author:

201166

Comment:

--

phase0

@@ +1 @@
+= Креирање на табели 
+----
+
+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)
+);