Changes between Version 3 and Version 4 of RelationalDesign

Timestamp:

11/14/24 12:27:40 (7 days ago)

Author:

185022

Comment:

--

RelationalDesign

@@ -5 +5 @@
 == Табели
 === Ентитети
-* USER (__'''user_id'''__, user_name, user_surname, user_email, user_mobile_no, city_id*)
+* USERS (__'''user_id'''__, user_name, user_surname, user_email, user_mobile, city_id*)
  * * референцира до CITY (city_id)
-* VEHICLE (__'''vehicle_id'''__, vehicle_carry_weight, driver_id*, warehouse_id!**)
+* VEHICLE (__'''vehicle_id'''__, vehicle_carry_weight, vehicle_service_interval, vehicle_kilometers, vehicle_last_service, driver_id*, warehouse_id!**)
  * * референцира до DRIVER (user_id)
  * !** референцира до WAREHOUSE (warehouse_id)
@@ -16 +16 @@
 * ARTICLE (__'''article_id'''__, article_price, article_image, article_name, article_weight, category_id*)
  * * референцира до CATEGORY (category_id)
-* ORDERS (__'''order_id'''__, order_date_created, order_status, delivery_id*, pro_forma_id!**)
+* ORDERS (__'''order_id'''__, order_date, order_status, order_sum, order_fulfillment_date, delivery_id*, pro_forma_id!**, customer_id!***)
  * * референцира до DELIVERY (delivery_id)
  * !** референцира до PRO_FORMA (pro_forma_id)
+ * !*** референцира до CUSTOMER(user_id)
 * CITY (__'''city_id'''__, city_name)
 * MANAGER (__'''user_id*''''__, warehouse_id!**)
  * * референцира до USER (user_id)
  * !** референцира до WAREHOUSE (warehouse_id)
-* CUSTOMER (__'''user_id*''''__, customer_EDB, customer_company_name, customer_address, customer_working_hours, customer_representative_image)
+* CUSTOMER (__'''user_id*''''__, customer_EDB, customer_company_name, customer_address, customer_open_time, customer_close_time, customer_representative_image)
  * * референцира до USER (user_id)
 * DRIVER (__'''user_id*''''__, vehicle_id!**)
@@ -32 +33 @@
  * !** референцира до CITY (city_id)
 * CATEGORY (__'''category_id'''__, category_name)
-* ARTICLE_UNIT (__'''article_id*''''__, order_id!**)
+* ARTICLE_UNIT (__**unit_id**__, unit_expiration_date, unit_serial_number, unit_batch_number, unit_manufacture_date, unit_cost_price, article_id*, order_id!**)
  * * референцира до ARTICLE (article_id)
  * !** референцира до ORDERS (order_id)
 === Релации
-* WAREHOUSE_LOCATION (__'''warehouse_id*, city_id!**''''__)
- * * референцира до WAREHOUSE (warehouse_id)
- * !** референцира до CITY (city_id)
-* IN_STOCK (__'''city_id*, warehouse_id!**''''__)
+* IN_STOCK (__'''city_id*, warehouse_id!**'''__)
  * * референцира до CITY (city_id)
  * !** референцира до WAREHOUSE (warehouse_id)