Changes between Version 2 and Version 3 of DDL

Timestamp:

01/29/25 04:30:55 (3 weeks ago)

Author:

215010

Comment:

--

DDL

@@ -8 +8 @@
 
 === Табели === 
-hotel_user (__'''u_id'''__, '''phone_number''', '''first_name''', '''last_name''', '''email''', '''pass''')[[br]]
+hotel_user (__'''user_id'''__, '''first_name''', '''last_name''', '''phone''', '''email''', '''password''')[[br]]
 
+customer ( __'''user_id'''__* ) [[br]]
+* user_id референцира од hotel_user(__'''user_id'''__)[[br]]
+manager (__'''user_id__'''*)[[br]]
+* user_id референцира од hotel_user(__'''user_id'''__)[[br]]
+staff (__'''user_id__'''*)[[br]]
+* user_id референцира од hotel_user(__'''user_id'''__)[[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]]
+* building_id референцира од hotel_building(__'''building_id'''__)[[br]]
+* room_number референцира од room(__'''room_number'''__)[[br]]
+
+payment (__'''p_id__''', '''p_method''', '''amount''', '''p_date''', customer_id*, reservation_id*,)[[br]]
+* customer_id референцира од customer(__'''user_id'''__)[[br]]
+* reservation_id референцира од reservation(__'''reservation_id'''__)[[br]]
+
+room (__'''room_number__''', __'''building_id__'''*, '''room_type''', '''number_of_beds''', '''price_per_night''', '''available''')[[br]]
+* building_id референцира од building(building_id)[[br]]
+
+hotel_building (__'''building_id__''', '''address''', '''city''', '''floor''', '''num_floors''')[[br]]
+
+service ('''service_type''', '''service_date''', '''service_status''', __'''room_number__'''*, __'''building_id__'''*, __'''staff_id__''')[[br]]
+* room_number, building_id референцираат од Room(room_number, building_id)[[br]]
+* staff_id референцира од staff(user_id)[[br]]
 
 == DDL скрипта за бришење и креирање на табелите