| users | id name, email, current_level, daily_goal_min, created_at | My profile and goal |
| levels | id code (A1–C2), title, est_weeks, ielts_band | The six CEFR levels |
| topics | id level_id, skill, title, order_no | Table of contents per level |
| resources | id type (youtube/udemy/tool), region, title, author, url, level_from, level_to, category | Video and course library |
| topic_progress | user_id topic_id status, done_at | Roadmap ticks |
| daily_logs | user_id date listen_min, speak_min, write_min, tasks_done | Streak and time tracking |
| vocabulary | id user_id, word, english_meaning, my_sentence, source, next_review | English-to-English word bank |
| sentence_bank | id user_id, sentence, frame, source_url | Useful sentences from videos |
| journal_entries | id user_id, date, text, ai_feedback | 15-minute daily journal |
| recordings | id user_id, date, topic, file_url, transcript, filler_count, ai_feedback | Daily 5-minute speaking videos |
| skill_ratings | user_id month vocabulary, grammar, reading, writing, listening, speaking | Monthly self-rating |