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