Changes between Version 1 and Version 2 of RelationalDesign

Timestamp:

02/05/26 14:13:03 (3 weeks ago)

Author:

202033

Comment:

--

RelationalDesign

@@ -16 +16 @@
 Package (__**package_id**__, **name**, **max_usage**)
 
-Review (__**review_id**__, rating, comment, created_at, user_id*(User), service_id*(Service))
+Review (__**review_id**__, rating, comment, created_at, payment_id*(Payment) UNIQUE)
 
-Appointment (__**appointment_id**__, **appointment_time**, **end_time**, notes, **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))