Changes between Version 11 and Version 12 of DDL

Timestamp:

09/23/25 01:34:37 (2 days ago)

Author:

215010

Comment:

--

DDL

@@ -14 +14 @@
 manager (__'''user_id__'''*)[[br]]
 * user_id референцира од hotel_user(__'''user_id'''__)[[br]]
-staff (__'''user_id__'''*)[[br]]
+staff (__'''user_id__'''*, '''building_id'''*)[[br]]
 * user_id референцира од hotel_user(__'''user_id'''__)[[br]]
+* bulding_id референцира до hotel_building(__'''building_id'''__) [[br]]
 
-reservation (__'''reservation_id__''', '''start_date''', end_date, '''status''', '''reserv_date''',  customer_id*, manager_id*, building_id*, room_number*)[[br]]
+reservation (__'''reservation_id__''', '''start_date''', '''end_date''', '''status''', '''reserv_date''',  customer_id*, manager_id*, building_id*, room_number*)[[br]]
 * customer_id референцира од hotel_user(__'''user_id'''__)[[br]]
 * manager_id референцира од hotel_user(__'''user_id'''__)[[br]]
@@ -30 +31 @@
 * building_id референцира од building(building_id)[[br]]
 
-hotel_building (__'''building_id__''', '''address''', '''city''', '''floor''', '''num_floors''')[[br]]
+hotel_building (__'''building_id__''', '''address''', '''city''', '''floor''', '''num_floors''', manager_id*)[[br]]
+* manager_id референцира од hotel_user(__'''user_id'''__)[[br]]
 
 service (__'''service_id'''__ , '''service_type''', '''service_date''', '''service_status''', room_number*, building_id*, staff_id*)[[br]]