erd 초안

테이블 (11)

article

  • article_id — BIGINT
  • category_id — BIGINT — 외래 키 → category.category_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • summary — TEXT
  • content — TEXT
  • source — VARCHAR(100)
  • original_url — VARCHAR(500)
  • difficulty — VARCHAR(20) — NOT NULL
  • published_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

article_term

  • article_term_id — BIGINT
  • article_id — BIGINT — 외래 키 → article.article_id — NOT NULL
  • term_id — BIGINT — 외래 키 → economic_term.term_id — NOT NULL

category

  • category_id — BIGINT
  • name — VARCHAR(50) — NOT NULL

economic_term

  • term_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT — NOT NULL
  • difficulty — VARCHAR(20) — NOT NULL
  • example — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

member

  • member_id — BIGINT
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • level — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

member_interest

  • member_interest_id — BIGINT
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • category_id — BIGINT — 외래 키 → category.category_id — NOT NULL

quiz

  • quiz_id — BIGINT
  • article_id — BIGINT — 외래 키 → article.article_id — NOT NULL
  • term_id — BIGINT — 외래 키 → economic_term.term_id
  • question — TEXT — NOT NULL
  • quiz_type — VARCHAR(30) — NOT NULL
  • correct_answer — VARCHAR(255) — NOT NULL
  • explanation — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

quiz_attempt

  • attempt_id — BIGINT
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • quiz_id — BIGINT — 외래 키 → quiz.quiz_id — NOT NULL
  • selected_answer — VARCHAR(255) — NOT NULL
  • is_correct — BOOLEAN — NOT NULL
  • submitted_at — DATETIME — NOT NULL

quiz_option

  • option_id — BIGINT
  • quiz_id — BIGINT — 외래 키 → quiz.quiz_id — NOT NULL
  • option_text — VARCHAR(255) — NOT NULL
  • option_order — INT — NOT NULL
  • is_correct — BOOLEAN — NOT NULL

review

  • review_id — BIGINT
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • article_id — BIGINT — 외래 키 → article.article_id — NOT NULL
  • summary — TEXT
  • learned_point — TEXT
  • difficult_terms — TEXT
  • keywords — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

study_log

  • study_log_id — BIGINT
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • article_id — BIGINT — 외래 키 → article.article_id — NOT NULL
  • completed — BOOLEAN — NOT NULL
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL