관통프로젝트
테이블 (9)
comment
- comment_id — BIGINT — 기본 키 — NOT NULL
- content — VARCHAR(500) — NOT NULL
- comment_date — TIMESTAMP — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- user_problem_set_id — BIGINT — 외래 키 → user_problem_set.user_problem_set_id — NOT NULL
incorrect_note
- incorrect_note_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- problem_id — BIGINT — 외래 키 → problem.problem_id
- user_problem_id — BIGINT — 외래 키 → user_problem.user_problem_id
- is_user_problem (problem_type) — TINYINT — NOT NULL
member
- member_id — BIGINT — 기본 키 — NOT NULL
- ID — VARCHAR(30) — NOT NULL
- password — CHAR(64) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- email — VARCHAR(30) — NOT NULL
- signup_date — TIMESTAMP — NOT NULL
- status — VARCHAR(10) — NOT NULL — ENUM(active, inactive)
- deleted_date — TIMESTAMP
problem
- problem_id — BIGINT — 기본 키 — NOT NULL
- problem_description — VARCHAR(300) — NOT NULL
- choice_1 — VARCHAR(255) — NOT NULL
- choice_2 — VARCHAR(255) — NOT NULL
- choice_3 — VARCHAR(255) — NOT NULL
- choice_4 — VARCHAR(255) — NOT NULL
- answer_choice (answer) — TINYINT — NOT NULL
- category — VARCHAR(50) — NOT NULL
quiz_room
- room_id — BIGINT — 기본 키 — NOT NULL
quiz_room_member
- quiz_room_member_id — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- room_id — BIGINT — 외래 키 → quiz_room.room_id — NOT NULL
- is_host — TINYINT(1)
user_problem
- user_problem_id — BIGINT — 기본 키 — NOT NULL
- problem_description — VARCHAR(300) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- choice_1 — VARCHAR(255) — NOT NULL
- choice_2 — VARCHAR(255) — NOT NULL
- choice_3 — VARCHAR(255) — NOT NULL
- choice_4 — VARCHAR(255) — NOT NULL
- answer_choice — TINYINT — NOT NULL
- comment_count — INT — NOT NULL
- user_problem_set_id — BIGINT — 외래 키 → user_problem_set.user_problem_set_id — NOT NULL
user_problem_set
- user_problem_set_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
user_score
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- score — INT — NOT NULL