Changes between Version 10 and Version 11 of Normalization

Timestamp:

04/21/26 15:25:53 (11 days ago)

Author:

221296

Comment:

--

Normalization

@@ -10 +10 @@
 R = {
 user_id, first_name, last_name, email, password, role,
-plan_id, plan_name, price, duration_months, description, access_type,
+
+plan_id, plan_name, price, duration_months, plan_description, access_type,
+
 subscription_id, start_date, end_date, subscription_status,
-payment_id, amount,
-ticket_id, admin_id, subject, description_ticket, ticket_status, created_at,
+
+payment_id, user_id, subscription_id, amount,
+
+ticket_id, user_id, admin_id, subject, ticket_description, ticket_status, created_at,
+
 category_id, category_name, category_description,
+
 course_id, course_name, course_price, course_status, instructor_id,
-module_id, module_title, module_description,
-lesson_id, lesson_title, material,
-quiz_id, total_points, passing_score,
-attempt_id, score, attempt_date,
-enrollment_id, enroll_date, completion_status, progress_percentage,
-certificate_id, issue_date, certificate_code, certificate_status
+
+course_id, category_id,
+
+module_id, course_id, module_title, module_description,
+
+lesson_id, module_id, lesson_title, material,
+
+quiz_id, lesson_id, total_points, passing_score,
+
+attempt_id, user_id, quiz_id, score, attempt_date,
+
+enrollment_id, user_id, course_id, enroll_date, completion_status, progress_percentage,
+
+certificate_id, enrollment_id, issue_date, certificate_code, certificate_status
 }
 }}}