Changes between Version 11 and Version 12 of Normalization

Timestamp:

04/21/26 15:28:36 (11 days ago)

Author:

221296

Comment:

--

Normalization

@@ -15 +15 @@
 subscription_id, start_date, end_date, subscription_status,
 
-payment_id, user_id, subscription_id, amount,
-
-ticket_id, user_id, admin_id, subject, ticket_description, ticket_status, created_at,
+payment_id, amount,
+
+ticket_id, admin_id, subject, ticket_description, ticket_status, created_at,
 
 category_id, category_name, category_description,
@@ -23 +23 @@
 course_id, course_name, course_price, course_status, instructor_id,
 
-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
+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
 }
 }}}