Changes between Version 9 and Version 10 of RelationalDesign


Ignore:
Timestamp:
09/11/26 22:01:20 (2 weeks ago)
Author:
231035
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v9 v10  
    3232- VetClinic(
    3333  clinic_id [PK],
    34   user_id [FK→Users(user_id), UQ])
     34  user_id [FK→Users(user_id), UQ],
     35  application_id [FK→VetClinicApplication(application_id), UQ],
     36  name,
     37  email,
     38  phone,
     39  city,
     40  address,
     41  location,
     42  work_days,
     43  start_time,
     44  end_time)
    3545
    3646VetClinic is also a specialization of Users. It keeps its own clinic_id as the primary key, while user_id connects it to the Users supertype.
    … …  
    6474- VetClinicApplication(
    6575  application_id [PK],
    66   clinic_id [FK→VetClinic(clinic_id), UQ],
    6776  name,
    6877  email,
    … …  
    7887----
    7988
    80 {{{ VET CLINICS }}}
    81 
    82 - VetClinic(
    83   clinic_id [PK],
    84   user_id [FK→Users(user_id), UQ],
    85   application_id [FK→VetClinicApplication(application_id), UQ],
    86   name,
    87   email,
    88   phone,
    89   city,
    90   address,
    91   location,
    92   work_days,
    93   start_time,
    94   end_time)
    95 
    96 ----
    97 
    9889{{{ ANIMALS }}}
    9990
    … …  
    156147- UserReview(
    157148  review_id [PK, FK→Review(review_id)],
    158   target_user_id [FK→Users(user_id)],
     149  target_client_id [FK→Client(user_id)],
    159150  interaction_type)
    160151