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