Changes between Initial Version and Version 1 of RelationalDesign

Timestamp:

07/08/26 02:07:30 (9 hours ago)

Author:

181201

Comment:

--

RelationalDesign

@@ +1 @@
+= Logical and Physical Design, DB Creation (DDL)
+
+== Notation
+
+ * Primary Key - '''bold''' and __underline__
+ * Required/`NOT NULL` - '''bold'''
+ * Foreign Key - Asterisk ( * )
+ * Optional (nullable) attributes - regular characters
+
+== Tables
+USERS (__'''user_id'''__, '''username''', '''first_name''', '''last_name''', '''password''', '''email''')
+
+ADMINS (__'''user_id'''__*)
+
+PET_OWNERS (__'''user_id'''__*)
+
+PET_SITTERS (__'''user_id'''__*)
+
+PET_TYPES (__'''pettype_id'''__, '''species''', average_lifespan, '''needs_outdoor_walk''')
+
+PETS (__'''pet_id'''__, '''name''', photo, '''age''', special_needs, description, '''owner_id'''*, '''pettype_id'''*)
+
+SERVICES (__'''service_id'''__, '''type''', description)
+
+BOOKINGS (__'''booking_id'''__, '''status''', '''date_from''', '''date_to''', '''address''', '''owner_id'''*, '''sitter_id'''*)
+
+REVIEWS (__'''review_id'''__, '''rating''', comment, '''booking_id'''*)
+
+PAYMENTS (__'''payment_id'''__, '''amount''', '''payment_type''', '''booking_id'''*)
+
+ADMIN_MANAGEMENT (__'''admin_id'''__*, __'''user_id'''__*)
+
+BOOKING_PETS (__'''booking_id'''__*, __'''pet_id'''__*)
+
+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]
+
+== DML script for filling tables with data:
+[attachment:data_load.sql]
+
+== Relational diagram
+[[Image(relational_schema.png)]]