---
# System prepended metadata

title: Untitled

---


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