Changes between Version 29 and Version 30 of Логички и физички дизајн

Timestamp:

12/29/21 10:18:58 (3 years ago)

Author:

181207

Comment:

--

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

@@ -9 +9 @@
 ----
 * User(**__User_id__, password**)
-* Distributor(**__user_id__***(user),**Name, Surname, Contact_number**)
+* Distributor(**__user_id__***(User),**Name, Surname, Contact_number**)
 * Client(**__user_id__***(User),**Name, Adress, Email)
-* Seller_Admin(**__user_id__***(User),N**ame,Surname,E-mail, User_id***(Admin), **Store_name***(Store))
+* 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), **Wishlist_id***(Wishlist))
+* 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**)
-* Order (**__Order_id__, Total_price, Order_status, Delivery_id***(Delivery))
+* 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))
@@ -27 +27 @@
 * 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))
+* 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))
+* config_contains_product(**Prod_id***(Product), **Config_id***(Configuration), **num_products_config**)
 
 == DDL скрипта за бришење на табелите и креирање на табелите