관통프로젝트

테이블 (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