Changes between Version 3 and Version 4 of ConceptualModel

Timestamp:

05/05/26 01:51:14 (12 hours ago)

Author:

181201

Comment:

--

ConceptualModel

@@ -2 +2 @@
 
 == Diagram
-[[Image(ERModel_v01.jpg)]]
+
+== Entities
+
+{{{User}}}
+
+This is the core entity that represents every person registered on [https://develop.finki.ukim.mk/projects/petsitter/#PetSitter PetSitter]. It acts as a supertype for {{{Admin}}}/{{{PetOwner}}}/{{{PetSitter}}} so we can store the common attributes only in {{{User}}}.
+
+'''Candidate keys:'''
+* {{{user_id}}} - '''Primary key'''; numeric id, most efficient for indexing
+* {{{username}}} - unique but not as efficient as {{{user_id}}}
+* {{{email}}} - unique but not as efficient as {{{user_id}}}
+
+'''Attributes:'''
+
+* {{{user_id}}} - Numeric (Required, Unique, Auto-generated integer).
+
+* {{{username}}} - Text (Required, Unique, 4-20 characters).
+
+* {{{first_name}}} - Text (Required).
+
+* {{{last_name}}} - Text (Required).
+
+* {{{password}}} - Text (Required, Hashed format, Min. 8 characters).
+
+* {{{email}}} - Text (Required, Unique, Standard email format).
+
+----