63
Tables (12)
learning_card
- id — BIGINT — Primary key — NOT NULL
- what_subject_id — BIGINT — Foreign key → subject.id — NOT NULL
- item_type — CHARACTER — NOT NULL
- front_text — CHARACTER — NOT NULL
- back_text — CHARACTER
- answer_text — CHARACTER
- explanation — CHARACTER
- is_ai_generated — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- SUBJECTIVE_CARD — CHARACTER
problem
- id — BIGINT — Primary key — NOT NULL
- what_subject_id — INTEGER — Foreign key → subject.id — NOT NULL
- question — CHARACTER — NOT NULL
- answer — CHARACTER — NOT NULL
- explanation — CHARACTER
- item_type — CHARACTER — NOT NULL
- difficulty — INTEGER
- option1 — CHARACTER
- option2 — CHARACTER
- option3 — CHARACTER
- option4 — CHARACTER
- option5 — CHARACTER
- is_ai_generated — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- OBJECTIVE — CHARACTER
programming_language_problems
- id — BIGINT — Primary key — NOT NULL
- what_subject_id — INTEGER — Foreign key → subject.id
- prog_language — CHARACTER — NOT NULL
- question — CHARACTER — NOT NULL
- answer — CHARACTER — NOT NULL
- explanation — CHARACTER
- difficulty — INTEGER
- is_ai_generated — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
statistics
- id — BIGINT — Primary key — NOT NULL
- user_who_id — BIGINT — Foreign key → users.id — NOT NULL
- is_correct — BOOLEAN — NOT NULL
- item_type — CHARACTER — NOT NULL
- what_subject_id — BIGINT — NOT NULL
- submitted_at — TIMESTAMP(6)
study_session
- id — BIGINT — Primary key — NOT NULL
- user_who_id — BIGINT — Foreign key → users.id — NOT NULL
- what_subject_id — INTEGER — Foreign key → subject.id — NOT NULL
- item_type — CHARACTER — NOT NULL
- status — CHARACTER
study_session_item
- id — BIGINT — Primary key — NOT NULL
- type_id — BIGINT — Foreign key → study_session.id — NOT NULL
- item_type — CHARACTER — NOT NULL
- what_subject_id — BIGINT — Foreign key → subject.id — NOT NULL
- what_item_id — BIGINT — NOT NULL
- item_order — INTEGER — NOT NULL
- presented_at — TIMESTAMP — NOT NULL
- answered_at — TIMESTAMP
- is_answered — BOOLEAN — NOT NULL
- is_correct — BOOLEAN
- submitted_answer — CHARACTER
- bookmarked_wrong — BOOLEAN — NOT NULL
- SUBJECTIVE — CHARACTER
- PROGRAMMING_LANGUAGE — CHARACTER
- LEARNING — CHARACTER
subject
- id — INTEGER — Primary key — NOT NULL
- name — CHARACTER — NOT NULL
- description — CHARACTER
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
subjective_problems
- id — BIGINT — Primary key — NOT NULL
- what_subject_id — INTEGER — Foreign key → subject.id
- question — CHARACTER — NOT NULL
- answer — CHARACTER — NOT NULL
- explanation — CHARACTER
- difficulty — INTEGER
- is_ai_generated — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_answer
- id — BIGINT — Primary key — NOT NULL
- user_who_id — BIGINT — Foreign key → users.id — NOT NULL
- type_id — CHARACTER — NOT NULL
- item_type — CHARACTER — NOT NULL
- what_subject_id — BIGINT — NOT NULL
- submitted_answer — CHARACTER — NOT NULL
- is_correct — BOOLEAN — NOT NULL
- submitted_at — TIMESTAMP — NOT NULL
- SUBJECTIVE — CHARACTER
- PROGRAMMING_LANGUAGE — CHARACTER
- theory_LEARNING — CHARACTER
user_statistics
- id — BIGINT — Primary key — NOT NULL
- user_who_id — BIGINT — Foreign key → users.id — NOT NULL
- what_subject_id — BIGINT — Foreign key → subject.id — NOT NULL
- branch — CHARACTER — NOT NULL
- total_attempted — INTEGER — NOT NULL
- correct_count — INTEGER — NOT NULL
- incorrect_count — INTEGER — NOT NULL
- last_studied_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- SUBJECTIVE — CHARACTER
- PROGRAMMING_LANGUAGE — CHARACTER
users
- id — BIGINT — Primary key — NOT NULL
- google_id — CHARACTER
- email — CHARACTER — NOT NULL
- nickname — CHARACTER
- item_type — CHARACTER — 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 — CHARACTER
- username — CHARACTER — NOT NULL
- money_user — CHARACTER
- admin — CHARACTER
wrong_answer_bookmark
- id — BIGINT — Primary key — NOT NULL
- user_who_id — BIGINT — Foreign key → users.id — NOT NULL
- item_type — CHARACTER — NOT NULL
- what_subject_id — BIGINT — NOT NULL
- bookmarked_at — TIMESTAMP
- review_count — INTEGER