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

Timestamp:

12/28/21 14:54:13 (3 years ago)

Author:

183139

Comment:

--

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

@@ -8 +8 @@
 
 ----
+User(**__User_id__, password**)
+
+Client(**__user_id__***(User),**Name, Adress, Email, Wishlist_id***(Wishlist))
+
+view_product (**User_id***(Client), **Prod_id***(Product), **Time_stamp**)
+
+Seller_Admin(**__user_id__***(User),N**ame,Surname,E-mail, User_id***(Admin), **Store_name***(Store))
+
+updates (**Prod_id***(Product), **User_id***(Seller_Admin), **Time_stamp**)
+
+Distributor(**__user_id__***(user),**Name, Surname, Contact_number**)
+
 Admin(**__user_id__***(User))
+
+Product (**__Prod_id__, Availability, Name, Price, Type, Description, quantity, Store_name***(Store), **Wishlist_id***(Wishlist))
+
+contains_product (**Prod_id***(Product), **Cart_id***(Cart))
+
+Whishlist (**__Wishlist_id__**, Config_list, Product_list)
+
+Store(**__Store_name__,Location, Contact**)
 
 Cart(**__Cart_id__,Config_list, Product_list**)
 
-Checkout(**cart_id***(Cart), **Order-id***(Order))
+contains_config (**Config_id***(Configuration),** Cart_id***(Cart))
 
-Client(**__user_id__***(User),**Name, Adress, Email, Wishlist_id***(Wishlist))
+Order (**__Order_id__, Total_price, Order_status, Delivery_id***(Delivery))
+
+current_price (**Price_history_id***(Price_history), **Order_id***(Order))
+
+Configuration (**__Config_id__, Name, Price, Type**)
 
 Config_to_whishlist(**Config_id***(Configuration), **Wishlist_id***(Wishlist))
 
-Configuration (**__Config_id__, Name, Price, Type**)
+Price_history (**__Price_history_id__, Price_history_list, Dates, Prod_id***(Product))
+
+Payment (**__Payment_id__, CreditCard_number, Order_id***(Order))
+
+Checkout(**cart_id***(Cart), **Order-id***(Order))
 
 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)]]