__hot__ | Ariel Academy F95
| Method | Path | Description | Request Body | Response | |--------|------|-------------|--------------|----------| | GET | /api/v1/dashboard/student/:studentId | Returns student‑wide summary data. | — | overallGrade, recentActivities[], upcomingTasks[] | | GET | /api/v1/dashboard/teacher/:classId | Returns class‑level grid data. | — | students:[id, name, progress, sparkline[]] | | GET | /api/v1/analytics/cohort/:cohortId | Aggregated metrics for admin. | — | completionRate, avgGrade, attendanceHeatmap | | POST | /api/v1/notifications/email/weekly | Trigger weekly email (admin‑only). | cohortId | jobId, status |
-- Courses & Enrollments CREATE TABLE courses ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), title TEXT NOT NULL, description TEXT, created_by UUID REFERENCES users(id) ); CREATE TABLE enrollments ( student_id UUID REFERENCES students(user_id) ON DELETE CASCADE, course_id UUID REFERENCES courses(id) ON DELETE CASCADE, role_in_course TEXT CHECK (role_in_course IN ('learner','assistant')) DEFAULT 'learner', PRIMARY KEY (student_id, course_id) ); ariel academy f95
enum TaskPriority LOW MEDIUM HIGH enum TaskStatus PENDING COMPLETED OVERDUE | Method | Path | Description | Request