Changes between Version 3 and Version 4 of RelationalDesign

Timestamp:

12/15/21 11:17:47 (3 years ago)

Author:

193230

Comment:

--

RelationalDesign

@@ -16 +16 @@
 ''Client''(**__client_number_id__**)
 
-''Shipping_employee''(**__shipping_employee_id__**)
+''Shipping_employee''(__**user_id**__*(user), **shipping_employee_id**)
 
 ''Role''(**__id_role__**, **role_name, role_desc**)
@@ -22 +22 @@
 ''Online_stores''(**__store_id__, name, web_address, phone_number, email, social_media**)
 
-''Shipping''(**__shipping_id__, location, date_from, date_to**)
+''Shipping''(**__shipping_id__, location, date_from, date_to**, **user_id***(shipping_employee), **shopping_id***(shopping_bag))
 
 ''Payment''(**__payment_id__, info**)
@@ -28 +28 @@
 ''Category''(**__category_id__, category_name**)
 
-''Store_employee''(**__store_employee_id__**, store_id*(online_stores))
+''Store_employee''(__**user_id**__*(user), **store_employee_id**, store_id*(online_stores))
 
-''Catalogue''(**__catalogue_id__, catalogue_from, catalogue_to, type**, store_id*(online_stores))
+''Catalogue''(**__catalogue_id__, catalogue_from, catalogue_to, type**, **__store_id__***(online_stores), **__product_in_store_id__***(product_in_store))
 
 ''Shopping_bag''(**__shopping_id__, order_date, shipping_date, modified, client_number_id***(client))
 
-''Product_in_store''(**__product_in_store_id__**, store_id*(online_stores), product_id*(product))
+''Product_in_store''(**__product_in_store_id__**, **store_id*(online_stores)**, **product_id***(product))
 
 ''Product''(**__product_id__, name, in_store, size, color**, category_id*(category))
@@ -42 +42 @@
 ''Works_as''(**__id_role*__**(role), **__store_employee_id*__**(store_employee), **works_from**, **works_to**)
 
-''Carries''(**__shipping_employee_id*__**(shipping_employee), **__shipping_id*__**(shipping))
-
 ''Exists''(**__catalogue_id*__**(catalogue),**__product_in_store_id*__**(product_in_store))