Changes between Version 6 and Version 7 of Logical and Physical Design - Database creation (with SQL Scripts)

Timestamp:

11/29/22 18:10:22 (2 years ago)

Author:

201101

Comment:

--

Logical and Physical Design - Database creation (with SQL Scripts)

@@ -18 +18 @@
         * '''*'''Референцира villa_id од Villa
 5. ''Service'' ('''__service_id__''', '''service_type''', '''price''', '''user_id*''', '''room_id*''')
-        * '''*'''Референцира user_id од Server
+        * '''*'''Референцира user_id од Waiter
         * '''*'''Референцира room_id од Rooms
 6. ''Payment'' ('''__payment_id__''', '''total_payment''', '''pay_date''', '''rec_id''', '''customer_id''', '''user_id*''')
@@ -29 +29 @@
         * '''*'''Референцира user_id од User
 12. ''User'' ('''__user_id__''', '''EMBG''', '''address''', '''email''', '''phone_number''')
-13. ''Server'' ('''__user_id*__''', '''shift''', '''salary''')
+13. ''Waiter'' ('''__user_id*__''', '''shift''', '''salary''')
         * '''*'''Референцира user_id од User
 14. ''Receptionist'' ('''__user_id*__''', '''shift''', '''salary''')
@@ -48 +48 @@
         * '''*'''Референцира reservation_id од Reservation
         * '''*'''Референцира event_id од Event
-21. ''reservation_for_activity'' ('''__reservation_id*, activity*__''')
+21. ''reservation_for_activity'' ('''__reservation_id*, activity*_id''')
         * '''*'''Референцира reservation_id од Reservation
         * '''*'''Референцира activity_id од Activities