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

Timestamp:

12/27/21 19:59:12 (3 years ago)

Author:

183139

Comment:

--

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

@@ -8 +8 @@
 
 ----
+Admin(user_id*(User))
 
-* Admin(user_id*(user))
-* Cart(Cart_id,Config_list, Product_list)
-* Checkout()
-* Client(user_id*(user),Name, Adress, Email)
+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),Name,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)
+