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