Enrollment Schema

ID of the course the student is enrolled in

ID of the enrolled student

Current enrollment status. pending_payment is set for Stripe-direct charges before the PaymentIntent succeeds (ADR 0066b Phase 3). pending_approval/rejected gate self-enrollment behind team-lead approval (WP-D).

Date and time when the student enrolled

Date and time when the course was completed

Completion feedback: 1–5 star satisfaction rating (WP-B).

Completion feedback: free-text comment (WP-B).

Completion feedback: optional 0–10 recommendation score (NPS, WP-B).

When completion feedback was submitted (WP-B).

User who self-enrolled and triggered the approval request (WP-D).

Team lead / approver who approved or rejected the enrollment (WP-D).

Reason given when an enrollment was rejected (WP-D).

Course completion progress as percentage

Last time the student accessed the course

Whether a certificate has been issued for completion

Date and time when the certificate was issued

ID of the associated gradebook entry

ID of the last lesson/section the student visited

ID of the last learning unit the student visited

Tenant the learner belongs to, when different from the course owner. Null for MSP-internal enrollments.

course_shares row that authorised this cross-tenant enrollment.

Frozen pricing at enrollment time (set on cross-tenant enrollments).

Course.contentVersion at the moment of enrollment. The frontend compares with the current course version and warns the learner if the course was updated mid-flight.