Changes between Version 8 and Version 9 of Normalization

Timestamp:

09/16/25 01:27:24 (3 months ago)

Author:

185022

Comment:

--

Normalization

@@ -117 +117 @@
 === Покривачи на примарните клучеви
 
+'''Order Status'''
+
+`o_status_id+={o_status_id, o_status_name, o_status_desc}`
+
+'''Delivery Status'''
+
+`d_status_id+={d_status_id, d_status_name, d_status_desc}`
+
+
+'''Pro Forma Status'''
+
+`pf_status_id+={pf_status_id, pf_status_name, pf_status_desc}`
+
+'''City'''
+
+`city_id+={city_id, city_name, region_id, region_name}`
+
+'''Region'''
+
+`region_id+={region_id, region_name}`
+
+'''Weekday'''
+
+`day_id+={day_id, day_name}`
+
+'''Warehouse'''
+
+`wh_id+={wh_id, wh_adr}`
+
+'''Category'''
+
+`ctg_id+={ctg_id, ctg_name}`
+
+'''Manufacturer'''
+
+`man_id+ = {man_id, man_mobile, man_name, man_adr, man_email}`
+
+'''User'''
+
+`user_id+ = {user_pass, user_active, user_name, user_email, user_surname, user_mobile, user_role, user_salt, clazz_, user_image, city_id, city_name, region_id, region_name}`
+
+* Ако тип на корисник е 'customer':
+
+Атрибутите на User и дополнително следните атрибути:
+
+`user_id+ = {cust_EDB, cust_company_name, cust_adr, cust_representative_img}`
+
+* Ако тип на корисник е 'manager':
+
+Атрибутите на User и дополнително следните атрибути:
+
+`user_id+ = {wh_id, wh_adr}`
+
+* Ако тип на корисник е 'driver':
+
+Атрибутите на User и дополнително следните атрибути:
+
+`user_id+ = {veh_id, veh_carry_weight, veh_service_interval, veh_kilometers, veh_last_service, veh_last_service_km, veh_plate, veh_vin, veh_reg_date, wh_id, wh_adr}`
+
 '''Vehicle'''
 
-`veh_id+ = {veh_id, veh_carry_weight, veh_service_interval, veh_kilometers, veh_last_service, veh_last_service_km, veh_plate, veh_vin, veh_reg_date, wh_id, wh_adr, city_id, city_name, region_id, region_name}`
-
-'''User'''
-
-`user_id+ = {user_id, user_name, user_surname, user_pass, user_salt, user_email, user_mobile, user_active, user_image, clazz_, user_role, city_id, city_name, region_id, region_name}`
-
-* Ако тип на корисник е 'customer':
-
-`user_id+ += {cust_EDB, cust_company_name, cust_adr, cust_representative_img}`
-
-* Ако тип на корисник е 'manager':
-
-`user_id+ += {wh_id, wh_adr}`
-
-* Ако тип на корисник е 'driver':
-
-`user_id+ += {veh_id, veh_carry_weight, veh_service_interval, veh_kilometers, veh_last_service, veh_last_service_km, veh_plate, veh_vin, veh_reg_date, wh_id, wh_adr}`
-
-'''Manufacturer'''
-
-`man_id+ = {man_id, man_name, man_adr, man_mobile, man_email}`
+`veh_id+ = {veh_id, veh_reg_date, veh_plate, veh_kilometers, veh_last_service_km, veh_carry_weight, veh_vin, veh_service_interval, veh_last_service, wh_id, wh_adr, city_id, city_name, region_id, region_name}`
 
 '''Article'''
 
-`art_id+ = {art_id, art_name, art_image, art_weight, ctg_id, ctg_name, man_id, man_name, man_adr, man_mobile, man_email}`
+`art_id+ = {art_id, art_image, art_name, art_weight, ctg_id, ctg_name, man_id, man_name, man_email, man_adr, man_mobile}`
 
 '''Price'''
 
-`price_id+ = {price_id, price, price_eff_date, art_id, art_name, art_image, art_weight, ctg_id, ctg_name, man_id, man_name, man_adr, man_mobile, man_email}`
+`price_id+ = {price_id, price, price_eff_date, art_id, art_image, art_name, art_weight, ctg_id, ctg_name, man_id, man_name, man_email, man_adr, man_mobile}`
 
 '''Pro-forma'''
 
-`pf_id+ = {pf_id, pf_deadline, pf_date_created, pf_status_id, pf_status_name, pf_status_desc}`
+`pf_id+ = {pf_id, pf_date_created, pf_deadline, pf_status_id, pf_status_name, pf_status_desc}`
 
 '''Delivery'''
 
-`del_id+ = {del_id, del_date_created, del_date, del_start_km, del_end_km, del_start_time, del_end_time, d_status_id, d_status_name, d_status_desc, veh_id, veh_carry_weight, veh_service_interval, veh_kilometers, veh_last_service, veh_last_service_km, veh_plate, veh_vin, veh_reg_date, wh_id, wh_adr, city_id, city_name, region_id, region_name}`
+`del_id+ = {del_id, del_date_created, del_start_time, del_end_km, del_start_km, del_end_time, del_date, d_status_id, d_status_name, d_status_desc, veh_id, veh_reg_date, veh_plate, veh_kilometers, veh_carry_weight, veh_vin, veh_service_interval, veh_last_service, veh_last_service_km, wh_id, wh_adr, city_id, city_name, region_id, region_name}`
 
 '''Order'''
 
