68

Tables (12)

learning_card

  • id — BIGSERIAL — Primary key
  • subject_id — BIGINT — Foreign key → subject.id — NOT NULL
  • front_card_subjective_text — VARCHAR(4000) — NOT NULL
  • back_card_subjective_text — VARCHAR(4000)
  • front_subjective_problem — VARCHAR(4000)
  • back_subjective_answer_text — VARCHAR(4000)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

ond_row_statistics (statistics)

  • id — BIGSERIAL — Primary key
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • is_correct — BOOLEAN — NOT NULL
  • problem_type — VARCHAR(32) — NOT NULL
  • problem_id — BIGINT — NOT NULL
  • submitted_at — TIMESTAMP

problem

  • id — BIGSERIAL — Primary key
  • subject_id — BIGINT — Foreign key → subject.id — NOT NULL
  • question — VARCHAR(4000) — NOT NULL
  • answer — VARCHAR(4000) — NOT NULL
  • front_subjective_problem — VARCHAR(4000)
  • back_subjective_answer_text — VARCHAR(4000)
  • problem_type — VARCHAR(32) — NOT NULL
  • option1 — VARCHAR(2000)
  • option2 — VARCHAR(2000)
  • option3 — VARCHAR(2000)
  • option4 — VARCHAR(2000)
  • option5 — VARCHAR(2000)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

programming_language_problems

  • id — BIGSERIAL — Primary key
  • subject_id — BIGINT — Foreign key → subject.id
  • front_card_subjective_text — VARCHAR(4000) — NOT NULL
  • back_card_subjective_text — VARCHAR(4000) — NOT NULL
  • front_subjective_problem — VARCHAR(4000)
  • back_subjective_answer_text — VARCHAR(4000)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

study_big_category_session (study_session)

  • id — BIGSERIAL — Primary key
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • subject_id — BIGINT — Foreign key → subject.id — NOT NULL
  • big_category_type — VARCHAR(32) — NOT NULL
  • stay_study_ing — VARCHAR(32)

study_session_item

  • id — BIGSERIAL — Primary key
  • is_studyig_session_id — BIGINT — Foreign key → study_big_category_session.id — NOT NULL
  • subject_id — BIGINT — Foreign key → subject.id — NOT NULL
  • problem_id — BIGINT — NOT NULL
  • problem_type — VARCHAR(32) — NOT NULL
  • item_order — INTEGER — NOT NULL
  • presented_at — TIMESTAMP — NOT NULL
  • answered_at — TIMESTAMP
  • is_answered — BOOLEAN — NOT NULL
  • is_correct — BOOLEAN
  • user_submitted_answer — VARCHAR(4000)
  • bookmarked_wrong — BOOLEAN — NOT NULL

subject

  • id — BIGSERIAL — Primary key
  • subject_name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(1000)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

subjective_problems

  • id — BIGSERIAL — Primary key
  • subject_id — BIGINT — Foreign key → subject.id
  • front_card_subjective_text — VARCHAR(4000) — NOT NULL
  • back_card_subjective_text — VARCHAR(4000)
  • front_subjective_problem — VARCHAR(4000)
  • back_subjective_answer_text — VARCHAR(4000) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_answer

  • id — BIGSERIAL — Primary key
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • which_Official_test_number_id — VARCHAR(255) — NOT NULL
  • which_problem_type — VARCHAR(32) — NOT NULL
  • which_problem_id — BIGINT — NOT NULL
  • user_submitted_answer — VARCHAR(4000)
  • is_correct — BOOLEAN — NOT NULL
  • submitted_at — TIMESTAMP — NOT NULL

user_total_statistics (user_statistics)

  • id — BIGSERIAL — Primary key
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • subject_id — BIGINT — Foreign key → subject.id — NOT NULL
  • problem_type — VARCHAR(32) — NOT NULL
  • total_do_it — 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

users

  • id — BIGSERIAL — Primary key
  • google_id — VARCHAR(255)
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • username — 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

wrong_answer_bookmark

  • id — BIGSERIAL — Primary key
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • problem_type — VARCHAR(32) — NOT NULL
  • problem_id — BIGINT — NOT NULL
  • bookmarked_at — TIMESTAMP
  • review_count — INTEGER