Changes between Version 8 and Version 9 of RelationalDesign

Timestamp:

12/07/22 17:12:30 (2 years ago)

Author:

201060

Comment:

--

RelationalDesign

@@ -16 +16 @@
 •       Moderator(__**userID__***(user))
 
-•       Quiz Taker(__**userID__***(user), tournamentID*(tournament), tournamentPhaseID*(tournament Phase))
+•       Quiz Taker(__**userID__***(user))
 
-•       Tournament Organizer(__**tournamentOrganizerID__**, __**userID__***(moderator), **tournamentID***(tournament))
+•       Tournament Organizer(__**tournamentOrganizerID__**, __**userID__***(moderator))
 
 •       Tournament(__**tournamentID**__, **tournamentName**)
@@ -30 +30 @@
 •       Quiz(__**quizID**__, **categoryID***(category), **quizName**, tournamentPhaseID*(tournament Phase))
 
-•       Medal(__**medalID**__, **userID***(quizTaker), **tournamentID***(tournament), **medalName**, **description**)
+•       Medal(__**medalID**__, **tournamentID***(tournament), **medalName**, **description**)
 
-•       Question(__**questionID**__, **questionText**, **quizID***(quiz))
+•       Question(__**questionID**__, **questionText**)
 
 •       Hint(__**hintID**__, **hintText**, **questionID***(question))
@@ -62 +62 @@
 •       medal_is_awarded_to_quizTaker(__**medalID**__*(medal), __**userID**__*(user))
 
+•       badge_is_awarded_to_quizTaker(__**badgeID**__*(medal), __**userID**__*(user))
+
 
 === DDL скрипта за бришење на табелите и креирање на табелите