Changes between Version 9 and Version 10 of RelationalDesign

Timestamp:

02/26/26 10:43:26 (3 weeks ago)

Author:

202033

Comment:

--

RelationalDesign

@@ -1 @@
-== Релациска шема со мапирачка трансформација 
+== Релациска шема со мапирачка трансформација
 
 * Примарни клучеви означени со underline
 * Надворешни клучеви означени со * и табела кон која покажува
 * Not null атрибути означени со bold
-User (__**user_id**__, **full_name**, **email**, **phone**, **created_at**)
 
-Role (__**role_id**__, **name**)
+User (__**user_id**__, **full_name**, **email UNIQUE**, **phone**, **created_at**, **password_hash**)
 
-Category (__**category_id**__, **name**)
+Role (__**role_id**__, **name UNIQUE**)
 
-Status (__**status_id**__, **name**)
+Category (__**category_id**__, **name UNIQUE**)
+
+Status (__**status_id**__, **name UNIQUE**)
 
 Service (__**service_id**__, **name**, **price**, **duration_minutes**, **category_id*(Category)**)
 
-Package (__**package_id**__, **name**, **max_usage**)
+Package (__**package_id**__, **name**, **max_usage**, **total_price**)
 
-Review (__**review_id**__, rating, comment, created_at, **payment_id*(Payment) UNIQUE**)
+Review (__**review_id**__, **rating**, comment, **created_at**, **payment_id*(Payment) UNIQUE**)
 
-Appointment (__**appointment_id**__, **appointment_time**, **end_time**, notes, **type enum('pre-booked','walk-in')**, **total_price**, **user_id*(User)**, **status_id*(Status)**)
+Appointment (__**appointment_id**__, **appointment_time**, **end_time**, notes, **type enum('pre-booked','walk-in')**, **total_price**, **user_id*(User)**, **status_id*(Status)**, **points_awarded**)
 
-LoyaltyCard (__**card_id**__, **points**, user_id*(User))
+LoyaltyCard (__**card_id**__, **points**, **user_id*(User) UNIQUE**)
 
-Payment (__**payment_id**__, **amount**, **method**, **timestamp**, **status**, **appointment_id*(Appointment)**, points_used)
+Payment (__**payment_id**__, **amount**, **method**, **timestamp**, **status**, appointment_id*(Appointment), **points_used**, package_purchase_id*(UserPackagePurchase))
 
 UserRole (__**user_id*(User)**__, __**role_id*(Role)**__)
 
-PackageService (__**package_id*(Package)**__, __**service_id*(Service)**__, discounted_price)
+PackageService (__**package_id*(Package)**__, __**service_id*(Service)**__, **discounted_price**)
 
 AppointmentService (__**appointment_id*(Appointment)**__, __**service_id*(Service)**__)
 
-Availability (__**availability_id__**, __**date__**, __**start_time__**, __**end_time__**, __**is_closed__**)
+Availability (__**availability_id**__, **date**, **start_time**, **end_time**, **is_closed**)
 
-UserPackagePurchase (__**purchase_id__**, *user_id(User), __***package_id(Package)__**,__**purchased_at__**, __**total_uses__**, __**remaining_uses__**, __**status__**, expires_at)
+UserPackagePurchase (__**purchase_id**__, **user_id*(User)**, **package_id*(Package)**, **purchased_at**, **total_uses**, **remaining_uses**, **status**, expires_at)
 
 AppointmentPackageUsage (__**appointment_id*(Appointment)**__, **purchase_id*(UserPackagePurchase)**, **service_id*(Service)**, **used_units**, finalized_at)