AI Tutor

Tables (17)

BaseEntity

  • createdAt — LocalDate
  • updatedAt — LocalDate
  • status — Status

BaseEntity (CopyOfBaseEntity)

  • createdAt — LocalDate
  • updatedAt — LocalDate
  • status — Status

Course (CopyOfNote)

  • course_id (note_id) — Long — Primary key — NOT NULL
  • student_id (Key) — Foreign key → Student.student_id — NOT NULL
  • professor_id (Key2) — Foreign key → Professor.professor_id — NOT NULL
  • course_name (title) — String
  • code (Field)

Folder

  • folder_id — Long — Primary key — NOT NULL
  • user_id — Long — Foreign key → User.user_id — NOT NULL
  • folder_name — String
  • professor — String

Note

  • note_id — Long — Primary key — NOT NULL
  • folder_id — Long — Foreign key → Folder.folder_id — NOT NULL
  • user_id — Long — Foreign key → Folder.user_id — NOT NULL
  • length — Long
  • step — int
  • title — String
  • note_status — Note_Status

Practice

  • practice_id — Long — Primary key — NOT NULL
  • note_id — Long — Foreign key → Note.note_id — NOT NULL
  • folder_id — Long — Foreign key → Note.folder_id — NOT NULL
  • user_id — Long — Foreign key → Note.user_id — NOT NULL
  • content — String
  • user_answer — String
  • ai_answer — String

Practice (CopyOfPractice)

  • practice_id — Long — Primary key — NOT NULL
  • worksheet_id (Key) — Foreign key → WorkSheet.worksheet_id — NOT NULL
  • course_id (note_id) — Long — Foreign key → WorkSheet.course_id — NOT NULL
  • content — String
  • comment (Field)
  • professor_answer (user_answer) — String
  • student_answer (ai_answer) — String
  • score (Field2)

Professor (Untitled3)

  • professor_id (Key) — Primary key — NOT NULL
  • user_id — Long — Foreign key → User.user_id — NOT NULL

Student (Untitled2)

  • student_id (Key) — Primary key — NOT NULL
  • user_id — Long — Foreign key → User.user_id — NOT NULL

Summary (CopyOfSummary)

  • summary_id — String — Primary key — NOT NULL
  • content — String

Summary

  • summary_id — String — Primary key — NOT NULL
  • text_id — Long — Foreign key → Text.text_id — NOT NULL
  • note_id — Long — Foreign key → Text.note_id — NOT NULL
  • folder_id — Long — Foreign key → Text.folder_id — NOT NULL
  • user_id — Long — Foreign key → Text.user_id — NOT NULL
  • content — String

Text (CopyOfText)

  • text_id — Long — Primary key — NOT NULL
  • timestamp — TimeStamp
  • content — String

Text

  • text_id — Long — Primary key — NOT NULL
  • note_id — Long — Foreign key → Note.note_id — NOT NULL
  • folder_id — Long — Foreign key → Note.folder_id — NOT NULL
  • user_id — Long — Foreign key → Note.user_id — NOT NULL
  • timestamp — TimeStamp
  • content — String

Tutor

  • tutor_id — Long — Primary key — NOT NULL
  • note_id — Long — Foreign key → Note.note_id — NOT NULL
  • folder_id — Long — Foreign key → Note.folder_id — NOT NULL
  • user_id — Long — Foreign key → Note.user_id — NOT NULL
  • question — String
  • answer — String

User (CopyOfUser)

  • user_id — Long — Primary key — NOT NULL
  • name — String
  • email — String
  • role (Field)

User

  • user_id — Long — Primary key — NOT NULL
  • name — String
  • email — String

WorkSheet (Untitled)

  • worksheet_id (Key) — Primary key — NOT NULL
  • course_id (note_id) — Long — Foreign key → Course.course_id — NOT NULL
  • average (Field3)
  • worksheet_status (Field)
  • total_score (Field2)