Changes between Version 6 and Version 7 of RelationalDesign

Timestamp:

02/13/26 11:28:17 (11 days ago)

Author:

202033

Comment:

--

RelationalDesign

@@ -22 +22 @@
 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)**, points_used)
 
 UserRole (__**user_id*(User)**__, __**role_id*(Role)**__)
@@ -30 +30 @@
 AppointmentService (__**appointment_id*(Appointment)**__, __**service_id*(Service)**__)
 
+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)
+
+AppointmentPackageUsage (__**appointment_id*(Appointment)**__, **purchase_id*(UserPackagePurchase)**, **service_id*(Service)**, **used_units**, finalized_at)