Changes between Version 11 and Version 12 of Логички и физички дизајн
- Timestamp:
- 12/27/21 20:03:17 (3 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Логички и физички дизајн
v11 v12 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 Checkout( cart_id*(Cart), Order-id*(Order))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 Config_to_whishlist( Config_id*(Configuration), Wishlist_id*(Wishlist))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 Contains ( Prod_id*(Product), Config_id*(Configuration))22 Contains (**Prod_id***(Product), **Config_id***(Configuration)) 23 23 24 contains_config ( Config_id*(Configuration), Cart_id*(Cart))24 contains_config (**Config_id***(Configuration),** Cart_id***(Cart)) 25 25 26 contains_product ( Prod_id*(Product), Cart_id*(Cart))26 contains_product (**Prod_id***(Product), **Cart_id***(Cart)) 27 27 28 current_price ( Price_history_id*(Price_history), Order_id*(Order))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 manages_configuration ( Config_id*(Configuration), User_id*(Admin))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 Orders_configuration ( Order_id*(Order), Config_id*(Configuration))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),Name,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 updates ( Prod_id*(Product), User_id*(Seller_Admin), Time_stamp)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 view_product ( User_id*(Client), Prod_id*(Product), Time_stamp)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