Changes between Version 19 and Version 20 of Normalization

Timestamp:

04/27/26 00:06:27 (5 days ago)

Author:

221296

Comment:

--

Normalization

@@ -238 +238 @@
 
 - `UserEntity (user_id, first_name, last_name, email, password, role)`
-- Users(user_id)
-- Administrators(admin_id, user_id)
-- Instructors(instructor_id, user_id)
-
-- SubscriptionPlan(plan_id, plan_name, price, duration_months, plan_description, access_type)
-- UserSubscription(subscription_id, user_id, plan_id, start_date, end_date, subscription_status)
-- Payment(payment_id, user_id, subscription_id, amount)
-
-- SupportTicket(ticket_id, user_id, admin_id, subject, ticket_description, ticket_status, created_at)
-
-- Category(category_id, category_name, category_description)
-- Course(course_id, course_name, course_price, course_status, instructor_id)
-- CourseCategory(course_id, category_id)
-
-- Module(module_id, course_id, module_title, module_description)
-- Lesson(lesson_id, module_id, lesson_title, material)
-- Quiz(quiz_id, lesson_id, total_points, passing_score)
-- QuizAttempt(attempt_id, user_id, quiz_id, score, attempt_date)
-
-- Enrollment(enrollment_id, user_id, course_id, enroll_date, completion_status, progress_percentage)
-- Certificate(certificate_id, enrollment_id, issue_date, certificate_code, certificate_status)
+- `Users(user_id)`
+- `Administrators(admin_id, user_id)`
+- `Instructors(instructor_id, user_id)`
+
+- `SubscriptionPlan(plan_id, plan_name, price, duration_months, plan_description, access_type)`
+- `UserSubscription(subscription_id, user_id, plan_id, start_date, end_date, subscription_status)`
+- `Payment(payment_id, user_id, subscription_id, amount)`
+
+- `SupportTicket(ticket_id, user_id, admin_id, subject, ticket_description, ticket_status, created_at)`
+
+- `Category(category_id, category_name, category_description)`
+- `Course(course_id, course_name, course_price, course_status, instructor_id)`
+- `CourseCategory(course_id, category_id)`
+
+- `Module(module_id, course_id, module_title, module_description)`
+- `Lesson(lesson_id, module_id, lesson_title, material)`
+- `Quiz(quiz_id, lesson_id, total_points, passing_score)`
+- `QuizAttempt(attempt_id, user_id, quiz_id, score, attempt_date)`
+
+- `Enrollment(enrollment_id, user_id, course_id, enroll_date, completion_status, progress_percentage)`
+- `Certificate(certificate_id, enrollment_id, issue_date, certificate_code, certificate_status)`
 
 {{{Lossless join:}}}