yogi erd
Tables (17)
Category (Untitled6)
- Test prep (Field)
- Classroom Tools (Field2)
- Teacher Support (Field3)
Choices (Untitled2)
- Questions'id (Key3) — text — Foreign key → Questions.Questions.id — NOT NULL
- Tests.id (Key) — text — Foreign key → Questions.Tests.id — NOT NULL
- Subject.id (Key2) — text — Foreign key → Questions.Subject.id — NOT NULL
- Choice Text (Field) — Text
- Associated Question (Field2) — Question
- test.name (Field3) — text
Question Results (Untitled5)
- Question Results'id (Key) — text — Primary key — NOT NULL
- tests.title (Key2) — text — Foreign key → Test Results.tests.title — NOT NULL
- Subject.id (Key22) — text — Foreign key → Test Results.Subject.id — NOT NULL
- Questions.id (Key3) — text — Foreign key → Questions.Questions.id — NOT NULL
- Tests.id (Key4) — text — Foreign key → Questions.Tests.id — NOT NULL
- Subject.id (Key23) — text — Foreign key → Questions.Subject.id — NOT NULL
- User (Field) — User
- Grading (Field2) — int
- Answer (Field4) — text/choice
Question Type (Untitled9)
- Multiple Choice (Field)
- True/False (Field2)
- Essay (Field3)
- Short Answer (Field4)
- Long Answer (Field5)
Questions
- Questions.id (Key3) — text — Primary key — NOT NULL
- Tests.id (Key) — text — Foreign key → Tests.Tests.id — NOT NULL
- Subject.id (Key2) — text — Foreign key → Tests.Subject.id — NOT NULL
- Question Type (Field5) — option set
- Question Text (Field7) — text
- Choices (Field) — List of Choices
- Correct Answer (Field8) — text
- Correct Choice (Field4) — List of Choice
- Associated Test (Field2) — option set
- Order (Field3) — int
- Points (Field6) — int
- Test.id (Field9) — text
Resource Type (CopyOfRole)
- Quiz (Field)
- Flashcard (Field2)
- Study Note (Field3)
- Lesson Plan (Field4)
Resources (Untitled)
- Resources.id (Key) — text — Primary key — NOT NULL
- Users.id (Key2) — User — Foreign key → Users.Users.id — NOT NULL
- Tools.id (Key3) — text — Foreign key → Tools.Tools.id — NOT NULL
- Subject.id (Key22) — text — Foreign key → Tools.Subject.name — NOT NULL
- Resources.title (Field) — text
- Type (Field2) — option set
- Content (Field3) — rich text of file
- Creation Date (Field7) — date
- Last Updated (Field8) — date
Role
- Student (Field)
- Teacher (Field2)
- Admin (Field3)
Subcategory (Untitled7)
- SAT (Field)
- AP (Field2)
- IB (Field3)
- ACT (Field4)
- LSAT (Field5)
- Quiz Generator (Field6)
- Flashcard Generator (Field7)
- Study Note Generator (Field8)
- Lesson Plan Generator (Field9)
- AI Course Creator (Field10)
Subject Category (Untitled11)
- STEM (Field) — text
- Humanities (Field2) — text
- Social Science (Field3) — text
Subjects
- Subject.id (Key) — text — Primary key — NOT NULL
- Subject.name (Field) — text
- Description (Field2) — text
- Category (Field3) — option set
Test Results (Untitled4)
- tests.title (Key2) — text — Foreign key → Tests.Tests.id — NOT NULL
- Subject.id (Key22) — text — Foreign key → Tests.Subject.id — NOT NULL
- User (Field) — User
- Score (Field2) — Score achieved by the user
- Date Taken (Field3) — Date the test was taken
- Answers (Field5) — list of Question Results
Test Type (Untitled8)
- SAT (Field)
- AP (Field2)
- IB (Field3)
- ACT (Field4)
- LSAT (Field5)
Tests
- Tests.id (Key) — text — Primary key — NOT NULL
- Subject.id (Key2) — text — Foreign key → Subjects.Subject.id — NOT NULL
- Test.name (Field4) — text
- Type (Field7) — option set
- Associated Tool (Field3) — Tool
- Creation Date (Field10) — date
- Last Updated (Field6) — date
- Creator (Field) — User
- Num of Questions (Field2) — int
- Questions.id (Field8) — text
Tools (Untitled3)
- Tools.id (Key) — text — Primary key — NOT NULL
- Subject.name (Key2) — text — Foreign key → Subjects.Subject.id — NOT NULL
- Tools.name (Field) — text
- Description (Field2) — text
- Category (Field3) — option set
- Subcategory (Field4) — option set
- Creation Date (Field10) — date
- Last Updated (Field11) — date
User_activity (Untitled10)
- Users.id (Key2) — text — Foreign key → Users.Users.id — NOT NULL
- Saved tools (Field) — list of Tools
- Liked Tools (Field5) — list of Tools
- Test Results (Field2) — list of Test Results
- Created Resources (Field3) — list of Resources
Users
- Users.id (Key) — text — Primary key — NOT NULL
- Users.name (Field) — text
- Email (Field2) — email
- Password (Field3) — password
- Role (Field4) — option set
- Profile Picture (Field5) — image
- Subscription Status (Field10) — date
- Subscription Start Date (Field11) — date
- Subscription End Date (Field12) — text
- Discount Code (Field13) — date
- Trial Period Start Date (Field14) — date
- Trial Period End Date (Field15) — date
- Grade (Field16) — text
- Country (Field17) — text
- School Name (Field18) — Text