Changes between Version 2 and Version 3 of EnrollingCourse

Timestamp:

01/22/26 03:35:36 (16 hours ago)

Author:

221296

Comment:

--

EnrollingCourse

@@ -3 +3 @@
 ==== Actors: **Registered User (USER)**
 
-**1.** A logged-in user selects a course.
-
-**2.** The system verifies that the user has an active subscription.
-
-**3.** An enrollment record is created.
+**1.** Verify Active Subscription.
 
 
 {{{#!sql
-INSERT INTO enrollment (user_id, course_id, enroll_date, completion_status, progress_percentage)
-VALUES (1, 3, CURRENT_DATE, 'IN_PROGRESS', 0);
+SELECT 1
+FROM user_subscription
+WHERE user_id = :userId
+  AND status = 'ACTIVE'
+  AND end_date >= CURRENT_DATE;
+
+}}}
 
 
+**2.** Check Existing Enrollment.
+
+
+{{{#!sql
+SELECT 1
+FROM enrollment
+WHERE user_id = :userId
+  AND course_id = :courseId;
+
 }}}
+
+
+**3.** Create Enrollment Record.
+
+
+{{{#!sql
+INSERT INTO enrollment ( user_id, course_id, enroll_date, completion_status, progress_percentage)
+VALUES ( :userId, :courseId, CURRENT_DATE, 'IN_PROGRESS', 0);
+
+}}}