Changes between Version 4 and Version 5 of ConceptualModel

Timestamp:

12/06/25 19:30:35 (3 weeks ago)

Author:

231035

Comment:

--

ConceptualModel

@@ -55 +55 @@
 * {{{type}}} – text, required.
 * {{{breed}}} – text, required. Breed name; may be “mixed/unknown”.
-* {{{status}}} – text, required. Choosed from a predefined set{AVAILABLE,IN_TREATMENT,???}.
 * {{{name}}} – text, required. Pet name; max length ~50.
 * {{{sex}}} – text, required. {MALE, FEMALE, UNKNOWN}.
@@ -97 +96 @@
 * {{{status}}} – text, required. Allowed values: {SCHEDULED, COMPLETED, CANCELLED, NO_SHOW}.
 * {{{notes}}} – text, optional. Additional remarks from the owner or vet.
+* {{{animal_id}}} - numeric, required. Foreign key to Animal.animal_id; the animal this appointment is for.
 [[BR]]
 ----
@@ -153 +153 @@
 * {{{user_id}}} – numeric, required. Foreign key to User.user_id (recipient).
 * {{{is_read}}} – boolean, required. Defaults to FALSE; becomes TRUE when viewed.
+=== RELATIONS ===
+[[BR]]
+{{{receives (User – Notification)}}}
+[[BR]]
+Represents that a specific user receives specific notifications. It is needed so each notification is clearly assigned to one user. The relationship is modeled as 1–N: one user can receive many notifications; each notification belongs to exactly one user.
+[[BR]]
+'''[[span(style=color: #E30B5C, Keys: )]]'''
+* Identified by {{{notification_id}}} (PK of Notification).
+* On the relationship level, the pair ({{{user_id}}}, {{{notification_id}}}) is unique.
+[[BR]]
+'''[[span(style=color: #E30B5C, Attributes: )]]'''
+No extra attributes apart from the foreign keys already listed: {{{user_id}}} in Notification.
+----
+[[BR]]
+{{{made_by (User – Listing)}}}
+[[BR]]
+Links each listing to the user who created it. It is needed to track authorship, rights to modify the listing, and contact information. Modeled as 1–N because one user can create many listings, but each listing is created by exactly one user.
+[[BR]]
+'''[[span(style=color: #E30B5C, Keys: )]]'''
+* Identified by {{{listing_id}}}.
+* The pair ({{{user_id}}}, {{{listing_id}}}) is unique.
+[[BR]]
+'''[[span(style=color: #E30B5C, Attributes: )]]'''
+Relationship implemented via foreign key {{{user_id}}} inside Listing.
+[[BR]]
+----
+{{{made_for (Listing – Animal)}}}
+[[BR]]
+Shows that a listing is created for a specific animal. It is needed to attach each advertisement to the animal being sold or adopted. Modeled as 1–N from Animal to Listing: one animal may appear in multiple listings, but each listing refers to exactly one animal.
+[[BR]]
+'''[[span(style=color: #E30B5C, Keys: )]]'''
+* Identified by {{{listing_id}}}.
+* The combination ({{{listing_id}}}, {{{animal_id}}}) is unique.
+[[BR]]
+'''[[span(style=color: #E30B5C, Attributes: )]]'''
+Relationship implemented through the foreign key {{{animal_id}}} in Listing.
+[[BR]]
+----
+{{{owns (User – Animal)}}}
+[[BR]]
+Represents ownership of animals. It ensures that only the rightful owner can manage listings or initiate health-related actions. Modeled as 1–N: one user can own many animals, while each animal has exactly one current owner.
+[[BR]]
+'''[[span(style=color: #E30B5C, Keys: )]]'''
+* Identified by {{{animal_id}}}.
+* Unique pair ({{{owner_id}}}, {{{animal_id}}}).
+[[BR]]
+'''[[span(style=color: #E30B5C, Attributes: )]]'''
+Foreign key {{{owner_id}}} is stored in Animal.
+----
+[[BR]]
+{{{writes (User – Review)}}}
+[[BR]]
+Represents that a user writes a review. Critical for establishing authorship and preventing anonymous reviews. Modeled as 1–N: one user can write many reviews, while each review has exactly one author.
+[[BR]]
+'''[[span(style=color: #E30B5C, Keys: )]]'''
+* Identified by {{{review_id}}}.
+* Unique pair ({{{reviewer_id}}}, {{{review_id}}}).
+[[BR]]
+'''[[span(style=color: #E30B5C, Attributes: )]]'''
+Foreign key {{{reviewer_id}}} appears in Review.
+----
+[[BR]]
+{{{user_reviewed_in (User – Review)}}}
+[[BR]]
+Represents 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.
+[[BR]]
+'''[[span(style=color: #E30B5C, Keys: )]]'''
+* Identified by {{{review_id}}}.
+* The pair ({{{target_user_id}}}, {{{review_id}}}) is unique.
+[[BR]]
+'''[[span(style=color: #E30B5C, Attributes: )]]'''
+Foreign key {{{target_user_id}}} in Review (may be NULL when reviewing a clinic).
+----
+[[BR]]
+{{{clinic_reviewed_in (VetClinic – Review)}}}
+[[BR]]
+Represents 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.
+[[BR]]
+'''[[span(style=color: #E30B5C, Keys: )]]'''
+* Identified by {{{review_id}}}.
+* Unique pair ({{{target_clinic_id}}}, {{{review_id}}}).
+[[BR]]
+'''[[span(style=color: #E30B5C, Attributes: )]]'''
+Foreign key {{{target_clinic_id}}} stored in Review (NULL if review is about a user).
+----
+[[BR]]
+{{{belongs_to (Animal – HealthRecord)}}}
+
+[[BR]]
+Connects each medical record entry to the animal it describes. It is essential for maintaining a full medical history. Modeled as 1–N: one animal has many health records, while each health record refers to one animal.
+[[BR]]
+'''[[span(style=color: #E30B5C, Keys: )]]'''
+* Identified by {{{healthrecord_id}}}.
+* Unique pair ({{{animal_id}}}, {{{healthrecord_id}}}).
+[[BR]]
+'''[[span(style=color: #E30B5C, Attributes: )]]'''
+Foreign key {{{animal_id}}} is stored in HealthRecord.
+----
+[[BR]]
+{{{at_appointment (Appointment – HealthRecord)}}}
+
+[[BR]]
+Represents that a health record entry was created during a specific appointment. Needed to link treatments and checkups to their corresponding visits. Modeled as 1–N: one appointment may generate many records; each record belongs to at most one appointment.
+[[BR]]
+'''[[span(style=color: #E30B5C, Keys: )]]'''
+* Identified by {{{healthrecord_id}}}.
+* Unique pair ({{{appointment_id}}}, {{{healthrecord_id}}}).
+[[BR]]
+'''[[span(style=color: #E30B5C, Attributes: )]]'''
+Foreign key {{{appointment_id}}} included in HealthRecord (may be NULL if manually added).
+----
+[[BR]]
+{{{at_what_clinic (VetClinic – Appointment)}}}
+[[BR]]
+Represents at which veterinary clinic a given appointment takes place. This allows the system to know the location of each visit, show a clinic’s schedule, and coordinate resources. Modeled as 1–N: one clinic can host many appointments, while each appointment is held at exactly one clinic.
+[[BR]]
+'''[[span(style=color: #E30B5C, Keys: )]]'''
+* Identified by {{{appointment_id}}}.
+* Unique pair ({{{clinic_id}}}, {{{appointment_id}}}).
+[[BR]]
+'''[[span(style=color: #E30B5C, Attributes: )]]'''
+Foreign key {{{clinic_id}}} stored in {{{Appointment}}}.
+----
+[[BR]]
+{{{for_animal (Animal – Appointment)}}}
+[[BR]]
+Represents which animal a given appointment is scheduled for. It is needed so every appointment is clearly tied to a specific pet, enabling the system to show that pet’s upcoming visits and history. The relationship is modeled as 1–N from Animal to Appointment: one animal can have many appointments over time, while each appointment refers to exactly one animal.
+[[BR]]
+'''[[span(style=color: #E30B5C, Keys: )]]'''
+* Identified by {{{appointment_id}}} (PK of Appointment).
+* On the relationship level, the pair ({{{animal_id}}}, {{{appointment_id}}}) is unique.
+[[BR]]
+'''[[span(style=color: #E30B5C, Attributes: )]]'''
+No extra attributes apart from the foreign key {{{animal_id}}} stored in {{{Appointment}}}.
 == ERModel History