Changes between Version 27 and Version 28 of DDL

Timestamp:

09/15/25 10:49:13 (4 weeks ago)

Author:

223270

Comment:

--

DDL

@@ -9 +9 @@
 
 === Табели ===
-* DESTINACII (**__idDest__**, **imeLokacija**, opisLokacija, **tipoviMesta**, **preporachanaSezona**, prosechnaTemp, geoLokacija, drzhava, popularnost, ime, opis, **idTag*** (TAGOVI))
-* KORISNICI (**__idKorisnik__**, **ime**, **prezime**, **ePoshta**, **telBr**, datumRagjanje, **idDest***(DESTINACII))
-* STANDARD (**__idKorisnik__*** (KORISNICI), **ime**, **prezime**, **ePoshta**, **telBr**, datumRagjanje)
-* PREMIUM (**__idKorisnik__*** (KORISNICI), **ime**, **prezime**, **ePoshta**, **telBr**, datumRagjanje, datumKreiranje, popust)
-* RECENZII (**__idRecenzija__**, **korisnichkoIme**, **kvalitet**, zabeleshka, datumRecenzija, brGlasovi, **idDest*** (DESTINACII), **idKorisnik*** (KORISNICI), **idRezervacija*** (REZERVACII))
-* METEROLOSHKASOSTOJBA (**__idMeteo__**, momentTemp, **sostojbaVreme**, **predupreduvanja**, vlazhnost, veter, mesec, **idDest*** (DESTINACII))
-* PAKETI (**__idPaket__**, **imePaket**, **cena**, **pochetok**, **kraj**, **idDest*** (DESTINACII), **idAktivnost*** (AKTIVNOSTI), **idRezervacija*** (REZERVACII))
-* AKTIVNOSTI (**__idAktivnost__**, **imeAktivnost**, informacii, **kategorija**, iznos, **idDest*** (DESTINACII))
-* REZERVACII (**__idRezervacija__**, **vremenskaTochka**, **vkupnaCena**, idAktivnost* (AKTIVNOSTI), **idKorisnik*** (KORISNICI), **idMeteo*** (METEROLOSHKASOSTOJBA))
-* PREFERENCI(**__idPreferenca__**, **tipPreferenca**, prioritet, **idKorisnik*** (KORISNICI))
-* NASTANI (**__idNastan__**, **naziv**, **vidovi**, pochetenDatum, kraenDatum, detali, **idDest*** (DESTINACII))
-* TAGOVI (**__idTag__**, **tagOznaka**)
+* DESTINATION (**__idDest__**, **locationName**, locationDesc, typesOfPlaces, recommendedSeason, averageTemp, geoLocation, country, popularity, importantLocations)    
+
+**idTag*** (TAGOVI)
+* USER (**__idUser__**, **loginName**, **eMail**, phoneNumber, birthDate)    
+
+**idDest***(DESTINACII)
+* STANDARD (**__idUser__**, **loginName**, **eMail**, phoneNumber, birthDate) 
+* PREMIUM (**__idUser__**, **loginName**, **eMail**, phoneNumber, birthDate, dateCreated, discount) 
+* REVIEW (**__idReview__**, **username**, **quality**, comment, reviewDate, voteCount)
+
+**idDest*** (DESTINACII), **idKorisnik*** (KORISNICI), **idRezervacija*** (REZERVACII)
+* METEOROLOGICAL CONDITION (**__idMeteo__**, **currentTemp**, **weatherCondition**, **warnings**, humidity, wind, month)
+
+**idDest*** (DESTINACII)
+* PACKAGE (**__idPackage__**, **packageName**, **price**, **duration**)
+
+**idDest*** (DESTINACII), **idAktivnost*** (AKTIVNOSTI), **idRezervacija*** (REZERVACII)
+
+* ACTIVITY (**__idActivity__**, **activityName**, information, **category**, amount)
+
+**idDest*** (DESTINACII)
+* RESERVATION (**__idReservation__**, **timePoint**, premiumDiscountApplied, discountАmount, **totalPrice**)
+
+ idAktivnost* (AKTIVNOSTI), **idKorisnik*** (KORISNICI), **idMeteo*** (METEROLOSHKASOSTOJBA)
+* PREFERENCE (**__idPreference__**, **typePreference**, priority)
+
+**idKorisnik*** (KORISNICI)
+* EVENT (**__idEvent__**, **eventName**, **eventType**, startDate, endDate, deatils)
+
+**idDest*** (DESTINACII)
+* TAG (**__idTag__**, **tagTag**)
+
 * destinacii_has_tagovi (**destinacii_idDest, tagovi_idTag**)
 * aktivnosti_has_paketi (**aktivnosti_idAktivnost, paketi_idPaket**)