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

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

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

----
* User(**__User_id__, password**)
* Distributor(**__Distributor_id__***(User),**Name, Surname, Contact_number**)
* Client(**__User_id__***(User),**Name, Adress, Email)
* Seller_Admin(**__Seller_Admin_id__***(User),**Name,Surname,E-mail**, User_id*(Admin), Store_name*(Store))
* Admin(**__Admin_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**, Distributor_id*(Distributor), Client_id*(Client))
* Price_history (**__Price_history_id__, Price_history_list, Dates**, Prod_id*(Product))
* Wishlist (**__Wishlist_id__** , __Client_id__*(Client), Config_list, Product_list)
* Cart(**__Cart_id__,Config_list, Product_list**, Client_id*(Client))
* Order (**__Order_id__, Total_price, Order_status**, Delivery_id*(Delivery), Client_id*(Client))
* Configuration (**__Config_id__, Name, Price, Type**)
* Payment (**__Payment_id__, CreditCard_number**, Order_id*(Order))
* view_product (**__Client_id__***(Client), **__Prod_id__***(Product), **Time_stamp**)
* updates (**__Prod_id__***(Product), **__Seller_Admin_id__***(Seller_Admin), **Time_stamp**)
* manages_configuration (**__Config_id__***(Configuration),** __Admin_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)]]