Changes between Version 12 and Version 13 of RelationalDesign


Ignore:
Timestamp:
11/30/22 13:45:06 (2 years ago)
Author:
201063
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v12 v13  
    1010=== Ентитети
    1111
    12 User (**id_user**, **date_created_user**, **name_user**, **email_user**, **password_user**, telephone_user)
     12User (__**id_user**__, **date_created_user**, **name_user**, **email_user**, **password_user**, telephone_user)
    1313
    14 Adopter (**id_user***''(user)'', free_time, funds, has_other_pets, has_kids, housing, physical_activity_adopters, will_foster, **is_verified**)
     14Adopter (__**id_user***__''(user)'', free_time, funds, has_other_pets, has_kids, housing, physical_activity_adopters, will_foster, **is_verified**)
    1515
    16 Surendee (**id_user***''(user)'')
     16Surendee (__**id_user***__''(user)'')
    1717
    18 Employee (**id_user***''(user)'', **position**)
     18Employee (__**id_user***__''(user)'', **position**)
    1919
    20 Admin (**id_user***''(user)'')
     20Admin (__**id_user***__''(user)'')
    2121
    22 Donor (**id_user***''(user)'', **is_from_organisation**)
     22Donor (__**id_user***__''(user)'', **is_from_organisation**)
    2323
    24 Organization (**id_organisation**, **name_organisation**, **email_organisation**, **billing_information**)
     24Organization (__**id_organisation**__, **name_organisation**, **email_organisation**, **billing_information**)
    2525
    26 Shelter (**id_shelter**, **address_shelter**, **telephone_shelter**)
     26Shelter (__**id_shelter**__, **address_shelter**, **telephone_shelter**)
    2727
    28 Post (**id_post**, **date_post**, url_thumbanail)
     28Post (__**id_post**__, **date_post**, url_thumbanail)
    2929* ограничување: Post мора да биде во точно една од релациите surrendees_publishes_and_manages_posts или employee_publishes_and_manages_post, не смее да не биде во ниту една или пак во двете
    3030
    31 Adoption (**id_adoption**, **start_date**, end_date_foster)
     31Adoption (__**id_adoption**__, **start_date**, end_date_foster)
    3232
    33 Pet (**id_pet**, url_pet_image, **age_group**, **size**, breed, name_pet, **species**, **gender**, **can_be_fostered**)
     33Pet (__**id_pet**__, url_pet_image, **age_group**, **size**, breed, name_pet, **species**, **gender**, **can_be_fostered**)
    3434
    35 Category (**id_category**, **name_category**)
     35Category (__**id_category**__, **name_category**)
    3636
    37 Food (**id_food**, **manufacturer**, **name_food**, **type**)
     37Food (__**id_food**__, **manufacturer**, **name_food**, **type**)
    3838
    39 Therapy (**id_therapy**, **health_problem**, start_date, end_date)
     39Therapy (__**id_therapy**__, **health_problem**, start_date, end_date)
    4040
    41 VetClinic (**id_vet_clinic**, **telephone_vet_clinic**, **address_vet_clinic**)
     41VetClinic (__**id_vet_clinic**__, **telephone_vet_clinic**, **address_vet_clinic**)
    4242
    4343
    4444=== Слаби Ентитети
    4545
    46 PersonalProfile (**id_pet***(pet), **friendly_to_kids**, **friendly_to_pets**, **attention**, **physical_activity**, **grooming_needed**)
     46PersonalProfile (__**id_pet***__(pet), **friendly_to_kids**, **friendly_to_pets**, **attention**, **physical_activity**, **grooming_needed**)
    4747
    4848=== М-М Релации