썸뮤니티

테이블 (3)

answer

  • answer_id — BIGINT — 기본 키 — NOT NULL
  • content — TEXT — NOT NULL
  • question_id — BIGINT — 외래 키 → question.question_id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

member

  • member_id — BIGINT — 기본 키 — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

question

  • question_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • view_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME