= Логички и физички дизајн
(in progress...)

== Релациска шема

Мапирачка трансформација

Ознаки: bold - not null, underline - primary key, *foreign key

=== Ентитети

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**)

Surendee (**id_user***''(user)'')

Employee (**id_user***''(user)'', **position**)

Admin (**id_user***''(user)'')

Donor (**id_user***''(user)'', **is_from_organisation**)

Organization (**id_organisation**, **name_organisation**, **email_organisation**, **billing_information**)

Shelter (**id_shelter**, **address_shelter**, **telephone_shelter**)

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)

Pet (**id_pet**, url_pet_image, **age_group**, **size**, breed, name_pet, **species**, **gender**, **can_be_fostered**)

Category (**id_category**, **name_category**)

Food (**id_food**, **manufacturer**, **name_food**, **type**)

Therapy (**id_therapy**, **health_problem**, start_date, end_date)

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**)

=== М-М Релации

donor_donates_to_organisation (**id_user***''(donor)'', **id_organisation***''(organisation)'') 

adopter_views_post (**id_user***''(adopter)'', **id_post***''(post)'')

pet_belongs_to_category (**id_pet***''(pet)'', **id_category***''(category)'')

pet_needs_therapy (**id_pet***''(pet)'', **id_therapy***''(therapy)'')

pet_preferably_eats_food (**id_pet***''(pet)'', **id_food***''(food)'', **quantity_a_day**)

pet_needs_intervention_in_vet_clinic (**id_pet***''(pet)'', **id_vet_clinic***''(vetClinic)'', **date_of_interventing**)

== Релациски дијаграм

== DML скрипти
* скрипта за бришење на табелите и креирање на табелите
kreiranje.sql
* скрипта за полнење на табелите со податоци
polnenje.sql


[https://develop.finki.ukim.mk/projects/PAW5/wiki/WikiStart Назад кон почетна]