Changes between Version 12 and Version 13 of RelationalDesign

Timestamp:

02/13/25 11:56:53 (2 months ago)

Author:

185022

Comment:

--

RelationalDesign

@@ -5 +5 @@
 == Табели
 === Ентитети
-* ORDER_STATUS (__''order_status_id''__, order_status_name, order_status_description)
-* DELIVERY_STATUS (__''delivery_status_id''__, delivery_status_name, delivery_status_description)
-* PRO_FORMA_STATUS (__''pro_forma_status_id''__, pro_forma_status_name, pro_forma_status_description)
-* WEEKDAY (__''day_id''__, day_name)
+* ORDER_STATUS (__'''order_status_id'''__, order_status_name, order_status_description)
+* DELIVERY_STATUS (__'''delivery_status_id''__, delivery_status_name, delivery_status_description)
+* PRO_FORMA_STATUS (__'''pro_forma_status_id''__, pro_forma_status_name, pro_forma_status_description)
+* WEEKDAY (__'''day_id'''__, day_name)
 * CATEGORY (__'''category_id'''__, category_name)
-* REGION (__''region_id''__, region_name)
+* REGION (__'''region_id'''__, region_name)
 * CITY (__'''city_id'''__, city_name, region_id*)
  * * референцира до REGION (region_id)
@@ -19 +19 @@
 * USERS (__'''user_id'''__, user_name, user_surname, user_pass, user_salt, user_email, user_active, user_mobile, user_image, clazz_ city_id*)
  * * референцира до CITY (city_id)
-* CUSTOMER (__'''user_id*''''__, cust_EDB, cust_company_name, cust_adr, cust_representative_image)
+* CUSTOMER (__'''user_id*'''__, cust_EDB, cust_company_name, cust_adr, cust_representative_image)
  * * референцира до USER (user_id)
-* MANAGER (__'''user_id*''''__, wh_id!**)
+* MANAGER (__'''user_id*'''__, wh_id!**)
  * * референцира до USER (user_id)
  * !** референцира до WAREHOUSE (wh_id)
  * * референцира до USER (user_id)
-* DRIVER (__'''user_id*''''__, veh_id!**)
+* DRIVER (__'''user_id*'''__, veh_id!**)
  * * референцира до USER (user_id)
  * !** референцира до VEHICLE (veh_id)
@@ -44 +44 @@
  * !*** референцира до PRO_FORMA(pf_id)
  * !**!** референцира до ORDER_STATUS(o_status_id)
-* ARTICLE_UNIT (__**unit_id**__, unit_expiration_date, unit_serial_number, unit_batch_number, unit_manufacture_date, unit_cost_price, wh_id * ord_id!**)
+* ARTICLE_UNIT (__'''unit_id'''__, unit_expiration_date, unit_serial_number, unit_batch_number, unit_manufacture_date, unit_cost_price, wh_id * ord_id!**)
  * * референцира до WAREHOUSE (wh_id)
  * !** референцира до ORDERS (ord_id)
-* UNIT_PRICE (__unit_id*,price_id!**__)
+* UNIT_PRICE (__'''unit_id*,price_id!**'''__)
  * * референцира до ARTICLE_UNIT (unit_id)
  * !** референцира до PRICE (price_id)
-* CUSTOMER_WEEKDAY (__cust_day_id__, cust_id*, day_id!**, start_time, end_time)
+* CUSTOMER_WEEKDAY (__'''cust_day_id'''__, cust_id*, day_id!**, start_time, end_time)
  * * референцира до CUSTOMER (user_id)
  * !** референцира до WEEKDAY (day_id)
-* TOKEN (__t_id__, t_value, t_date, t_type, t_expiry, t_validated_at, t_user*)
+* TOKEN (__'''t_id'''__, t_value, t_date, t_type, t_expiry, t_validated_at, t_user*)
  * * референцира до USERS (user_id)