-`ord_id+ = {ord_id, ord_date, ord_sum, ord_fulfillment_date, ord_comment, o_status_id, o_status_name, o_status_desc, cust_id, del_id, pf_id, user_name, user_surname, user_pass, user_salt, user_email, user_mobile, user_active, user_image, clazz_, user_role, city_id, cust_EDB, cust_company_name, cust_adr, cust_representative_img, city_name, region_id, region_name, del_date_created, del_date, del_start_km, del_end_km, del_start_time, del_end_time, d_status_id, veh_id, d_status_name, d_status_desc, veh_carry_weight, veh_service_interval, veh_kilometers, veh_last_service, veh_last_service_km, veh_plate, veh_vin, veh_reg_date, wh_id, wh_adr,pf_deadline, pf_date_created, pf_status_id, pf_status_name, pf_status_desc}`
+`ord_id+ = {ord_id, ord_sum, ord_comment, ord_date, ord_fulfillment_date, o_status_id, o_status_desc, o_status_name, user_id, user_name, user_surname, user_mobile, user_role, user_email, user_active, user_pass, user_salt, clazz_, user_image, cust_EDB, cust_company_name, cust_adr, cust_representative_img, city_id, city_name, region_id, region_name, del_id, del_date_created, del_start_time, del_end_km, del_start_km, del_end_time, del_date, d_status_id, d_status_desc, d_status_name, veh_id, veh_reg_date, veh_plate, veh_kilometers, veh_carry_weight, veh_vin, veh_service_interval, veh_last_service, veh_last_service_km}`
 
 '''Article Unit'''
 
-`unit_id+ = {unit_id, unit_expiration_date, unit_serial_number, unit_batch_number, unit_manufacture_date, unit_cost_price, wh_id, wh_adr, city_id, city_name, region_id, region_name, ord_id}`
-
-* Ако ord_id не е null, исто така ги вклучува и:
-`unit_id+ += {ord_date, ord_sum, ord_fulfillment_date, ord_comment, o_status_id, o_status_name, o_status_desc, cust_id, del_id, pf_id,` 
-
-''и сите атрибути одредени од ord_id''
-
-`}`
+`unit_id+ = {unit_id, unit_serial_no, unit_batch_no, unit_manufacture_date, unit_expiration_date, unit_cost_price, wh_id, wh_adr, price_id, price, price_eff_date, art_id, art_image, art_name, art_weight, ctg_id, ctg_name, man_id, man_name, man_email, man_mobile, man_adr, ord_id, ord_sum, ord_comment, ord_date, ord_fulfillment_date, o_status_id, o_status_desc, o_status_name, user_id, user_name, user_surname, user_mobile, user_role, user_email, user_active, user_pass, user_salt, clazz_, user_image, cust_EDB, cust_company_name, cust_adr, cust_representative_img, city_id, city_name, region_id, region_name, del_id, del_date_created, del_start_time, del_end_km, del_start_km, del_end_time, del_date, d_status_id, d_status_desc, d_status_name, veh_id, veh_reg_date, veh_plate, veh_kilometers, veh_carry_weight, veh_vin, veh_service_interval, veh_last_service, veh_last_service_km}`
+
+'''Token'''
+
+`t_id+={t_id, t_date, t_value, t_type, t_validated_at, t_expiry, user_pass, user_active, user_name, user_email, user_surname, user_mobile, user_role, user_salt, clazz_, user_image, city_id, city_name, region_id, region_name}`
+
+'''Image Store'''
+
+`img_id+ = {img_id, img_path, img_ent_type, img_ent_id}`
 
 '''Композитен клуч - Article Unit и Price'''
 
-`(unit_id, price_id)+ = {unit_id, price_id,` 
-
-''Сите атрибути определни од unit_id''
-
-`unit_expiration_date, unit_serial_number, unit_batch_number, unit_manufacture_date, unit_cost_price, wh_id, ord_id,` 
-
-''Сите атрибути определни од price_id''
-
-`price, price_eff_date, art_id,`
-
-''Сите транзитивни атрибути''
-
-`wh_adr, city_id, city_name, region_id, region_name, art_name, art_image, art_weight, ctg_id, man_id, ctg_name, man_name, man_adr, man_mobile, man_email}`
-
-'''Weekday'''
-
-`cust_day_id+ = {cust_day_id, cust_id, day_id, start_time, end_time,`
-
-''Од day_id:''
-
-`day_name,`
-
-''Од cust_id:''
-
-`user_name, user_surname, user_pass, user_salt, user_email, user_mobile, user_active, user_image, clazz_, user_role, city_id, cust_EDB, cust_company_name, cust_adr, cust_representative_img,`
-
-''Од city_id:''
-
-`city_name, region_id, region_name}`
-
-'''Token'''
-
-`t_id+ = {t_id, t_value, t_date, t_type, t_expiry, t_validated_at, t_user,`
-
-''Од t_user (кое е user_id):''
-
-`user_name, user_surname, user_pass, user_salt, user_email, user_mobile, user_active, user_image, clazz_, user_role, city_id,`
-
-''Од city_id:''
-
-`city_name, region_id, region_name}`
-
-'''Image Store'''
-
-`img_id+ = {img_id, img_path, img_ent_type, img_ent_id}`
+`{unit_id, price_id}+={unit_id, price_id, unit_expiration_date, unit_serial_number, unit_batch_number, unit_manufacture_date, unit_cost_price, wh_id, wh_adr, city_id, city_name, region_id, region_name, ord_id, price, price_eff_date, art_id, art_name, art_image, art_weight, ctg_id, ctg_name, man_id, man_name, man_adr, man_mobile, man_email}`
+
+'''Customer Weekday'''
+
+`cust_day_id+={cust_day_id, cust_id, user_name, user_surname, user_email, user_mobile, user_active, user_image, clazz_, user_role, city_id, city_name, region_id, region_name, cust_EDB, cust_company_name, cust_adr, cust_representative_img, cust_loc_latitude, cust_loc_longitude, day_id, day_name, start_time, end_time}`
 
 === Анализа според покривачи