Changes between Version 6 and Version 7 of LogicalPhysicalDesign

Timestamp:

12/22/25 16:54:55 (6 days ago)

Author:

221296

Comment:

--

LogicalPhysicalDesign

@@ -21 +21 @@
 5. **Course **(__'''Course_ID'''__, '''Name''', '''Price''', '''Status''', __Category_ID__*(Category), __Instructor_ID__*(Instructor))
 
-6. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
+6. **Module **(__'''Module_id'''__, '''Title''', '''Description''', __Course_ID*(Course))
 
-7. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
+7. **Lesson **(__'''lesson_ID'''__, '''TItle''', '''Material''', __Module_id*(Module))
 
-8. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
+8. **Quiz **(__'''Quiz_ID'''__, '''Total_points''', '''Passing_score''', __lesson_ID*(Lesson))
 
-9. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
+9. **Enrollment **(__'''Enrollment_ID'''__, '''Enroll_date''', '''Completion_Status''', '''Progress_percentage''',__User_id*(User), __Course_ID*(Course))
 
-10. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
+10. **Certificate **(__'''Certificate_ID'''__, '''Issue_date''', '''Certificate_code''', '''Status''', __Enrollment_id*(Enrollment))
 
-11. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
+11. **SupportTicket **(__'''Ticket_ID'''__, '''Subject, Description''', '''Status''', '''Created_at''', __User_ID*(User), __Admin_ID*(Administrator))
 
-12. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
+12. **SubscriptionPlan **(__'''Plan_ID'''__, '''Name''', '''Price''', '''Duration_months''', '''Description''', '''Access_type'''
 
-13. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
+13. **UserSubscription**(__'''Subscription_ID'''__, '''Start_date''', '''End_date''', '''Status''', __User_ID*(User), __Plan_ID**(SubscriptionPlan))
 
-14. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
+14. **Payment **(__'''Payment_ID'''__, '''Amount''', __User_ID*(User), __Subscription_ID**(UserSubscription))
 
 
 === DDL скрипта за креирање и бришење на табелите ===
 
-[wiki:ddlScript.sql DDL скрипта]
+
 
 === DML скрипта за полнење на табелите со податоци ===
 
-[wiki:dmlScript.sql DML скрипта]
+
 
 === Релациски дијаграм изваден од DBeaver ===
-[[Image(DBeaverExportVer2.png)]]