Changes between Version 9 and Version 10 of ConceptualModel


Ignore:
Timestamp:
12/10/25 23:07:03 (3 weeks ago)
Author:
231035
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ConceptualModel

    v9 v10  
    66{{{User}}}
    77[[BR]]
    8 User represents every account in the system (admins and clients). It is the supertype in the user-hierarchy, holding all shared identity and login data. Modeling it as a separate entity avoids duplicating attributes in Admin/Client/Owner and makes authorization logic easier. It is needed to authenticate users, assign roles, and link their actions (listings, reviews, notifications, ownership of animals).
     8User represents every account in the system (admins and clients). It is the supertype in the user-hierarchy, holding all shared identity and login data. Modeling it as a separate entity avoids duplicating attributes in Admin/ Client/ Owner and makes authorization logic easier.
    99[[BR]]
    1010'''[[span(style=color: #E30B5C, Candidate keys: )]]'''
    … …  
    5454[[BR]]
    5555'''[[span(style=color: #E30B5C, Attributes: )]]'''
    56 * No additional attributes..
     56* No additional attributes.
    5757[[BR]]
    5858----
    … …  
    111111* {{{email}}} – text, optional. Must be valid email format; must be unique.
    112112* {{{phone}}} – text, optional. May require a specific phone-number format.
     113* {{{approved_by}}} - text, which admin approved to have that clinic as a part of the app
    113114[[BR]]
    114115----
    … …  
    260261----
    261262[[BR]]
     263{{{person_responsible (Owner - Appointment)}}}
     264[[BR]]
     265Represents that an Appoinment needs to have by whom it was created by(who is the owner of the animal in that appointment).
     266----
     267[[BR]]
    262268{{{writes (User – Review)}}}
    263269[[BR]]
    … …  
    272278----
    273279[[BR]]
    274 {{{user_reviewed_in (User – Review)}}}
     280{{{user_reviewed_in (User – UserReview)}}}
    275281[[BR]]
    276282Represents that a user is the target of a review (e.g., a seller rated by a buyer). Needed for calculating user reputation. Modeled as 1–N: one user can receive many reviews, while each review may refer to one target user.
    … …  
    284290----
    285291[[BR]]
    286 {{{clinic_reviewed_in (VetClinic – Review)}}}
     292{{{clinic_reviewed_in (VetClinic – ClinicReview)}}}
    287293[[BR]]
    288294Represents that a clinic is the target of a review. This supports public ratings of veterinary clinics. Modeled as 1–N: one clinic can receive many reviews; each review may refer to a single clinic.
    … …  
    344350'''[[span(style=color: #E30B5C, Attributes: )]]'''
    345351No extra attributes apart from the foreign key {{{animal_id}}} stored in {{{Appointment}}}.
     352----
     353[[BR]]
     354{{{based_on (ClinicReview – Appointment)}}}
     355[[BR]]
     356Represents that a user can't leave a review for a clinic if he hasn't had a appointment there.
     357
    346358== ERModel History
    347 VersionOne - Added specialization of the User entity(User became a supertype and two subtypes were added), added a relationship between Owner and Appointment, added a business rule (constraint) for clinic reviews
     359VersionOne - Added specialization of the User entity(User became a supertype and two subtypes were added),added specialization of the Review entity, added a relationship between Owner and Appointment, added a business rule (constraint) for clinic reviews