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