Changes between Version 1 and Version 2 of RelationalDesign

Timestamp:

08/27/26 23:41:35 (5 days ago)

Author:

181201

Comment:

--

RelationalDesign

@@ -23 +23 @@
 SERVICES (__'''service_id'''__, '''type''', description)
 
-BOOKINGS (__'''booking_id'''__, '''status''', '''date_from''', '''date_to''', '''address''', '''owner_id'''*, '''sitter_id'''*)
+BOOKINGS (__'''booking_id'''__, '''status''', '''date_from''', '''date_to''', '''address''', '''owner_id'''*, '''sitter_id'''*, '''service_id'''*)
 
 REVIEWS (__'''review_id'''__, '''rating''', comment, '''booking_id'''*)
@@ -35 +35 @@
 SITTER_SERVICES (__'''sitter_id'''__*, __'''service_id'''__*)
 
-BOOKING_SERVICES (__'''booking_id'''__*, __'''service_id'''__*)
-
 == DDL script for creating the database schema and objects:
 [attachment:schema_creation.sql]
@@ -45 +43 @@
 == Relational diagram
 [[Image(relational_schema.png)]]
+
+== Version history
+
+[https://develop.finki.ukim.mk/projects/petsitter/wiki/RelationalDesign_v01 v01]
+* Initial version
+
+[https://develop.finki.ukim.mk/projects/petsitter/wiki/RelationalDesign v02]
+* Current version; based on version [https://develop.finki.ukim.mk/projects/petsitter/wiki/ERModel v03] of the ER model
+* Added the '''service_id''' foreign key to the '''BOOKINGS''' table, declared as `NOT NULL` since every booking requires exactly one service
+* Removed the '''BOOKING_SERVICES''' table; not needed because '''requires''' relation is N:1
+* Updated `schema_creation.sql` and `data_load.sql` accordingly