8week

Tables (4)

Comment (comments)

  • id — bigInt — Primary key — NOT NULL
  • 게시글 (post_id) — Post — Foreign key → Post.id — NOT NULL
  • 유저 (user_id) — User — Foreign key — NOT NULL
  • 내용 (body) — String

Like (likes)

  • id — bigInt — Primary key — NOT NULL
  • 게시글 (post_id) — Post — Foreign key → Post.id — NOT NULL
  • 유저 (user_id) — User — Foreign key → Post.유저 — NOT NULL
  • 내용 (body) — String

Post (post)

  • id — bigInt — Primary key — NOT NULL
  • 유저 (user_id) — User — Foreign key → User.id — NOT NULL
  • 댓글 (comment_id) — Comment — Foreign key → Comment.id — NOT NULL
  • 게시글 (post_id) — Post — Foreign key → Comment.게시글 — NOT NULL
  • 계정 (username) — String
  • 비밀번호 (password) — String
  • 내용 (contents) — String
  • 제목 (title) — String
  • 좋아요 (likes) — List<Comment>

User (users)

  • id — bigInt — Primary key — NOT NULL
  • 게시글 (post_id) — Post — Foreign key → Comment.게시글 — NOT NULL
  • 계정 (username) — String
  • 비밀번호 (password) — String
  • 권한 (role) — UserRoleEnum