249 | | |
250 | | |
251 | | |
| 249 | \\ Со наоѓање на сите затварачи |
| 250 | **F2** = { pet_cares_id ->title, description, start_date, dateEnding |
| 251 | vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude |
| 252 | roles_id->type |
| 253 | users_id -> first_name, last_name, phoneNumber, email, password, roles_id |
| 254 | blog_post_for_consultation_id -> blog_post_title, blog_post_description, dateAsked, users_id |
| 255 | blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id |
| 256 | cities_id-> cities_name |
| 257 | reports_id-> reports_description, pets_id |
| 258 | reports_id , pets_id→ users_id |
| 259 | pet_status_id->node, pet_status_type |
| 260 | therapy_id->appoitmentDate, therapy_description |
| 261 | diagnostics_id-> diagnostics_description |
| 262 | medecines_id-> medecines_name, medecines_description |
| 263 | pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id |
| 264 | pet_galery_id->image, pets_id |
| 265 | orders_id → userid |
| 266 | products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity |
| 267 | products_id, orders_id → quantity |
| 268 | breeds_id-> breeds_name, type_of_pets_id |
| 269 | type_of_pets_id->kind_of_pet, type_of_pets_description |
| 270 | medecines_id → manufacturers_id |
| 271 | vet_centers_id, pets_id → pet_status_id } |
| 272 | \\ **Клуч** (pet_cares_id, blog_post_answers_id, cities_id, reports_id, therapy_id, medecines_id, |
| 273 | pet_galery_id, orders_id, products_id, breeds_id) |
| 274 | \\ **R1 n R2** = jobs_id, клуч за R1 што значи нема губење на податоци. |
| 275 | |
| 276 | |
| 277 | |