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

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

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

----
* User(**__User_id__, password**)
* Distributor(**__User_id__***(User),**Name, Surname, Contact_number**)
* Client(**__User_id__***(User),**Name, Adress, Email)
* Seller_Admin(**__User_id__***(User),**Name,Surname,E-mail, User_id***(Admin), **Store_name***(Store))
* Admin(**__User_id__***(User))
* Product (**__Prod_id__, Availability, Name, Price, Type, Description, quantity, Store_name***(Store)**)
* Store(**__Store_name__,Location, Contact**)
* Delivery (**__Delivery_id__, Delivery_address, Date, Status, User_id***(Distributor), **User_id***(Client))
* Price_history (**__Price_history_id__, Price_history_list, Dates, Prod_id***(Product))
* Wishlist (**__Wishlist_id__**, Config_list, Product_list, **User_id***(Client))
* Cart(**__Cart_id__,Config_list, Product_list, User_id***(Client))
* Order (**__Order_id__, Total_price, Order_status, Delivery_id***(Delivery), **User_id***(Client))
* Configuration (**__Config_id__, Name, Price, Type**)
* Payment (**__Payment_id__, CreditCard_number, Order_id***(Order))
* view_product (**User_id***(Client), **Prod_id***(Product), **Time_stamp**)
* updates (**Prod_id***(Product), **User_id***(Seller_Admin), **Time_stamp**)
* manages_configuration (**Config_id***(Configuration),** User_id***(Admin))
* contains_product (**Prod_id***(Product), **Cart_id***(Cart))
* contains_config (**Config_id***(Configuration),** Cart_id***(Cart))
* current_price (**Price_history_id***(Price_history), **Order_id***(Order), **num_products**)
* orders_configuration  (**Order_id***(Order), **Config_id***(Configuration))
* product_to_wishlist (**Prod_id***(Product), **Wishlist_id***(Wishlist))
* config_to_whishlist(**Config_id***(Configuration), **Wishlist_id***(Wishlist))
* checkout(**Cart_id***(Cart), **Order-id***(Order))
* config_contains_product(**Prod_id***(Product), **Config_id***(Configuration), **num_products_config**)

== DDL скрипта за бришење на табелите и креирање на табелите
'''[attachment:kreiranje.sql]'''
== DML скрипта за полнење на табелите со податоци
'''[attachment:polnenje.sql]'''
== Релациски дијаграм од DBeaver
[[Image(DDL3.png)]]