Changes between Version 9 and Version 10 of RelationalDesign

Timestamp:

12/21/21 15:13:46 (3 years ago)

Author:

193230

Comment:

--

RelationalDesign

@@ -22 +22 @@
 ''Online_stores''(**__store_id__, name, web_address, phone_number, email, social_media**)
 
-''Shipping''(**__shipping_id__, location, date_from, date_to**, **user_id***(shipping_employee), **shopping_id***(shopping_bag))
+''Payment''(**__payment_id__, info**)
 
-''Payment''(**__payment_id__, info**)
+''Shipping''(**__shipping_id__, location, date_from, date_to**, user_id*(shipping_employee), shopping_id*(shopping_bag))
 
 ''Category''(**__category_id__, category_name**)
@@ -42 +42 @@
 ''Works_as''(**__id_role*__**(role), **__store_employee_id*__**(store_employee), **works_from**, works_to)
 
-''Exists''(**__catalogue_id*__**(catalogue),**__product_in_store_id*__**(product_in_store))
+''Exists''(**__catalogue_id*__**(catalogue), **__store_id*__**(online_stores), **__product_in_store_id*__**(product_in_store))
 
-''Order''(**__shopping_id*__**(shopping_bag), **__product_in_store_id*__**(product_in_store),**amaunt**)
+''Order''(**__shopping_id*__**(shopping_bag), **__product_in_store_id*__**(product_in_store),**amount**)
 
 == DDL скрипта за бришење и креирање на табелите