Changes between Version 2 and Version 3 of RelationalDesign

Timestamp:

02/05/26 14:21:35 (3 weeks ago)

Author:

202033

Comment:

--

RelationalDesign

@@ -12 +12 @@
 Status (__**status_id**__, **name**)
 
-Service (__**service_id**__, **name**, **price**, **duration_minutes**, category_id*(Category))
+Service (__**service_id**__, **name**, **price**, **duration_minutes**, **category_id*(Category)**)
 
 Package (__**package_id**__, **name**, **max_usage**)
 
-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)**)
 
 LoyaltyCard (__**card_id**__, **points**, user_id*(User))
 
-Payment (__**payment_id**__, **amount**, **method**, **timestamp**, **status**, appointment_id*(Appointment))
+Payment (__**payment_id**__, **amount**, **method**, **timestamp**, **status**, **appointment_id*(Appointment)**)
 
 UserRole (__**user_id*(User)**__, __**role_id*(Role)**__)