Changes between Version 6 and Version 7 of RelationalDesign

Timestamp:

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

Author:

201063

Comment:

--

RelationalDesign

@@ -3 +3 @@
 
 == Релациска шема
+
+Мапирачка трансформација
+
+Ознаки:
+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, thelephone_vet_clinic, address_vet_clinic)
+
+
+=== Слаби Ентитети
+
+
+=== М-М Релации
+
 
 == Релациски дијаграм