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


Ignore:
Timestamp:
12/29/21 11:56:20 (3 years ago)
Author:
181207
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Логички и физички дизајн

    v31 v32  
    1717* Delivery (**__Delivery_id__, Delivery_address, Date, Status, User_id***(Distributor), **User_id***(Client))
    1818* Price_history (**__Price_history_id__, Price_history_list, Dates, Prod_id***(Product))
    19 * Wishlist (**__Wishlist_id__**, Config_list, Product_list, **User_id***(Client))
     19* Wishlist (**__Wishlist_id__** , **__User_id__***(Client), Config_list, Product_list)
    2020* Cart(**__Cart_id__,Config_list, Product_list, User_id***(Client))
    2121* Order (**__Order_id__, Total_price, Order_status, Delivery_id***(Delivery), **User_id***(Client))
    2222* Configuration (**__Config_id__, Name, Price, Type**)
    2323* Payment (**__Payment_id__, CreditCard_number, Order_id***(Order))
    24 * view_product (**User_id***(Client), **Prod_id***(Product), **Time_stamp**)
    25 * updates (**Prod_id***(Product), **User_id***(Seller_Admin), **Time_stamp**)
    26 * manages_configuration (**Config_id***(Configuration),** User_id***(Admin))
    27 * contains_product (**Prod_id***(Product), **Cart_id***(Cart))
    28 * contains_config (**Config_id***(Configuration),** Cart_id***(Cart))
    29 * current_price (**Price_history_id***(Price_history), **Order_id***(Order), **num_products**)
    30 * orders_configuration  (**Order_id***(Order), **Config_id***(Configuration))
    31 * product_to_wishlist (**Prod_id***(Product), **Wishlist_id***(Wishlist))
    32 * config_to_whishlist(**Config_id***(Configuration), **Wishlist_id***(Wishlist))
    33 * checkout(**Cart_id***(Cart), **Order-id***(Order))
    34 * config_contains_product(**Prod_id***(Product), **Config_id***(Configuration), **num_products_config**)
     24* view_product (**__User_id__***(Client), **__Prod_id__***(Product), **Time_stamp**)
     25* updates (**__Prod_id__***(Product), **__User_id__***(Seller_Admin), **Time_stamp**)
     26* manages_configuration (**__Config_id__***(Configuration),** __User_id__***(Admin))
     27* contains_product (**__Prod_id__***(Product), **__Cart_id__***(Cart))
     28* contains_config (**__Config_id__***(Configuration),** __Cart_id__***(Cart))
     29* current_price (**__Price_history_id__***(Price_history), **__Order_id__***(Order), **num_products**)
     30* orders_configuration  (**__Order_id__***(Order), **__Config_id__***(Configuration))
     31* product_to_wishlist (**__Prod_id__***(Product), **__Wishlist_id__***(Wishlist))
     32* config_to_whishlist(**__Config_id__***(Configuration), **__Wishlist_id__***(Wishlist))
     33* checkout(**Cart_id__***(Cart), **Order-id__***(Order))
     34* config_contains_product(**__Prod_id__***(Product), **__Config_id__***(Configuration), **num_products_config**)
    3535
    3636== DDL скрипта за бришење на табелите и креирање на табелите