Changes between Version 12 and Version 13 of RelationalDesign
- Timestamp:
- 11/30/22 13:45:06 (2 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v12 v13 10 10 === Ентитети 11 11 12 User ( **id_user**, **date_created_user**, **name_user**, **email_user**, **password_user**, telephone_user)12 User (__**id_user**__, **date_created_user**, **name_user**, **email_user**, **password_user**, telephone_user) 13 13 14 Adopter ( **id_user***''(user)'', free_time, funds, has_other_pets, has_kids, housing, physical_activity_adopters, will_foster, **is_verified**)14 Adopter (__**id_user***__''(user)'', free_time, funds, has_other_pets, has_kids, housing, physical_activity_adopters, will_foster, **is_verified**) 15 15 16 Surendee ( **id_user***''(user)'')16 Surendee (__**id_user***__''(user)'') 17 17 18 Employee ( **id_user***''(user)'', **position**)18 Employee (__**id_user***__''(user)'', **position**) 19 19 20 Admin ( **id_user***''(user)'')20 Admin (__**id_user***__''(user)'') 21 21 22 Donor ( **id_user***''(user)'', **is_from_organisation**)22 Donor (__**id_user***__''(user)'', **is_from_organisation**) 23 23 24 Organization ( **id_organisation**, **name_organisation**, **email_organisation**, **billing_information**)24 Organization (__**id_organisation**__, **name_organisation**, **email_organisation**, **billing_information**) 25 25 26 Shelter ( **id_shelter**, **address_shelter**, **telephone_shelter**)26 Shelter (__**id_shelter**__, **address_shelter**, **telephone_shelter**) 27 27 28 Post ( **id_post**, **date_post**, url_thumbanail)28 Post (__**id_post**__, **date_post**, url_thumbanail) 29 29 * ограничување: Post мора да биде во точно една од релациите surrendees_publishes_and_manages_posts или employee_publishes_and_manages_post, не смее да не биде во ниту една или пак во двете 30 30 31 Adoption ( **id_adoption**, **start_date**, end_date_foster)31 Adoption (__**id_adoption**__, **start_date**, end_date_foster) 32 32 33 Pet ( **id_pet**, url_pet_image, **age_group**, **size**, breed, name_pet, **species**, **gender**, **can_be_fostered**)33 Pet (__**id_pet**__, url_pet_image, **age_group**, **size**, breed, name_pet, **species**, **gender**, **can_be_fostered**) 34 34 35 Category ( **id_category**, **name_category**)35 Category (__**id_category**__, **name_category**) 36 36 37 Food ( **id_food**, **manufacturer**, **name_food**, **type**)37 Food (__**id_food**__, **manufacturer**, **name_food**, **type**) 38 38 39 Therapy ( **id_therapy**, **health_problem**, start_date, end_date)39 Therapy (__**id_therapy**__, **health_problem**, start_date, end_date) 40 40 41 VetClinic ( **id_vet_clinic**, **telephone_vet_clinic**, **address_vet_clinic**)41 VetClinic (__**id_vet_clinic**__, **telephone_vet_clinic**, **address_vet_clinic**) 42 42 43 43 44 44 === Слаби Ентитети 45 45 46 PersonalProfile ( **id_pet***(pet), **friendly_to_kids**, **friendly_to_pets**, **attention**, **physical_activity**, **grooming_needed**)46 PersonalProfile (__**id_pet***__(pet), **friendly_to_kids**, **friendly_to_pets**, **attention**, **physical_activity**, **grooming_needed**) 47 47 48 48 === М-М Релации