Changes between Version 13 and Version 14 of Логички и физички дизајн
- Timestamp:
- 12/28/21 13:47:13 (3 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Логички и физички дизајн
v13 v14 8 8 9 9 ---- 10 Admin(** user_id***(User))10 Admin(**__user_id__***(User)) 11 11 12 Cart(** Cart_id,Config_list, Product_list**)12 Cart(**__Cart_id__,Config_list, Product_list**) 13 13 14 14 Checkout(**cart_id***(Cart), **Order-id***(Order)) 15 15 16 Client(** user_id***(User),**Name, Adress, Email, Wishlist_id***(Wishlist))16 Client(**__user_id__***(User),**Name, Adress, Email, Wishlist_id***(Wishlist)) 17 17 18 18 Config_to_whishlist(**Config_id***(Configuration), **Wishlist_id***(Wishlist)) 19 19 20 Configuration (** Config_id, Name, Price, Type**)20 Configuration (**__Config_id__, Name, Price, Type**) 21 21 22 22 Contains (**Prod_id***(Product), **Config_id***(Configuration)) … … 28 28 current_price (**Price_history_id***(Price_history), **Order_id***(Order)) 29 29 30 Delivery (** Delivery_id, Delivery_address, Date, Status, User_id***(Distributor), **User_id***(Client))30 Delivery (**__Delivery_id__, Delivery_address, Date, Status, User_id***(Distributor), **User_id***(Client)) 31 31 32 Distributor(** user_id***(user),**Name, Surname, Contact_number**)32 Distributor(**__user_id__***(user),**Name, Surname, Contact_number**) 33 33 34 34 manages_configuration (**Config_id***(Configuration),** User_id***(Admin)) 35 35 36 Order (** Order_id, Total_price, Order_status, Delivery_id***(Delivery))36 Order (**__Order_id__, Total_price, Order_status, Delivery_id***(Delivery)) 37 37 38 38 Orders_configuration (**Order_id***(Order), **Config_id***(Configuration)) 39 39 40 Payment (** Payment_id, CreditCard_number, Order_id***(Order))40 Payment (**__Payment_id__, CreditCard_number, Order_id***(Order)) 41 41 42 Price_history (** Price_history_id, Price_history_list, Dates, Prod_id***(Product))42 Price_history (**__Price_history_id__, Price_history_list, Dates, Prod_id***(Product)) 43 43 44 Product (** Prod_id, Availability, Name, Price, Type, Description, quantity, Store_name***(Store), **Wishlist_id***(Wishlist))44 Product (**__Prod_id__, Availability, Name, Price, Type, Description, quantity, Store_name***(Store), **Wishlist_id***(Wishlist)) 45 45 46 Seller_Admin(** user_id***(User),N**ame,Surname,E-mail, User_id***(Admin), **Store_name***(Store))46 Seller_Admin(**__user_id__***(User),N**ame,Surname,E-mail, User_id***(Admin), **Store_name***(Store)) 47 47 48 Store(** Store_name,Location, Contact**)48 Store(**__Store_name__,Location, Contact**) 49 49 50 50 updates (**Prod_id***(Product), **User_id***(Seller_Admin), **Time_stamp**) 51 51 52 User(** User_id, password**)52 User(**__User_id__, password**) 53 53 54 54 view_product (**User_id***(Client), **Prod_id***(Product), **Time_stamp**) 55 55 56 Whishlist (** Wishlist_id**, Config_list, Product_list)56 Whishlist (**__Wishlist_id__**, Config_list, Product_list) 57 57 58 58