ssomemunity

Tables (5)

answer

  • answer_id — BIGINT — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • question_id — BIGINT — Foreign key → question.question_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

member

  • member_id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255)
  • nickname — VARCHAR(30) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(100)
  • refresh_token — VARCHAR(500)
  • created_at — DATETIME — NOT NULL

question

  • question_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • view_count — INT — NOT NULL
  • like_count — INT — NOT NULL
  • report_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

question_like

  • like_id — BIGINT — Primary key — NOT NULL
  • question_id — BIGINT — Foreign key → question.question_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • created_at — DATETIME — NOT NULL

report

  • report_id — BIGINT — Primary key — NOT NULL
  • question_id — BIGINT — Foreign key → question.question_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • reason — VARCHAR(200)
  • created_at — DATETIME — NOT NULL