= ERModel v01

== Diagram

== 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).

----