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)