Changes between Version 9 and Version 10 of RelationalDesign

Timestamp:

11/30/22 13:35:46 (2 years ago)

Author:

201063

Comment:

--

RelationalDesign

@@ -15 +15 @@
 User (**id_user**, **date_created_user**, **name_user**, **email_user**, **password_user**, telephone_user)
 
-Adopter (**id_user***(user), free_time, funds, has_other_pets, has_kids, housing, physical_activity_adopters, will_foster, is_verified)
+Adopter (**id_user***''(user)'', free_time, funds, has_other_pets, has_kids, housing, physical_activity_adopters, will_foster, **is_verified**)
 
-Surendee (id_user*(user))
+Surendee (**id_user***''(user)'')
 
-Employee (id_user*(user), position)
+Employee (**id_user***''(user)'', **position**)
 
-Admin (id_user*(user))
+Admin (**id_user***''(user)'')
 
-Donor (id_user*(user), is_from_organisation)
+Donor (**id_user***''(user)'', **is_from_organisation**)
 
-Organization (id_organisation, name_organisation, email_organisation, billing_information)
+Organization (**id_organisation**, **name_organisation**, **email_organisation**, **billing_information**)
 
-Shelter (id_shelter, address_shelter, telephone_shelter)
+Shelter (**id_shelter**, **address_shelter**, **telephone_shelter**)
 
-Post (id_post, date_post, url_thumbanail)
+Post (**id_post**, **date_post**, url_thumbanail)
 * ограничување: Post мора да биде во точно една од релациите surrendees_publishes_and_manages_posts или employee_publishes_and_manages_post, не смее да не биде во ниту една или пак во двете
 
-Adoption (id_adoption, start_date, end_date_foster)
+Adoption (**id_adoption**, **start_date**, end_date_foster)
 
-Pet (id_pet, url_pet_image, age_group, size, breed, name_pet, species, gender, can_be_fostered)
+Pet (**id_pet**, url_pet_image, **age_group**, **size**, breed, name_pet, **species**, **gender**, **can_be_fostered**)
 
-Category (id_category, name_category)
+Category (**id_category**, **name_category**)
 
-Food (id_food, manufacturer, name_food, type)
+Food (**id_food**, **manufacturer**, **name_food**, **type**)
 
-Therapy (id_therapy, health_problem, start_date, end_date)
+Therapy (**id_therapy**, **health_problem**, start_date, end_date)
 
-VetClinic (Id_vet_clinic, thelephone_vet_clinic, address_vet_clinic)
+VetClinic (**id_vet_clinic**, **telephone_vet_clinic**, **address_vet_clinic**)
 
 
 === Слаби Ентитети
 
+PersonalProfile (**id_pet***(pet), **friendly_to_kids**, **friendly_to_pets**, **attention**, **physical_activity**, **grooming_needed**)
 
 === М-М Релации