44
Tables (12)
learning_card
- id — int8 — Primary key — NOT NULL
- subject_id — int8 — Foreign key → subject.id — NOT NULL
- card_type — varchar(32) — NOT NULL
- front_text — varchar(4000) — NOT NULL
- back_text — varchar(4000)
- answer_text — varchar(2000)
- explanation — varchar(4000)
- is_ai_generated — bool — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- SUBJECTIVE_CARD::character — varying)::text)))
problem
- id — int8 — Primary key — NOT NULL
- subject_id — int4 — Foreign key → subject.id — NOT NULL
- question — varchar(2000) — NOT NULL
- answer — varchar(2000) — NOT NULL
- explanation — varchar(4000)
- type — varchar(32) — NOT NULL
- difficulty — int4
- option1 — varchar(2000)
- option2 — varchar(2000)
- option3 — varchar(2000)
- option4 — varchar(2000)
- option5 — varchar(2000)
- is_ai_generated — bool — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- OBJECTIVE::character — varying)::text)))
programming_language_problems
- id — bigserial — Primary key — NOT NULL
- subject_id — int4 — Foreign key → subject.id
- prog_language — varchar(64) — NOT NULL
- question — varchar(1000) — NOT NULL
- answer — varchar(500) — NOT NULL
- explanation — varchar(2000)
- difficulty — int4
- is_ai_generated — bool — NOT NULL
- created_at — timestamp
- updated_at — timestamp
statistics
- id — bigserial — Primary key — NOT NULL
- is_correct — bool — NOT NULL
- problem_type — varchar(32) — NOT NULL
- reference_id — int8 — NOT NULL
- submitted_at — timestamp(6)
- user_id — int8 — NOT NULL
study_session
- id — int8 — Primary key — NOT NULL
- user_id — int8 — NOT NULL
- subject_id — int4 — Foreign key → subject.id — NOT NULL
- session_branch — varchar(32) — NOT NULL
- session_type — varchar(32) — NOT NULL
- status — varchar(32) — NOT NULL
- total_questions — int4 — NOT NULL
- correct_count — int4 — NOT NULL
- incorrect_count — int4 — NOT NULL
- started_at — timestamp — NOT NULL
- completed_at — timestamp
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- problem_branch — varchar(32)
- SUBJECTIVE::character — varying
- PROGRAMMING_LANGUAGE::character — varying
- LEARNING::character — varying)::text)))
- COMPLETED::character — varying
- ABANDONED::character — varying)::text)))
- SUBJECTIVE_RANDOM::character — varying
- WRONG_ANSWER::character — varying
- PROGRAMMING_RANDOM::character — varying
- THEORY_FLASHCARD::character — varying
- THEORY_SUBJECTIVE::character — varying)::text)))
study_session_item
- id — int8 — Primary key — NOT NULL
- session_id — int8 — Foreign key → study_session.id — NOT NULL
- item_type — varchar(32) — NOT NULL
- reference_id — int8 — NOT NULL
- subject_id — int8 — Foreign key → subject.id — NOT NULL
- item_order — int4 — NOT NULL
- presented_at — timestamp — NOT NULL
- answered_at — timestamp
- is_answered — bool — NOT NULL
- is_correct — bool
- user_submitted_answer — varchar(4000)
- bookmarked_wrong — bool — NOT NULL
- SUBJECTIVE::character — varying
- PROGRAMMING_LANGUAGE::character — varying
- LEARNING::character — varying)::text)))
subject
- id — int4 — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- description — varchar(1000)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
subjective_problems
- id — bigserial — Primary key — NOT NULL
- subject_id — int4 — Foreign key → subject.id
- question — varchar(1000) — NOT NULL
- answer — varchar(500) — NOT NULL
- explanation — varchar(2000)
- difficulty — int4
- is_ai_generated — bool — NOT NULL
- created_at — timestamp
- updated_at — timestamp
user_answer
- id — int8 — Primary key — NOT NULL
- user_id — int8 — NOT NULL
- session_id — int8 — Foreign key → study_session.id — NOT NULL
- item_type — varchar(32) — NOT NULL
- reference_id — int8 — NOT NULL
- submitted_answer — varchar(4000) — NOT NULL
- is_correct — bool — NOT NULL
- submitted_at — timestamp — NOT NULL
- SUBJECTIVE::character — varying
- PROGRAMMING_LANGUAGE::character — varying
- LEARNING::character — varying)::text)))
user_statistics
- id — int8 — Primary key — NOT NULL
- user_id — int8 — NOT NULL
- subject_id — int8 — Foreign key → subject.id — NOT NULL
- branch — varchar(32) — NOT NULL
- total_attempted — int4 — NOT NULL
- correct_count — int4 — NOT NULL
- incorrect_count — int4 — NOT NULL
- last_studied_at — timestamp
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- SUBJECTIVE::character — varying
- PROGRAMMING_LANGUAGE::character — varying)::text)))
users
- id — int8 — Primary key — NOT NULL
- google_id — varchar(255)
- email — varchar(255) — NOT NULL
- nickname — varchar(255)
- role — varchar(32) — NOT NULL
- trial_started_at — timestamp — NOT NULL
- trial_expires_at — timestamp — NOT NULL
- subscription_started_at — timestamp
- subscription_expires_at — timestamp
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- password — varchar(255)
- username — varchar(255) — NOT NULL
- (money_user::character — varying)::text
- (admin::character — varying)::text)))
wrong_answer_bookmark
- id — int8 — Primary key — NOT NULL
- user_id — int8 — NOT NULL
- item_type — varchar(32) — NOT NULL
- reference_id — int8 — NOT NULL
- bookmarked_at — timestamp — NOT NULL
- review_count — int4 — NOT NULL
- last_reviewed_at — timestamp
- SUBJECTIVE::character — varying
- PROGRAMMING_LANGUAGE::character — varying
- LEARNING::character — varying)::text)))