Database models: 1. User - user id (PK) - first name - last name - password (hashed) - classes - email - phone # 2. Subject - subject id (PK) - user id (FK + PK) - name - list of lectures - status (current or past) 3. Lecture - lecture id (PK) - user id (FK + PK) - subject id (FK + PK) - date - any categories its in (e.g. week or unit) - raw transcript - recording (?audio files are big and expensive to store... tbd) - concepts array (will depend on future research and how we process transcript) - {term, definition, student understanding score} - **redis cache** 4. Quiz - quiz id - lecture id - list of (question, answer) tuples