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