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


Ignore:
Timestamp:
12/28/21 17:53:09 (3 years ago)
Author:
186102
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

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

    v23 v24  
    88
    99----
    10 User(**__User_id__, password**)
    11 
    12 Distributor(**__user_id__***(user),**Name, Surname, Contact_number**)
    13 
    14 Client(**__user_id__***(User),**Name, Adress, Email, Wishlist_id***(Wishlist))
    15 
    16 Seller_Admin(**__user_id__***(User),N**ame,Surname,E-mail, User_id***(Admin), **Store_name***(Store))
    17 
    18 Admin(**__user_id__***(User))
    19 
    20 Product (**__Prod_id__, Availability, Name, Price, Type, Description, quantity, Store_name***(Store), **Wishlist_id***(Wishlist))
    21 
    22 Store(**__Store_name__,Location, Contact**)
    23 
    24 Delivery (**__Delivery_id__, Delivery_address, Date, Status, User_id***(Distributor), **User_id***(Client))
    25 
    26 Price_history (**__Price_history_id__, Price_history_list, Dates, Prod_id***(Product))
    27 
    28 Whishlist (**__Wishlist_id__**, Config_list, Product_list)
    29 
    30 Cart(**__Cart_id__,Config_list, Product_list**)
    31 
    32 Order (**__Order_id__, Total_price, Order_status, Delivery_id***(Delivery))
    33 
    34 Configuration (**__Config_id__, Name, Price, Type**)
    35 
    36 Payment (**__Payment_id__, CreditCard_number, Order_id***(Order))
    37 
    38 view_product (**User_id***(Client), **Prod_id***(Product), **Time_stamp**)
    39 
    40 updates (**Prod_id***(Product), **User_id***(Seller_Admin), **Time_stamp**)
    41 
    42 manages_configuration (**Config_id***(Configuration),** User_id***(Admin))
    43 
    44 contains_product (**Prod_id***(Product), **Cart_id***(Cart))
    45 
    46 contains_config (**Config_id***(Configuration),** Cart_id***(Cart))
    47 
    48 current_price (**Price_history_id***(Price_history), **Order_id***(Order))
    49 
    50 orders_configuration  (**Order_id***(Order), **Config_id***(Configuration))
    51 
    52 product_to_wishlist (**Prod_id***(Product), **Wishlist_id***(Wishlist))
    53 
    54 config_to_whishlist(**Config_id***(Configuration), **Wishlist_id***(Wishlist))
    55 
    56 checkout(**cart_id***(Cart), **Order-id***(Order))
    57 
    58 config_contains_product(**Prod_id***(Product), **Config_id***(Configuration))
     10* User(**__User_id__, password**)
     11* Distributor(**__user_id__***(user),**Name, Surname, Contact_number**)
     12* Client(**__user_id__***(User),**Name, Adress, Email, Wishlist_id***(Wishlist))
     13* Seller_Admin(**__user_id__***(User),N**ame,Surname,E-mail, User_id***(Admin), **Store_name***(Store))
     14* Admin(**__user_id__***(User))
     15* Product (**__Prod_id__, Availability, Name, Price, Type, Description, quantity, Store_name***(Store), **Wishlist_id***(Wishlist))
     16* Store(**__Store_name__,Location, Contact**)
     17* Delivery (**__Delivery_id__, Delivery_address, Date, Status, User_id***(Distributor), **User_id***(Client))
     18* Price_history (**__Price_history_id__, Price_history_list, Dates, Prod_id***(Product))
     19* Whishlist (**__Wishlist_id__**, Config_list, Product_list)
     20* Cart(**__Cart_id__,Config_list, Product_list**)
     21* Order (**__Order_id__, Total_price, Order_status, Delivery_id***(Delivery))
     22* Configuration (**__Config_id__, Name, Price, Type**)
     23* 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))
     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))
    5935
    6036== DDL скрипта за бришење на табелите и креирање на табелите