Changes between Version 5 and Version 6 of RelationalSchema

Timestamp:

02/14/25 19:28:24 (8 days ago)

Author:

221128

Comment:

--

RelationalSchema

@@ -9 +9 @@
 2. Employee(**__user_id__***, net_salary, gross_salary)  
 3. Customer(**__user_id__***)  
-4. Manager(**__user_id__***)  
+4. Manager(**__employee_id__***)  
 5. FrontStaff(**__employee_id__***, tip_percent, staff_role_id*)  
 6. BackStaff(**__employee_id__***, staff_role_id*)  
@@ -17 +17 @@
 
 10. Reservation(**__id__**, stay_length, datetime, creation_timestamp, number_of_people, user_id*)  
-11. Reservation_managed_FrontStaff(**__reservation_id__***, **__employee_id__***, **__table_number__***)  
+11. Reservation_managed_FrontStaff(**__reservation_id__***, **__frontstaff_id__***, **__table_number__***)  
 
 12. Category(**__id__**, name, is_available)