basketball_db

테이블 (3)

게시판 (article)

  • boardId — int — 기본 키 — NOT NULL
  • userId — int — 외래 키 → 유저.userId — NOT NULL
  • title — varchar(255)
  • content — varchar(255)
  • createdAt — timestamp(6)
  • updatedAt — timestamp(6)
  • isDeleted — boolean
  • category — int

댓글 (reply)

  • replyId — int — 기본 키 — NOT NULL
  • boardId — int — 외래 키 → 게시판.boardId — NOT NULL
  • userId — int — 외래 키 → 게시판.userId — NOT NULL
  • reply — varchar(255)
  • createdAt — timestamp(6)
  • updatedAt — timestamp(6)

유저 (user)

  • userId — int — 기본 키 — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • phoneNumber — varchar(15)
  • name — varchar(50) — NOT NULL
  • birthDate — date
  • profileImageUrl — varchar(255)
  • role — varchar(20) — NOT NULL
  • isActive — tinyint — NOT NULL — enum으로 변경
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • lastLoginAt — timestamp