Changes between Version 5 and Version 6 of ConceptualModel

Timestamp:

05/05/26 02:29:46 (11 hours ago)

Author:

181201

Comment:

--

ConceptualModel

@@ -42 +42 @@
 
 ---- 
+
+{{{PetOwner}}}
+
+Subtype/specialization of {{{User}}} entity. Inherits from {{{User}}}. Is able to make bookings for their {{{Pet}}} and request a {{{PetSitter}}}.
+
+'''Candidate keys:'''
+* {{{user_id}}} - Inherits {{{user_id}}} from {{{User}}}
+
+'''Attributes:'''
+
+* Inherits all attributes from {{{User}}}
+
+----
+
+{{{PetSitter}}}
+
+Subtype/specialization of {{{User}}} entity. Inherits from {{{User}}}. Provides services to {{{PetOwner}}}. Is able to confirm or deny bookings.
+
+'''Candidate keys:'''
+* {{{user_id}}} - Inherits {{{user_id}}} from {{{User}}}
+
+'''Attributes:'''
+
+* Inherits all attributes from {{{User}}}
+
+---- 
+
+{{{Pet}}}
+
+The animal that will be taken care of. Track the identity, special needs, age of the pet in the booking. Linked to {{{PetType}}} to categorize animals more efficiently.
+
+'''Candidate keys:'''
+* {{{pet_id}}} - '''Primary key'''; Unique surrogate key.
+
+'''Attributes:'''
+
+* {{{pet_id}}} - Numeric (Required, Unique, Auto-generated integer).
+
+* {{{name}}} - Text (Required).
+
+* {{{photo}}} - Text/URL (Optional, URL format).
+
+* {{{age}}} - Numeric (Required, non-negative integer).
+
+* {{{password}}} - Text (Required, Hashed format, Min. 8 characters).
+
+* {{{special_needs}}} - Text (Optional).
+
+* {{{description}}} - Text (Optional).
+
+----
+
+{{{PetType}}}
+
+Entity used to categorize pets (for example Cat, Dog, Rabbit, Bird). Used for storing attributes that would repeat a lot of times in one single {{{Pet}}} entity.
+
+'''Candidate keys:'''
+* {{{pet_id}}} - '''Primary key'''; Unique surrogate key.
+* {{{species}}} - Unique but not as efficient as a numeric id key.
+
+'''Attributes:'''
+
+* {{{pettype_id}}} - Numeric (Required, Unique, Auto-generated integer).
+
+* {{{species}}} - Text (Required, Unique).
+
+* {{{average_lifespan}}} - Numeric (Optional).
+
+* {{{needs_outdoor_walk}}} - Boolean (Required, 0 or 1).
+
+
+---- 
+
+{{{Booking}}}
+
+The entity that connects {{{PetOwner}}}, {{{PetSitter}}}, {{{Pet}}} and the services requested for the {{{Pet}}}
+
+'''Candidate keys:'''
+* {{{booking_id}}} - '''Primary key'''; Unique surrogate key.
+
+'''Attributes:'''
+
+* {{{booking_id}}} - Numeric (Required, Unique, Auto-generated integer).
+
+* {{{status}}} - Text (Required, for example 'Pending', 'Confirmed', 'Completed', 'Rejected').
+
+* {{{date_from}}} - Date (Required).
+
+* {{{date_to}}} - Date (Required).
+
+* {{{address}}} - Text (Required, location of the service).