AI Guru

Tables (8)

flashcards

  • Key (id) — int8 — Primary key — NOT NULL
  • Field2 (subject) — text
  • Field (question) — text
  • Field (answer) — text
  • Field (created_at) — timestamptz
  • Key (user_id) — uuid — Foreign key → profiles.Key — NOT NULL

notes

  • Key (id) — int8 — Primary key — NOT NULL
  • Field (title) — text
  • Field (content) — text
  • Field (summary) — text
  • Field (created_at) — timestamptz
  • Key (user_id) — uuid — Foreign key → profiles.Key — NOT NULL

profiles

  • Key (id) — uuid — Primary key — NOT NULL
  • Key2 (created_at) — timestamptz — NOT NULL
  • Key3 (full_name) — text — NOT NULL

questions

  • Key (id) — int8 — Primary key — NOT NULL
  • Field (question_text) — text
  • Field (options) — jsonb
  • Field (correct_answer) — text
  • Field (created_at) — timestamptz
  • Key (quiz_id) — int8 — Foreign key → quizzes.Key — NOT NULL

quizzes

  • Key (id) — int8 — Primary key — NOT NULL
  • Field (title) — text
  • Field (subject) — text
  • Field (difficulty) — text
  • Field (created_at) — timestamptz
  • Key (user_id) — uuid — Foreign key → profiles.Key — NOT NULL

study_materials

  • Key (ID) — int8 — Primary key — NOT NULL
  • Field (file_names) — text
  • Field (file_type) — text
  • Field (extracted_text) — text
  • Field (summary) — text
  • Field (created_at) — timestamptz
  • Key (user_id) — uuid — Foreign key → profiles.Key — NOT NULL

study_plans

  • Key (id) — int8 — Primary key — NOT NULL
  • Field2 (subject) — text
  • Field (task_date) — date
  • Field (priority) — text
  • Field (description) — text
  • Field (completed) — bool
  • Field (created_at) — timestamptz
  • Key (user_id) — uuid — Foreign key → profiles.Key — NOT NULL
  • Field (title) — text

user_progress

  • Key (id) — int8 — Primary key — NOT NULL
  • Field (completed_quizzes) — int4
  • Field (quiz_score_total) — float8
  • Field (average_quiz_score) — float8
  • Field (notes_created) — int4
  • Field (flashcards_reviewd) — int4
  • Field (study_sessions) — int4
  • Field (study_streak) — int4
  • Field (created_at) — timestamptz
  • Field (updated_at) — timestamptz
  • Key (user_id) — uuid — Foreign key → profiles.Key — NOT NULL