= Логички и физички дизајн

== Релациска шема (мапирачка трансформација)

* Примарни клучеви: bold и underline
* Надворешни клучеви: bold и * до името на надворешниот клуч, во заграда табелата кон која покажува
* Not null атрибути: bold

----
Admin(**user_id***(User))

Cart(**Cart_id,Config_list, Product_list**)

Checkout(**cart_id***(Cart), **Order-id***(Order))

Client(**user_id***(User),**Name, Adress, Email, Wishlist_id***(Wishlist))

Config_to_whishlist(**Config_id***(Configuration), **Wishlist_id***(Wishlist))

Configuration (**Config_id, Name, Price, Type**)

Contains (**Prod_id***(Product), **Config_id***(Configuration))

contains_config (**Config_id***(Configuration),** Cart_id***(Cart))

contains_product (**Prod_id***(Product), **Cart_id***(Cart))

current_price (**Price_history_id***(Price_history), **Order_id***(Order))

Delivery (**Delivery_id, Delivery_address, Date, Status, User_id***(Distributor), **User_id***(Client))

Distributor(**user_id***(user),**Name, Surname, Contact_number**)

manages_configuration (**Config_id***(Configuration),** User_id***(Admin))

Order (**Order_id, Total_price, Order_status, Delivery_id***(Delivery))

Orders_configuration  (**Order_id***(Order), **Config_id***(Configuration))

Payment (**Payment_id, CreditCard_number, Order_id***(Order))

Price_history (**Price_history_id, Price_history_list, Dates, Prod_id***(Product))

Product (**Prod_id, Availability, Name, Price, Type, Description, quantity, Store_name***(Store), Wishlist_id*(Wishlist))

Seller_Admin(**user_id***(User),N**ame,Surname,E-mail, User_id***(Admin), **Store_name***(Store))

Store(**Store_name,Location, Contact**)

updates (**Prod_id***(Product), **User_id***(Seller_Admin), **Time_stamp**)

User(**User_id, password**)

view_product (**User_id***(Client), **Prod_id***(Product), **Time_stamp**)

Whishlist (**Wishlist_id**, Config_list, Product_list)


 
== Релациски дијаграм од DBeaver
[[Image(DDL1.png)]]