Changes between Version 14 and Version 15 of LogicalAndPhysicalDesign

Timestamp:

05/05/26 09:15:53 (4 hours ago)

Author:

231035

Comment:

--

LogicalAndPhysicalDesign

@@ -10 +10 @@
 * Client(user_id [PK, FK→Users(user_id)])
 * Owner(user_id [PK, FK→Client(user_id)]) (Owner is a subtype of Client, as in the diagram)
+* Vet_clinic(user_id [PK, FK→vet_clinic(user_id)])
 
 {{{NOTIFICATIONS}}}
 * Notification(notification_id [PK], user_id [FK→Users(user_id)], type, message, is_read, created_at)
+
+{{{VET CLINIC APPLICATIONS}}}
+* vet_clinic_applications(application_id[PK],name,email,phone,city,address,submitted_at,status,reviewd_at,reviewd_by[FK→Admin(user_id)],denial_reason)
  
 {{{VET CLINICS}}}
-* !VetClinic(clinic_id [PK], name, email, phone, city, address, approved_by [FK→Admin(user_id)])
+* !VetClinic(clinic_id [PK], name, email, phone, city, address, user_if(FK→vet_clinic(user_id)),application_id[FK→vet_clinic_applications(application_id)])
 
 {{{ANIMALS}}}
@@ -22 +26 @@
 {{{LISTINGS}}}
 * Listing(listing_id [PK], owner_id [FK→Owner(user_id)], animal_id [FK→Animal(animal_id)], status, price, description, created_at)
+{{{FAVORITE LISTINGS}}}
+* favorite_listings(client_id[FK→User(user_id)],listing_id[FK→Listing(listing_id)])→The whole thing is the PK
+
 {{{APPOINTMENTS}}}
 * Appointment(appointment_id [PK], clinic_id [FK→!VetClinic(clinic_id)], animal_id [FK→Animal(animal_id)], responsible_owner_id [FK→Owner(user_id)], status, date_time, notes)
+
 {{{REVIEWS (SUPERTYPE + SUBTYPES)}}}
 * Review(review_id [PK], reviewer_id [FK→Client(user_id)], rating, comment, created_at)
 * !UserReview(review_id [PK, FK→Review(review_id)], target_user_id [FK→Users(user_id)])
 * !ClinicReview(review_id [PK, FK→Review(review_id)], target_clinic_id [FK→!VetClinic(clinic_id)])
+
 {{{HEALTH RECORDS}}}
 * !HealthRecord(healthrecord_id [PK], animal_id [FK→Animal(animal_id)], appointment_id [FK→Appointment(appointment_id)], type, description, date)
+
+{{{CLINIC UNAVAILABLE SLOTS}}}
+* clinic_unavailable_slots(slot_id[PK],clinic_id[FK→vet_clinics(clinic_id)],date_time,reason,created_at)
 ----
 Business rules enforced in DDL: