Changes between Version 3 and Version 4 of Normalization

Timestamp:

04/21/26 00:34:15 (11 days ago)

Author:

221296

Comment:

--

Normalization

@@ -13 +13 @@
  plan_id, plan_name, price, duration_months, access_type,
 
- subscription_id, start_date, end_date, subscription_status,
-
- payment_id, amount,
-
- ticket_id, subject, description, ticket_status, created_at,
+ subscription_id, user_id_sub, plan_id_sub, start_date, end_date, subscription_status,
+
+ payment_id, user_id_pay, subscription_id_pay, amount,
+
+ ticket_id, user_id_ticket, admin_id, subject, description, ticket_status, created_at,
 
  category_id, category_name, category_description,
@@ -23 +23 @@
  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_cc, category_id_cc,
+
+ module_id, course_id_mod, module_title, module_description,
+
+ lesson_id, module_id_lesson, lesson_title, material,
+
+ quiz_id, lesson_id_quiz, total_points, passing_score,
+
+ attempt_id, user_id_attempt, quiz_id_attempt, score, attempt_date,
+
+ enrollment_id, user_id_enroll, course_id_enroll, enroll_date, completion_status, progress_percentage,
+
+ certificate_id, enrollment_id_cert, issue_date, certificate_code, certificate_status
 }
 }}}