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