== Enrolling in a Course

==== Actors: **Registered User (USER)**

**1.** Verify Active Subscription.


{{{#!sql
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);

}}}